rustyshackleford
Technical User
Hi,
I'm having a devil of a time with a macro I use to convert a couple hubdred excel files into pdf format for distribution. I have used the macro for months with no problem, but when we switched fiscal years, some changes were made to the source excel document making it significantly larger (from ~300k to ~5 megs). SInce that point in time, whenever I try to use the macro I get the following error message
'Run-Time Error 1004'
Your file could not be printed due to an error on Acrobat Distiller on NE01:. There are several possible reasons:
There may not be enough memeory available. Try closing files and programs you aren't using.
If you use a network for printing there may be a problem with the network connection or the printer driver.
Now, the macro still works fine with the old FY files in a parallel sub-directory. So I don't think it's the network.
I have tried copying the relevent portions of the report to seperate files (reducing their size to ~130K) and then running the PDF macro and still get the error, so it does not appear to be a memory issue (and I run it on a machine with 512MB of RAM anyway).
I am at a complete loss. Any help would be greatly appreciated.
Rhett
I'm having a devil of a time with a macro I use to convert a couple hubdred excel files into pdf format for distribution. I have used the macro for months with no problem, but when we switched fiscal years, some changes were made to the source excel document making it significantly larger (from ~300k to ~5 megs). SInce that point in time, whenever I try to use the macro I get the following error message
'Run-Time Error 1004'
Your file could not be printed due to an error on Acrobat Distiller on NE01:. There are several possible reasons:
There may not be enough memeory available. Try closing files and programs you aren't using.
If you use a network for printing there may be a problem with the network connection or the printer driver.
Now, the macro still works fine with the old FY files in a parallel sub-directory. So I don't think it's the network.
I have tried copying the relevent portions of the report to seperate files (reducing their size to ~130K) and then running the PDF macro and still get the error, so it does not appear to be a memory issue (and I run it on a machine with 512MB of RAM anyway).
I am at a complete loss. Any help would be greatly appreciated.
Rhett
