I use the below code to convert a sheet into a PDF then attach it to an email with the To and Subject lines filled out. It's not working for a coworker and the debugger is highlighting the code line that I put dashes after. Anyone have any ideas or a solution? Thank-you in advance for any help!
Please Login or Register to view this content.
.
I'm curious how the code is working for you. Tried it on my system here ... nothing. Marked out all the error checking comments
and no error messages either. Strange.
In any case, here is another method to accomplish what you want :
The code as written will also copy the email addresses where they are presently located (L2:L5). You can move the email addresses to rows that are notPlease Login or Register to view this content.
aligned with the existing data rows and then the email addresses won't show in the PDF. The addresses can be placed on another sheet or the same
sheet at present but somewhere lower down than Row 18.
As indicated ... this is just one method of accomplishing your goal. There are plenty of other variations as well.
Last edited by Logit; 05-02-2019 at 10:30 PM.
My original code works great with my computer. Are you running an older Windows OS?
I made some adjustments to your code and it worked on my computer (OneDrive does not sync my desktop). I sent it to the person that was having issues and they got an error (OneDrive does sync his desktop). The debugger brought him to the "MkDir myFolder" line (I marked it with dashes below). I think that's happening because the path to the desktop changes to the OneDrive desktop path. That's why my code had an On Error GoTo option in it.
Please Login or Register to view this content.
.
If I correctly understand the error you are experiencing, follow the instruction below :
And, where ever the terms : "\Desktop\PDFs" : are also located through out the macro, you will need to edit those as well.Please Login or Register to view this content.
I have a mixture of users - some that have OneDrive syncing their desktops and some that don't. That's why I have the "EOneDrive" portion of the code. If the first part comes back with an error, then it goes to the EOneDrive code. Separately, the codes work fine, but when I put them together, like I have them in my original code, we get an error on the "OutlApp.Visible = True" code line under the EOneDrive portion.
I got my original code to work now... I just removed the line that came up on the error.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks