Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Microsoft VBA
|
|
|
The UK's most regular Training information: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Microsoft VBA
Resolved · Low Priority · Version 2007
Reply Wed 27 Jul 2011, 12:00Delegate James said...
James has attended:
Excel VBA Intro Intermediate course
Microsoft VBA
I have a sheet where a branches financials are selected using a drop down box and the info is brought through from hidden tabs using a indirect formula.
I am trying to print each location without manually working through the list and printing.
I have a macro to change the location and also a macro to print, however it only prints what is shown on the screen at that time. The macro works through the changing locations much quicker than the printer is able to process the print jobs so it may end up printing every 5th location.
The only way around this i have found is to build a msgbox after each print command and it then does not print again until ok is clicked. Is there any easy way of automating a loop to not loop until after the printer has confirmed receipt of the print job?
I am guessing no, but thought it may be worth asking anyway.
Thanks,
James
For upcoming training course dates see: Pricing & availability
Reply Wed 27 Jul 2011, 17:04Delegate James said...
RE: Microsoft VBA
Sorry I should have said that I am printing to a PDF printer.
When i print to a normal printer it works fine.
Many thanks,
James
|