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