I would like to use XlFixedFormatType to export an Excel 2007 to a pdf file
format with a variable file name from a cell in a macro. I have used this:

Sub SaveWithVariableFromCell()
Dim SaveName As String
SaveName = ActiveSheet.Range("b8").Text
ActiveWorkbook.SaveAs Filename:="D:\pat's delivery\invoice\" & _
SaveName & ".xls", FileFormat _
:=xlExcel8, Password:="", WriteResPassword:="",
ReadOnlyRecommended:= _
False, CreateBackup:=False
and it works as a excel file.

Is this posible?

See this page William
http://www.rondebruin.nl/pdf.htm

You can point FilenameStr to a cell value


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"William Jones" wrote in message ...
I would like to use XlFixedFormatType to export an Excel 2007 to a pdf file
format with a variable file name from a cell in a macro. I have used this:

Sub SaveWithVariableFromCell()
Dim SaveName As String
SaveName = ActiveSheet.Range("b8").Text
ActiveWorkbook.SaveAs Filename:="D:\pat's delivery\invoice\" & _
SaveName & ".xls", FileFormat _
:=xlExcel8, Password:="", WriteResPassword:="",
ReadOnlyRecommended:= _
False, CreateBackup:=False
and it works as a excel file.

Is this posible?