Facing Error for saving a PDF file

sadaqatt

New Member
Joined
Jan 31, 2023
Messages
25
Office Version
  1. 365
  2. 2021
Platform
  1. MacOS
Hi,
I am facing an error for saving the file as a PDF, I don't know why it is showing an error, the same code I used on another PC it worked absolutely fine. Any one can help please? URGENT
 

Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.
kindly check the screenshots below
 

Attachments

  • 11.png
    11.png
    242 KB · Views: 13
  • 2.JPG
    2.JPG
    248.3 KB · Views: 13
  • Highcompressed_754271368.jpg
    Highcompressed_754271368.jpg
    165.8 KB · Views: 12
Upvote 0
Can you tell exactly what values are stored in WS1.Range(“E11”) and WS1.Range(“E12”)?

Artik
 
Upvote 0
on E11 is Date and E12 is invoice number
but my main concern is same vba code is working on another PC perfectly fine but I have changed to new pc it is showing error while saving the invoice as PDF
 
Upvote 0
Depending on the date format, it may contain invalid characters for a file name. Your code should format the date appropriately - e.g. Format$(WS1.Range(“E11”).Value, "yyyy-mm-dd")
 
Upvote 0
this is the main sheet
 

Attachments

  • 4-invoice.png
    4-invoice.png
    223.4 KB · Views: 8
Upvote 0
You said E11 is a date and that is part of the file name in your code.
 
Upvote 0
Yeah sorry I work now Thanks, but one another issue came now the invoice sheet is lot getting clear when hitting the next invoice button
 
Upvote 0

Forum statistics

Threads
1,224,817
Messages
6,181,144
Members
453,021
Latest member
Justyna P

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