LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
 
Posts: n/a
Default personal.xls doesn't launch in COM

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Personal.xls gone Zurn Excel Discussion (Misc queries) 6 April 26th 06 08:10 AM
Personal.xls opens when I launch Excel kenk Excel Discussion (Misc queries) 1 December 7th 05 03:18 PM
problem from Personal.xls Tom Setting up and Configuration of Excel 4 July 4th 05 11:38 PM
Personal.xls Cathy Excel Discussion (Misc queries) 1 January 28th 05 12:50 AM
Personal.xls and Excel.xlb Terry Excel Discussion (Misc queries) 1 January 26th 05 01:49 AM


All times are GMT +1. The time now is 01:25 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"