I have a workbook with an invoice sheet and have a macro to print it to pdf then send the data to a sheet called register with the invoice information and a link to the pdf.
The only thing I cannot get it to do is export to pdf. Dont know if the invoice layout is the problem. But I'm using a very simple layout.
Using Office 2013.
Here is the VBA:
Please Login or Register to view this content.
Last edited by Kenbo; 07-01-2015 at 11:45 PM.
are any of these cells a date?Please Login or Register to view this content.
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
yes D7 is a date
date will return DD/MM/YYYY in the US
you cant save files with "/"
try this instead
Please Login or Register to view this content.
Gave me a syntax error
does this give you syntax error as well?
if not what does msgbox say?Please Login or Register to view this content.
That did the trick! Thank you so much for your time and help!
not a problem
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
Done...Thanks again
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks