Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Sometimes external applications etc. cannot accept data as fast as th
macro can send it, so something has to give - usually the macro. This looks like your problem. A way of getting round this is to pu delays in the programme to allow for this. eg. 10 seconds .. Application.Wait Now + TimeValue("00:00:10") I suggest you dalso try an 'On Error Goto' line to exit more gracefull while you are tweaking this to see what is suitable. I did do one som time ago for a printer that included a wait line and included anothe On Error line to keep trying/waiting. Can't find it though -- Message posted from http://www.ExcelForum.com |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
setting the default printer for this workbook only | Excel Worksheet Functions | |||
Copy printer setup to new sheet in workbook | Excel Discussion (Misc queries) | |||
Error Settind Default Printer in VBA | Excel Discussion (Misc queries) | |||
Printing all worksheets in a workbook using a duplex printer | Excel Discussion (Misc queries) | |||
Macro to assign a printer to a workbook | Excel Programming |