| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I access an unopened spreadsheet from a program?
Hi folks.
The Workbooks keyword only seems to work for spreadsheets that are already open. I can't seem to say, for example: wkb = Workbooks("Y:\Downloads\6-7.xls") So how do I refer to cells in that spreadsheet without opening it? Any help would be much appreciated! :) -Pete |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Access program | Excel Discussion (Misc queries) | |||
| Move a spreadsheet to an unopened workbook | Excel Worksheet Functions | |||
| any way to access data in unopened excel | Excel Discussion (Misc queries) | |||
| Excel/Access Program | Excel Programming | |||
| Calling Access Program from Excel | Excel Programming | |||
Threaded Mode
