Outlook Macro Fails to run Excel macro with Visibility = False

I'm trying to run an Outlook macro that automatically emails a pdf. The Outlooks macro also launches an Excel macro which run a report and creates a pdf. However, the Outlook macro fails when objExcel.Visibility=False but works fine when objExcel.Visibility=True. Maybe someone can help with what is goining on here as to run with Visibility=True is very annoying.

Please Login or Register  to view this content.

Adding

Please Login or Register  to view this content.

at the beginning of the Sub freezes the screen but your macro will still be running.
Remember to set screen updating to True at the end of the Sub.

Please Login or Register  to view this content.

I’m a novice at VB coding but I could not find ScreenUpdating in the Outlook object library (this is an Outlook macro that runs an Excel macro) - any other thoughts? Here’s the code again. I rearranged it some to make it easier to follow. The code runs as below but changing objExcel.Visibility = False, it crashes at objExcel.Run ("RunReport").

Please Login or Register  to view this content.

Hi, rvdurham,

Fotis1991 has added code-tags to your opening post for you to comply with the Forum Rules but you should do it for your last post by yourself:


Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here



(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

Ciao,
Holger