ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Invalid outside procedure (creating a PDF button as a macro) (https://www.excelbanter.com/excel-worksheet-functions/229390-invalid-outside-procedure-creating-pdf-button-macro.html)

Neall

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