ChuckDrago
Active Member
- Joined
- Sep 7, 2007
- Messages
- 470
- Office Version
- 2010
- Platform
- Windows
Hi everyone,
Got a tough one today (well, for me at least).
A workbook application collects data from the company server and populates a worksheet form (not UDF, just the sheet designed as a form). I need to grab the created datasheet form, copy it as a graphic to a Word document to finally save the Word document as a pdf to be attached to an email.
1) If there is a method unknown to me to save the worksheet as a pdf, I will appreciate the lesson.
2) If the two-step process I do manually is all I can do, I will also appreciate your guidance regarding translating it into VBA.
I am confused as a dog in a bowling alley.
Thank you all,
Chuck
Got a tough one today (well, for me at least).
A workbook application collects data from the company server and populates a worksheet form (not UDF, just the sheet designed as a form). I need to grab the created datasheet form, copy it as a graphic to a Word document to finally save the Word document as a pdf to be attached to an email.
1) If there is a method unknown to me to save the worksheet as a pdf, I will appreciate the lesson.
2) If the two-step process I do manually is all I can do, I will also appreciate your guidance regarding translating it into VBA.
I am confused as a dog in a bowling alley.
Thank you all,
Chuck