Ok. I have to use VB for this application. No choice here. The thing is complete... all 2000 lines of it.... It generates Water Analysis FORMS.
It does this for hundreds of locations...
Anyways. In addition to printing these forms, which it does already, it needs to spit out a PDF. Excel cannot do this, apparently, with VB. You can't tell it to do something like destination.PrintOut PrintToFile:= theFilePath
So, many hundreds of locations, one can't just sit there typing file paths for each PDF they want to generate. Anyone got any ideas?
I can sort of get it to work with AppleScript... but you have to print a worksheet to a PDF first... or else it just prints to the printer.
Or am I just dreaming? Sigh.
Top
