Save As causes Crash!
 

Hello,

I wondered if anyone has come across this problem in the past:

I have an Excel VBA UserForm with a Save As button. It successfully
saves the file as a new file in a location I choose, and then
successfully closes.

I then go to open the NEW file, and it crashes upon Form entry. I get
this error message:

Run-time error '-2147417848 (80010108)':

Automation error
The object invoked has disconnected from its clients.


If I click END or DEBUG it dumps and unloads, and asks to send the
errors to Microsoft.

Save As causes Crash!
 

Okay I guess I should have given specifics, sorry about that! ;)

I have 2 worksheets and an Introductory UserForm that opens when you
enable macros. You read some info on the Intro Userform, and then
click "Next" and that closes the first userform and opens the REAL
userform with all of the code. It is at either the first userform
closing or the 2nd userform opening that causes the program to crash...


Within this userform I have multiple Modules with Public codes. The
XLS is stored on my harddrive on my personal computer right now with
Administrator priviledges. I have Office 2000 and Windows XP with all
the updates.


ducky wrote:
Drummer361 wrote:
Hello,

I wondered if anyone has come across this problem in the past:

I have an Excel VBA UserForm with a Save As button. It successfully
saves the file as a new file in a location I choose, and then
successfully closes.

I then go to open the NEW file, and it crashes upon Form entry. I get
this error message:

Run-time error '-2147417848 (80010108)':

Automation error
The object invoked has disconnected from its clients.


If I click END or DEBUG it dumps and unloads, and asks to send the
errors to Microsoft.

where is your form stored? where are your 2 different workbooks
stored? are you using multiple instances of excel?

AR

Save As causes Crash!
 

It seems that if I go into VB Editor, and save the current Workbook
from that location, then run the Save As command to create a new copy
of the Workbook, then open up that workbook, it works.

But then if I choose to Save As from the NEW workbook, then close it,
and open up the 3rd New Workbook, that Workbook will crash and give me
the error.

I'm finding a pattern slowly.

Any thoughts???

Drummer361 wrote:
Okay I guess I should have given specifics, sorry about that! ;)

I have 2 worksheets and an Introductory UserForm that opens when you
enable macros. You read some info on the Intro Userform, and then
click "Next" and that closes the first userform and opens the REAL
userform with all of the code. It is at either the first userform
closing or the 2nd userform opening that causes the program to crash...


Within this userform I have multiple Modules with Public codes. The
XLS is stored on my harddrive on my personal computer right now with
Administrator priviledges. I have Office 2000 and Windows XP with all
the updates.


ducky wrote:
Drummer361 wrote:
Hello,

I wondered if anyone has come across this problem in the past:

I have an Excel VBA UserForm with a Save As button. It successfully
saves the file as a new file in a location I choose, and then
successfully closes.

I then go to open the NEW file, and it crashes upon Form entry. I get
this error message:

Run-time error '-2147417848 (80010108)':

Automation error
The object invoked has disconnected from its clients.


If I click END or DEBUG it dumps and unloads, and asks to send the
errors to Microsoft.

where is your form stored? where are your 2 different workbooks
stored? are you using multiple instances of excel?

AR