Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: GrahamAdshead
- Order by date
-
Refering to cells in different workbooks
Hi. NextBook is a variable that contains the full path to a file that I want to search. e.g. NextBook = "C:\\........\MyFile.xls" I want to search a series of files for a number (WkNo) and then put the data from an adjecent cell into another file. NextBook's value is found by using the...- GrahamAdshead
- Post #5
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Refering to cells in different workbooks
Thanks for your help. Can you tell me why this code doesn't work? If Nextbook.Worksheets("Rework").Cells(x, y) = WkNo Then ThisWorkbook.Worksheets("Sheet1").Cells(PrRow, 7) = WkNo End If It calls up "Error 424 Object required", but I thought that "NextBook.Worksheets" were the objects. Thanks.- GrahamAdshead
- Post #3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Refering to cells in different workbooks
I am trying to write a macro to : 1. search a series of workbooks for a particular value on a particular worksheet (called "Rework") using a For-Next loop. 2. take the value of an adjecent cell and place it in a particular cell in a "master" workbook. I can find and open each workbook, but how...- GrahamAdshead
- Thread
- Replies: 5
- Forum: VBA Visual Basic for Applications (Microsoft)
