Find the code for the routine called "Private Sub UserForm_Initialize()"Ĥ. Right click on the "ProjectLink" form and select "View Code"ģ. Root directory for me was "Project1 (VbaProject.OTM) )Ģ. Open up the "Forms" folder in the VBA Editor (this is the top left panel that has a tree like structure to it. That way I've still got a copy of the original code line from Bill's work.ġ. I then typed "REM" (No quotes) in front of each line to remark it out. Please note that I made copies of the code I changed by copying the lines affected and pasting them on the next line directly below the line being changed. So I substituted my user name in the same format it appears in Outlook for every instance of "personal folders" and hey presto it worked!Īfter following the instructions in the pdf to publish the form and macros, I made the changes listed below. Instead, when I go to folder view, I see the "root directory" as my user name (Thrush, Warren). I don't have that structure in my Outlook. Just to let you know up front, I don't know if this has anything to do with it, but at work I am connected to an MS Exchange Server, so when I read the code, I found that it was referring to a folder structure called "personal folders". Now, I don't profess to be a coder in the same league as Bill, but I found that if I changed a couple of values in the VBA editor, then the form now works.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |