Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I've written some could that launches excel and populates a new
worksheet using COM, Unfortunately, when I launch Excel through my COM script, it does not open my hidded Personal.xls workbook. I need this to open for the user so they can use macros that are stored there. Any ideas?? TIA Here's a snippet of my code: Dim xlApp As Variant Dim xlsheet As Variant Set xlApp = CreateObject("Excel.Application") xlApp.StatusBar = "Creating WorkSheet. Please be patient..." xlApp.Visible = True xlApp.Workbooks.Add xlApp.ReferenceStyle = 2 Set xlsheet = xlApp.Workbooks(1).Worksheets(1) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Personal.xls gone | Excel Discussion (Misc queries) | |||
Personal.xls opens when I launch Excel | Excel Discussion (Misc queries) | |||
problem from Personal.xls | Setting up and Configuration of Excel | |||
Personal.xls | Excel Discussion (Misc queries) | |||
Personal.xls and Excel.xlb | Excel Discussion (Misc queries) |