Im very new to excel VB, hopefuly its obvious what im trying to do here, if sombody could just help me make it work..
THIS IS THE BIT I THINK IS CAUSING THE ERRORSub SaveSheetpdf() Dim FileName As String FileName = Range("DriverName") & Range("Date") Range("A2:P59").ExportAsFixedFormat Type:=xlTypePDF, FileName:=FileName & ".pdf" End Sub
FileName:=FileName & ".pdf"
I want to save a file as "cell DriverName" and "cell Date" .pdf
Any help will be greatly received.
Last edited by Solidstan; 02-08-2012 at 05:37 PM.
I Think I may have found a clue, but still can't solve it.
The "Date" cell is "19 February 2012" but the fx shows as 19/02/2012.
Im sure the Back Slash in file names would cause a problem.
Anybody know of a work around for this?
Sorry, didn't realise I had put this in the wrong place.
Im still stuck with this, if somebody could help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks