Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have been trying some of the posts here to help with this but no luck so
far. I have an access DB that open Excel, processes the sheets there and then closes. I have an instance of Excel still running that is only accessible through the task manager. I need to figure out what I am doing wrong with the following code. Dim xlApp As Excel.Application Dim xlBook As Excel.Workbook Dim xlSheet As Excel.Worksheet ExcelTab = "Q1-Insvc_Disc Data" Set xlApp = New Excel.Application Set xlBook = xlApp.Workbooks.Open("C:\temp\Video Churn Report_v_2007_06_22", 0, False) Set xlSheet = xlBook.Worksheets(ExcelTab) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel hanging... | Excel Discussion (Misc queries) | |||
Excel hanging up? | Excel Programming | |||
How do I get one instance of Excel to communicate with another instance? | Excel Programming | |||
Excel-created Word instance hanging on thru Outlook? | Excel Programming | |||
Excel hanging up | Excel Programming |