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 |
All times are GMT +1. The time now is 01:32 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com