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

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying
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,214,798
Messages
6,121,630
Members
449,041
Latest member
Postman24

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