| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Get right Excel application
Hi !
In Excel, when 2 differents Excel.Application, there's an error with these lines. Set oExcel = GetObject(, "Excel.Application") Set oWb = oExcel.ThisWorkbook 'ERROR 1004.. Set oXlRng = oWb.Sheets(T(iTab).SheetName).Range("TableOutput") I'm wondering if I could just say: Set oXlRng = ThisWorkbook.Sheets(T(iTab).SheetName).Range("Tabl eOutput") and defined oXlRng as a Range. Should I declare Excel.Range if the word library are open into Excel? Thanks! Alex -- Alex St-Pierre |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Application.Index & Application.Match | Excel Programming | |||
| difference application.quit & application.close | Excel Programming | |||
| Application.GetOpenFilename vs Application.Dialogs(xlDialogsOpen) | Excel Programming | |||
| Replace application.RTD property by Application.RTDServers collect | Excel Programming | |||
| macro to close excel application other than application.quit | Excel Programming | |||
Threaded Mode
