| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I access a sheet in another workbook using VBA?
Greetings everyone!
How do I access a sheet in another workbook? Currently, I do the cheesie method of referencing it from within the cell, but I always have to over copy the rows since I don't know when I've reached the last non-empty row. I want to be able to write some VBA code that will loop thru the sheet in one workbook and write the info into a sheet in another work. Thanks as Always! Kurt |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Linking workbook and range protected Excel sheet to Access | Excel Discussion (Misc queries) | |||
| Read-only access by SHEET (not workbook). Is it possible? | Excel Worksheet Functions | |||
| link Access workbook to Excel workbook | Excel Discussion (Misc queries) | |||
| Using ADO to access another workbook | Excel Programming | |||
| Can't access to a WorkBook | Excel Programming | |||
Threaded Mode
