save as pdf run time error

moorly

New Member
Joined
Dec 25, 2021
Messages
8
Office Version
  1. 2007
Platform
  1. Windows
Not able to save pdf file getting run time error, as per screen shot attached, please correct.
 

Attachments

  • pdf.JPG
    pdf.JPG
    56.8 KB · Views: 5

Excel Facts

Back into an answer in Excel
Use Data, What-If Analysis, Goal Seek to find the correct input cell value to reach a desired result
What does the error say?
What do you have in cells B5 and B6?

In future please use code tags when posting code.
How to Post Your VBA Code it makes your code easier to read and copy and it also maintains VBA formatting.
 
Upvote 0
What does the error say?
What do you have in cells B5 and B6?

In future please use code tags when posting code.
How to Post Your VBA Code it makes your code easier to read and copy and it also maintains VBA formatting.
run time error 1004 as per screen shot,
Cell B5 : Number
Cell B6 : Text
 

Attachments

  • vouch.JPG
    vouch.JPG
    91.6 KB · Views: 4
Upvote 0
Is the "Trust access to the VBA project object model" in Excel Options - Macro Settings checked?
 
Upvote 0
The filename cannot contain a slash "/". Change it to a dash "-" or underscore "_".


1667473483737.png
 
Upvote 0

Forum statistics

Threads
1,215,425
Messages
6,124,822
Members
449,190
Latest member
rscraig11

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top