Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Run-time Error '5' - Invalid procedure call or argument | Excel Discussion (Misc queries) | |||
Creating a Macro Button to Extract Data | New Users to Excel | |||
Creating a macro that simulates some of the toolbar button | New Users to Excel | |||
Run-time error '5': Invalid Procedure Call or Argument | Excel Discussion (Misc queries) |