Forum Discussion
Help with macro to export ONLY the first sheet of multiple excel workbooks to PDFs
Hi All! I have been working to clean up this macro code to allow it to run better on my computer. To preface, I have really little knowledge about all this, and have had a variety of people contribut...
It looks like it is taking the name of the first worksheet as file name. Are you sure each file has a differently named first worksheet? Also, you need to append the path separator to the save path.
JKPieterse thank you for your reply!
I can confirm that the first sheet of each xlsx file has a different name, unique to each location that the file refers to.Can you explain to me how to append the path separator? I do not know how to do that.
Thank you for your help!
Your code already appends the path separator to both fPath and sPath.
- Silly me, I overlooked that!
