VB and Excel problem - VB corrupts Excel environment 
Author Message
 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?



Thu, 21 May 1998 03:00:00 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. Excel to VB and VB to Excel

2. Accessing VBIDE.VBE.VBProjects via Excel in VB .NET Causes Excel To Crash When App Terminates

3. Accessing VBIDE.VBE.VBProjects via Excel in VB .NET Causes Excel To Crash When App Terminates

4. Accessing VBIDE.VBE.VBProjects via Excel in VB .NET Causes Excel To Crash When Closed

5. Importing from Excel to Excel using VB.

6. Is this doable: drive Excel in VB without Excel installation

7. create EXCEL with VB without EXCEL installed

8. Vb - Excel with excel formulas

9. Excel OLE very slow, can't pass by ref into Excel Macro from VB

10. Write to an Excel file from VB without Excel present

11. optimizing performance and data transfer vb->excel and vb->vb

12. optimizing performance and data transfer vb->excel and vb->vb

 

 
Powered by phpBB® Forum Software