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
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
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")
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.