View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Neall Neall is offline
external usenet poster
 
Posts: 95
Default Invalid outside procedure (creating a PDF button as a macro)

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.



--
Neall