N
Neall
I found some steps to enable me to save a worksheet as a PDF but I am getting
the invalid outside procedure error from this line
Filename = "c:\Folder1\SubFolder1\" & ActiveSheet.Range("InvNbr").Value &
".pdf"
apparently this line "' This line of code specifies your directory as well
as the cell or range which you want the filename to come from. As you can
see, I have a specific cell with the range name "InvNbr" so that the macro
knows to pull the filename from there. If you don't want to use a range name,
just replace InvNbr with your cell reference, such as C4."
Any suggestions, really what I want to do is make the dir path generic to
always save to the persons desktop, but for now I want to test this to get it
working so I created a sample folder dir.
Any help would be great as I don't create Macros very much at all.
the invalid outside procedure error from this line
Filename = "c:\Folder1\SubFolder1\" & ActiveSheet.Range("InvNbr").Value &
".pdf"
apparently this line "' This line of code specifies your directory as well
as the cell or range which you want the filename to come from. As you can
see, I have a specific cell with the range name "InvNbr" so that the macro
knows to pull the filename from there. If you don't want to use a range name,
just replace InvNbr with your cell reference, such as C4."
Any suggestions, really what I want to do is make the dir path generic to
always save to the persons desktop, but for now I want to test this to get it
working so I created a sample folder dir.
Any help would be great as I don't create Macros very much at all.