create macro for save as PDF

C

cdumas

I'm trying to create a macro to save an Excel workbook (entire workbook) as
PDF. However, when I run the macro, it defaults to the original workbook
name, not the name of the new workbook. Is there some "wildcard" I can put
in the workbook name to default to the current name when saved? Thanks for
any help.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top