Excel Automation and BeforePrint Event

M

mdgrosse

Hello
I have a program, which uses automation to modify and print out several
Excel files. Now I want to use a macro in BeforePrint to do some sorting (I
know that I could do sorting with autmation too, but the users of my sofware
can add their own Excel files and my software cant know how to sort these
files). The macro works fine when the file is printed manually. But when I
print the document using automation the sorting is not done. When I put a
MsgBox into the Macro I can see, that the Macro is excuted.

thx
Michael
 

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

Top