| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open Excel workbook from Access
On Nov 5, 12:26*pm, "Jim Cone" wrote:
The Set statement establishes a reference to the sheet. You can then use that reference in your code. If you want to display the sheet then try... xlWsh.Activate -- Jim Cone Portland, Oregon *USA "Opal" wrote in message ... Thank you Jim, that is very helpful. *One more question, I thought the line: Set xlWsh = xlWkb.Worksheets("Main") would open the workbook on the tab labeled Main, but I have been testing it and its not. *Any suggestions? Thank you, that's very helpful. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Opening Excel, Book1 opens, remains open with other workbook open | Excel Discussion (Misc queries) | |||
| Access Data from Workbook without seeing the workbook open. | Excel Programming | |||
| Open a specific workbook...find value from other open workbook and then insert cells values in cell next to it. | Excel Programming | |||
| excel 2003 saved file will not open without a blank workbook open | Excel Discussion (Misc queries) | |||
| Open excel workbook in access | Excel Programming | |||
Threaded Mode
