Hi,
Does anyone know how to automate the printing of Excel sheets each with a different name to a Cute pdf printer?
I have a VBA procedure which uses Windows API calls to write to a system ini file (which I understand is a necessary requirement of the Cute software), which loops through all the sheets I need to print, and sends them one by one to a Cute pdf printer. However each time the 'print' instruction is invoked - I say print but of course this is really a file save process, the Save As dialog box pops up asking the user to confirm the save.
What I want to achieve is the file gets saved automatically, with the relevant sheet name with no confimation dialog box.
Any ideas?
Usual TIA
Bookmarks