Re: VFP printing an Excel spreadsheet

#1

Set Excel.DisplayAlerts = .f.

Dan

"Rich R." <rich (AT) bittar (DOT) org> wrote

Quote:

Hello all.

I've found the code in this newsgroup on how to create an instance of
Excel, open up the worksheet and print it. It works great. However,
when I issue the oleExcel.quit command, Excel prompts the user to save
the worksheet even though no changes have been made. The user can
either click "No", or press the "TAB" button, then "Enter" to exit the
application.

Is there a way to make it so Excel doesn't prompt the user to save the
spreadsheet, or can VFP somehow tell Excel to click the "No" button?

Thanks again.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: VFP printing an Excel spreadsheet

comp.databases.xbase.fox comp.databases.xbase.fox

Re: VFP printing an Excel spreadsheet - 07-11-2003 , 10:08 AM