How would I set the location to always save PDF to where the workbook is currently located?
@SamHolmes06
25 күн бұрын
Is there anyway of not having the PDF save automatically and just having it open an unsaved PDF to the user is prompted to save it to their computer?
@judyl.7811
Ай бұрын
4:00 you will never overwrite a file by generating a unique number. 5:50 let's how to streamline the workflow with a few lines of codes.] VBA and Macro to automate the workbook
@petrkozakcz
Жыл бұрын
Thank you for the tutorial. The way you explain the topic is straight to the point, clear and well structured. Simply great!
@jnorton47a
Жыл бұрын
When I try to open the file I get a message that the file contains a harmful virus and I can not open the file because of that. Any suggestions?
@TeachExcel
Жыл бұрын
I'm pretty sure that it said something like: "files from the internet Can contain..." This happens when you download an Excel file with macros from the web. If you don't feel comfortable downloading it and enabling the code, then you can always pause this video and write the code out by hand and it will work just fine.
@jnorton47a
Жыл бұрын
I did re-write the code by hand but I got an error message. I do not know how to debug it. @@TeachExcel
@ianrobertson5128
Жыл бұрын
Hi Thanks for the tutorial. Can you adapt the for a Mac?
@EdwardRiachy
Ай бұрын
same question
@shueybamin5244
Жыл бұрын
HI, I'm getting a run-time error 1004?
@TeachExcel
Жыл бұрын
Hi there, you probably need to update the file location in the macro to a directory that exists on your computer.
@shueybamin5244
Жыл бұрын
@@TeachExcel thanks
@SteveLongmoor
Жыл бұрын
Looks great! Where can I get a copy of the file that has been referenced?
@TeachExcel
Жыл бұрын
Sorry for the delay, it should be good now! Click the link in the resources section of the description and that will take you to it.
@SteveLongmoor
Жыл бұрын
@@TeachExcel Many thanks. Much appreciated. As it happens, I converted the Excel spreadsheet I was working on and had ChatGPT generate the script for me. Absolute doddle. Thanks for replying so quickly and for being so helpful. I'll be sure to keep visiting your website and spreading the good word.
Пікірлер: 15