
VB and Excel problem - VB corrupts Excel environment
I'm new to VB 3.0, but have lots of Excel experience. I created a simple
front end
in VB that simply starts Excel, executes an Auto_Start routine, saves and
quits.
The Excel application runs fine standalone, but when I execute it from VB
I
suddenly lose some of my add-ins, particularly ATVBAEN.XLA. The choice
disappears from the add-in menu, and if I try to load it through the
Browse dialog I
get an message saying that it is not a valid add-in. If I exit and
restart Windows,
it reappears on the add-in menu and I can reload it with no problems.
Also, when running Excel from VB and saving, I get a prompt asking if I
want to
save a file called RESUME.XLW, which was created in the VB directory.
This
is a very small file, less than 300 bytes. If I double click on it in
File Manager
it loads the spreadsheet I used in the application I'm discussing here,
which is
named PUBTRAK.XLS. What is the purpose of this file?
Does anyone know what's going on here?