Suppress the save alert message while printing an excel document using ShellExecute

Asked Jul 31 '14 at 12:19

Active Jul 31 '14 at 12:30

Viewed 151 times

I'm writing a C++ code with WINAPI() and I need to print many excel documents by using the ShellExecute() function as shown below:

ShellExecute(NULL,"print","c:\\printdocs\\test1.xls",NULL,NULL,SW_SHOWNORMAL);

The above command works fine and prints the Excel document, but the particular excel document is getting opened and an alert message is getting displayed saying 'Do you want to save the changes you made to test1.xls' for every excel document.

Here I don't want the excel sheet to be opened and I need to bypass the alert display so that the all excel documents are printed silently in the background. Please tell me how to print the excel documents silently in the background using shellExecute().

edited Jul 31 '14 at 12:30

gnuanu

2,252
3
29
42

asked Jul 31 '14 at 12:19

balusingam

You cannot do this with `ShellExecute` I expect. You'll need to automate Excel. – David Heffernan Jul 31 '14 at 15:33
is there any other way to silently print an excel file. please help me with this. im almost at the end of my project but this thing is bugging me alot. – balusingam Aug 01 '14 at 05:38
Try with automation. But doing this through excel possibly not the ideal way to print. – David Heffernan Aug 01 '14 at 05:44
could u please be more specific about what and where i need to do this automation... – balusingam Aug 01 '14 at 06:05
Do a web search for excel automation – David Heffernan Aug 01 '14 at 06:07

Suppress the save alert message while printing an excel document using ShellExecute

0 Answers0