Forum Discussion
Deborah Thornburg
Sep 19, 2018Copper Contributor
VBA Programming Assistance
I have been working on the attached spreadsheet creating formulas and now I have wading into the VBA programming...which I have not done since college and didn't do very well then. As I get deepe...
Deborah Thornburg
Sep 20, 2018Copper Contributor
That is so amazing and I promise I will read through the code and try to understand it all so I don't have to ask so many questions in the future! The only thing is when I click the "Save File" button I get the following error:
As it relates to the .Attachments.Add attpath line in the code.
I do want the file to attach to the email so you assumed correctly and it really is very much appreciated!
BobOrrell
Sep 20, 2018Iron Contributor
Sorry about that. When I was testing it, I was saving the pdf to the same drive that the workbook was saved to. I forgot to tell it to look at a different drive. There was also an extra \ in there too. I've made the corrections, and this should work for you.