Skip to main content
A
Anonymous
April 26, 2016
Answered

.Xlsm to .Pdf conversion

  • April 26, 2016
  • 1 reply
  • 4797 views

I am looking for a way to take many files in Folder A and move them to Folder B with a different file extension. The files in Folder A are saved as .Xlsm and will ultimately become .Pdf. I found a macro I was able to modify and perform this task, but the .Pdfs become damaged and are unable to be opened. Anyone with a similar issue or solution?

This topic has been closed for replies.
Correct answer try67

I see, I tried this as well and it works essentially the same way. Still exploring how to disable the Auto Save option once each .PDF is created though. Having to click no for each of the 100+ files being converted isn't terrible but it would be nice to not have to perform that step. Thanks again


If it still doesn't work then try using a Save command with the "PDF Optimizer" option ticked on, although it doesn't have to actually perform any optimizations. I tried it with docx files and it worked fine.

1 reply

try67
Community Expert
try67Community Expert
Community Expert
April 26, 2016

You can't just rename a file from one extension to another and expect it to

work. You have to actually convert the file format.

Using Acrobat Pro you can do it with an Action.

On Tue, Apr 26, 2016 at 5:34 PM, thenderson8 <forums_noreply@adobe.com>

A
Anonymous
April 26, 2016

try67,  Thanks and I agree, yesterday afternoon I noticed that the name was only changed causing the file to be damaged. I have now created an action to save the files as a .pdf in a new folder. The action is currently running but I keep getting prompts to "Save changes to ""File XYZ"" before closing". There are over 100 files in the folder and I keep getting the same prompt to save the excel file before the.pdf is created. I know for certain that I do not have any of these files open, is there to turn off a setting in Actions to prevent the prompts to save from opening?

A
Anonymous
April 26, 2016

The Action will automatically convert non PDF-files to PDF and save them in

the same folder as the originals, so maybe just add a blank "Execute a

JavaScript" command or something and then run it on your files.

Just make sure the "Prompt User" box under the command is not ticked.

On Tue, Apr 26, 2016 at 9:43 PM, Thenderson8 <forums_noreply@adobe.com>


I gave the blank Execute a JavaScript command a try after the Save to Local Folder command. No luck so far, still getting the  "Save changes to ""File XYZ"" before closing" message after each PDF is created. Ill do some searching around and see if there is anything else I can do. Thanks for the assistance try67, really appreciate it.

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices