Sir,
Please help me to solved the issues .When I run the macro its showing "run time error 5 or invalid procedure or call argument.
I want save the file in PDF in specific location,my code is given below.
Sub saveinvoice()
Sheet2.Range("A1:l57").ExportAsFixedFormat Type:=xlTypePDF, Filename:="C:\Users\USER\Desktop\inventory\" & Sheet2.Range("j11").Value & ".pdf", openafterpublish:=True
End Sub
Regards
Manoj
I tried your code, it is working well. There is an error in your Filename (C:\Users\USER\Desktop\inventory\), remove the last slash.
Code looks fine, cannot replicate same error
two things to check
is your Directory accurate and you have write access?
is the value in J11 a filename of which Windows allows?
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.
One other - what version of Excel do you have? The creation of PDF was introduced with Excel 2007 so the functionality won't work on Excel 2003 and earlier (though I doubt that's the issue to be honest but just good to rule it out).two things to check
is your Directory accurate and you have write access?
is the value in J11 a filename of which Windows allows?
____________________________________________
Please ensure you mark your thread as Solved once it is. Click here to see how
If this post helps, please don't forget to say thanks by clicking the star icon in the bottom left-hand corner of my post
Chandy,
I removed the last slash as you suggested but reflecting the same issues.My file is attached for your reference.
C:\Users\USER\Desktop\inventory
I am using 2007.My file is attached for your reference.
i gave my own folder name, it is working well try again.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks