Save as PDF code issues

[sxschech]

I've been using the save as PDF code in two different Excel files for a year now without incident. Last week, one of the files, when I clicked on the "Print to PDF" button, the code executed, but the popup Acrobat box indicated it was saving to XLS rather than PDF. As far as I know, I have not changed any settings in either Excel or Acrobat 7 Professional. Normally after the popup goes away, Acrobat is opened and the file I "printed" is displayed. This time, it opened a new excel window and post-script text was displayed. I was able to "fix" the problem by copying a file I had from the week before and updating all the information that took place in the interim. This week, the same thing happenned with another excel file. When I tried to "fix" it by copying an older file which printed to pdf the week before, it didn't "solve" the problem. Was wondering if anyone might have another idea or suggestion to get things printing to pdf once again. I also had IT reinstall Acrobat Prof 7 on my hard disk, but that didn't help.

 

[Chance1234]

IT havetn done anything like update acrobatreader on everyone machine have they ?

go to references and check the adobe refrences.

Chance,

F, G + _HH

 

[sxschech]

Hi Chance,

Thanks for responding. I checked the tools references in the Microsoft Excel VBA (Alt+F11)) and did not see any references to adobe. I tried ticking on some adobe references and recompiling, but it did not fix the issue. I then decided to try going back a week at a time in the backup files until I found a version that still printed to PDF properly. I checked the references in that one and it didn't have any adobe items either. So after entering 3 week's worth of data, I was finally able to print the reports to PDF. I guess that something must have corrupted the file(s) in the last two weeks? I'm sure glad that I had the backups.

 

[WalkerEvans]

sxschech,

I think you may have missed what Chance was trying to tell you. Don't try to find an answer in either Excel or VBA ... the answer likely lies in Adobe. Check to see if any changes were made to Adobe around the time when you started having these problemms. Also, check your System Restore points to see if any changes are showing at about this same time.

These are quick checks and could point you in the right direction in a really short time. In any case they're simple and fast and can't leave you any worse off than you are now.



----------------------------------------------------------------------------------
"A committee is a life form with six or more legs and no brain." -- L. Long