Thread: XLStart and VB
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default XLStart and VB

oxlApp.Workbooks.Open oxlApp.Path & "\xlStart\personal.xls"

--
Regards,
Tom Ogilvy


"Tod" wrote in message
ups.com...
I have a VB application that launches Excel:

XL = CreateObject("Excel.Application")

Then either opens a workbook or creates a new workbook.

Anyway, I created an application-level event in Excel to write to a
text file any time Excel is opened. I created the event in the
Personal.xls workbook since it opens when Excel does. I tested it by
opening various workbooks and it worked.

But here's the thing. When VB opens Excel, the personal.xls workbook
does not open. In fact nothing I put in the XLStart folder opens. Does
VB somehow bypass the XLStart folder?

What can I do as an alternative?

tod