Excel.Quit

  • Thread starter Thread starter jj
  • Start date Start date
J

jj

Hi,
I am woking on Access 2000 VBA.
Does anyone know how to avoid the prompt while in using
Excel.quit?
Any suggestion is appreciated.

jj
 
Thanks for respone.

Yes, the prompt ask for saving data back to open Excel
from Access Form.

jj
 
Uou could try setting the DisplayAlerts property of the
Excel Application object to False

Hope This Helps
Gerald Stanley MCSD
 
hi,
Sorry, no luck!..>_<"
Access VBA still prompts the same message after I took
off check the DisplayAlerts from Excel properties.

"A file named '...book1.xls' already exists in this
location. Do you want to replace it?" from Excel.Close

"do you want to save the changes you made
to 'Book1.xls'?" from [Excel.Quit]

Anyway can silence the message prompts while data insert
into Excel from Access application?

Thanks.
 
The only alternative I can think of is to close all the
workbooks programmatically.

Hope This Helps
Gerald Stanley MCSD
-----Original Message-----
hi,
Sorry, no luck!..>_<"
Access VBA still prompts the same message after I took
off check the DisplayAlerts from Excel properties.

"A file named '...book1.xls' already exists in this
location. Do you want to replace it?" from Excel.Close

"do you want to save the changes you made
to 'Book1.xls'?" from [Excel.Quit]

Anyway can silence the message prompts while data insert
into Excel from Access application?

Thanks.

-----Original Message-----
Uou could try setting the DisplayAlerts property of the
Excel Application object to False

Hope This Helps
Gerald Stanley MCSD
.
Click to expand...
.
Click to expand...
 
<sighs>
even to use Excel.Close true "book1.xls"
It brings up the prompt, then, I have two prompts
messages from both Excel.close and Excel.quit...>_<"

crying jj

-----Original Message-----
The only alternative I can think of is to close all the
workbooks programmatically.

Hope This Helps
Gerald Stanley MCSD
-----Original Message-----
hi,
Sorry, no luck!..>_<"
Access VBA still prompts the same message after I took
off check the DisplayAlerts from Excel properties.

"A file named '...book1.xls' already exists in this
location. Do you want to replace it?" from Excel.Close

"do you want to save the changes you made
to 'Book1.xls'?" from [Excel.Quit]

Anyway can silence the message prompts while data insert
into Excel from Access application?

Thanks.

-----Original Message-----
Uou could try setting the DisplayAlerts property of the
Excel Application object to False

Hope This Helps
Gerald Stanley MCSD
-----Original Message-----
Thanks for respone.

Yes, the prompt ask for saving data back to open Excel
from Access Form.

jj

-----Original Message-----
Can you describe the prompt that you are talking about.

Gerald Stanley MCSD
-----Original Message-----
Hi,
I am woking on Access 2000 VBA.
Does anyone know how to avoid the prompt while in using
Excel.quit?
Any suggestion is appreciated.

jj
.

.

.

.
Click to expand...
.
Click to expand...
.
Click to expand...
 
Before closing the workbook, it might be an idea to see if
there is already a workbook present with the same name and,
if so, delete it.

Hope That Helps
Gerald Stanley MCSD
-----Original Message-----
<sighs>
even to use Excel.Close true "book1.xls"
It brings up the prompt, then, I have two prompts
messages from both Excel.close and Excel.quit...>_<"

crying jj

-----Original Message-----
The only alternative I can think of is to close all the
workbooks programmatically.

Hope This Helps
Gerald Stanley MCSD
-----Original Message-----
hi,
Sorry, no luck!..>_<"
Access VBA still prompts the same message after I took
off check the DisplayAlerts from Excel properties.

"A file named '...book1.xls' already exists in this
location. Do you want to replace it?" from Excel.Close

"do you want to save the changes you made
to 'Book1.xls'?" from [Excel.Quit]

Anyway can silence the message prompts while data insert
into Excel from Access application?

Thanks.


-----Original Message-----
Uou could try setting the DisplayAlerts property of the
Excel Application object to False

Hope This Helps
Gerald Stanley MCSD
-----Original Message-----
Thanks for respone.

Yes, the prompt ask for saving data back to open Excel
from Access Form.

jj

-----Original Message-----
Can you describe the prompt that you are talking about.

Gerald Stanley MCSD
-----Original Message-----
Hi,
I am woking on Access 2000 VBA.
Does anyone know how to avoid the prompt while in
using
Excel.quit?
Any suggestion is appreciated.

jj
.

.

.

.

.
Click to expand...
.
Click to expand...
.
Click to expand...
 
Thanks for response.
The workbook should be there to wait for inserting data.

Since I get two prompts for asking "save before close"
from Excel.Close and Excel.Quit, none of these prompts
are want I want. I just want it to save quietly. >_<"

maybe there is no way to stop the prompts.
Thanks for trying.

jj
-----Original Message-----
Before closing the workbook, it might be an idea to see if
there is already a workbook present with the same name and,
if so, delete it.

Hope That Helps
Gerald Stanley MCSD
-----Original Message-----
<sighs>
even to use Excel.Close true "book1.xls"
It brings up the prompt, then, I have two prompts
messages from both Excel.close and Excel.quit...>_<"

crying jj

-----Original Message-----
The only alternative I can think of is to close all the
workbooks programmatically.

Hope This Helps
Gerald Stanley MCSD
-----Original Message-----
hi,
Sorry, no luck!..>_<"
Access VBA still prompts the same message after I took
off check the DisplayAlerts from Excel properties.

"A file named '...book1.xls' already exists in this
location. Do you want to replace it?" from Excel.Close

"do you want to save the changes you made
to 'Book1.xls'?" from [Excel.Quit]

Anyway can silence the message prompts while data insert
into Excel from Access application?

Thanks.


-----Original Message-----
Uou could try setting the DisplayAlerts property of the
Excel Application object to False

Hope This Helps
Gerald Stanley MCSD
-----Original Message-----
Thanks for respone.

Yes, the prompt ask for saving data back to open Excel
from Access Form.

jj

-----Original Message-----
Can you describe the prompt that you are talking about.

Gerald Stanley MCSD
-----Original Message-----
Hi,
I am woking on Access 2000 VBA.
Does anyone know how to avoid the prompt while in
using
Excel.quit?
Any suggestion is appreciated.

jj
.

.

.

.

.

.
Click to expand...
.
Click to expand...
.
Click to expand...
 
Back
Top