XLStart and VB

[Tod]

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

 

[Tom Ogilvy]

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