Opening Plublisher fron Excel

[Jazzmann]

What am I missing? this code for the most part works but the application stays minimized on the task bar. I trying to open it up full screen.

Please Login or Register  to view this content.

Thanks

[shg]

Never used Publisher, but I'd speculate it's like Excel and Word:

Change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

[Jazzmann]

Tried that first but that gives a compile error: method or data member not found

[shg]

Mmm. It appears that the ActiveWindow is a property of the active document, not the application. Maybe ...

Please Login or Register  to view this content.

[Jazzmann]

Shg, thanks for your help with this. Most of the time I can figure this stuff out, but this one is a problem especially since there is not a lot of info on Publisher on the net. In reference to your suggestion, no luck. It gives the same result. Like I mentioned in my first post, this code does open publisher with the correct file, but it just stays minimized on the task bar. This would be alright with me but I have some colleagues that need things right in their face . Might need to convert the sheet to word but that will mean I'll have to convert around 40 sheets