Hopefully this is going to be easy for someone.
I have recorded a macro (several attempts) which goes through the steps of copying some text from a cell (which will become a filename), then going through the steps of exporting a PDF file in a folder.
Going through the steps Manually works perfectly. Going through the steps works fine for the unique file name (i.e., NOT replacing a file with same name or any basic error). This is the only macro I've encountered that does not complete the recorded task. No error messages or popup windows appear asking for anything.
The question is, at the end of a macro whose action is to save a unique spreadsheet file, is there an added step necessary (in the macro) after recording clicking of the SAVE button? Has anyone else here created a macro to save a file and it it did not work? That is, is there a special checkbox to indicate you really do want to complete the task ? I am missing something really essential but can't find it after many tries.
Thanks for any help or comments.