Hey there, I'm new to posting here, I've usually been able to search for my solutions and you all are a great resource!
My current issue:
I'm using Excel 2010. I'm creating a file for 30 different users to use (can't use add-ins or plug-ins)- they will each save their own copy of it, will not use the same file.
I need some code that will do the following:
I seem to be able to find bits and pieces of what I need but can't seem to get it all to work together with Excel 2010. Any help is greatly appreciated!
My current issue:
I'm using Excel 2010. I'm creating a file for 30 different users to use (can't use add-ins or plug-ins)- they will each save their own copy of it, will not use the same file.
I need some code that will do the following:
- Save a specific range on the current worksheet as a .pdf, based on a name in a cell on a different worksheet (can add the formula to current worksheet if needed) into a specific directory other than the location of the current file (the formula will cause the file name to save with the date as part of the file name to keep a record of all the pdf versions emailed by date)
- Attach the file to an email in Outlook as a pdf (most code I'm finding attaches it as a .xlsx file) with a specific subject, adds the users current signature for a new email to the body but leaves all other fields to be completed by user (to:, cc:, bcc:, etc), display the email for the user to modify prior to sending
I seem to be able to find bits and pieces of what I need but can't seem to get it all to work together with Excel 2010. Any help is greatly appreciated!