Forum Discussion
VBA Programming Assistance
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!
Another thing that I noticed that you may or may not want to change. The Submit image (button), and SAVE FILE button both are visible on the exported PDF. If you want them to not display, you can set them so they don't print. They are different types, so the steps for each one is different. Let me know if you would like some assistance with that.
The button being on the form isn't that big of a deal to me but interesting to know you can remove it. Now when I try to save it it pops up with a printer dialog box:
And when I hit "Adobe PDF" I get this:
And then this:
As it pertains to this:
Now clearly I am no expert, barely even a novice, but why it is telling it to print? I didn't see any code that looked like a print command. Is that just the default for pdf?
I'm still trying to figure it out. I cannot duplicate it here. My initial searches indicate that it may be due to having a network printer set as your default for your computer, but my default is a network printer, so I'm reluctant to say that is the cause. Just for giggles, though, you may try changing your default printer to Microsoft XPS Document Writer, or something like that to test the theory.
When I switched my default printer to the Microsoft XPS Document Writer it worked perfectly...like a perfect charm. That's strange though, I wonder why it does that with a network printer.