Morning,
I am trying to automate a weekly report to save as an Excel file on Series 7 Version 4 but when I save it from the Macro it moves columns, merges data and generally changes things. If I run the same report manually and save it as .xls it seems fine, this is getting really irritating as...
This is the current Macro I have:
Dim ImpAppObject as Object
Dim ImpRepObject as Object
Dim PDFPubObject as Object
Sub Main()
Set ImpAppObject = CreateObject("Impromptu.Application")
ImpAppObject.OpenCatalog "\\csdpr15ap\codadir\Impromptu\codalive.cat", "Creator"...
Hello,
I am writing a macro to automate a Letter report and I can't seem to get the cascading prompt windows to work properly.
How do I get the macro to press OK to get from one Prompt window to the next.
I hope this makes sense,
Thanks,
Becca
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.