Disable Poups

  • Thread starter Thread starter Haarish
  • Start date Start date
H

Haarish

Hi All,

I have a function which I am opening using the ShellExecute method to
Print. I have two issues in doing the same.

1. For password protected files, I am not able to catch the password
protected errors when I enter the wrong password. How do I catch the
error with the above statement?
2. After the file has been printed, since I am using Excel 2007 and
the source files are Excel 2003 - it prompts me asking if I want the
file to be saved. I do not want to save the file always.
Application.DisplayAlerts = False does not work. How do i disable the
save dialog?

Any ideas?

Thanks in advance,
Haarish.
 
Hi,

2. Set the saved property True after the file has been printed.

ActiveWorkbook.Saved = True

Regards,
Per
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

'Save as' dialog opens despite Application.DisplayAlerts = False 6
Skip password protect files and open non protected files 5
save and exit macro 8
including macro in protected worksheet 2
Iterative consolidation macro can't complete - memory overload? 5
Protect a Workbook 3
How to Unlock Excel Workbook protected by MACRO Password 6
Possible error in VBA Workbooks.Open method for xlsx file 0

Back
Top