Hey all
I wrote a macro that amongst other things will create it directory if it doesn't exists. It reads the input from the active workbook out of cell "B3"
Input Screen.jpg
I then pick up this input using the following code in VBA
It then goes on to download attachments from outlook and manipulating the data to finally plot what I need.Please Login or Register to view this content.
The function to create the directory in question is
Im aware that VBA can only create one directory level, thus the function.Please Login or Register to view this content.
The Macro runs fine one my machine, but when I try and run the Macro on another PC, I get the following error
Error Screen.jpg
and debugging points me to
line. I have no Idea what could be wrong. It has to be something with the directory input, access or the way the computers handle it ?? We are using the same Excell 2010 so compatibility is not an issue.Please Login or Register to view this content.
I hope someone can shed some light on this.
Thanks
ExcellMantis
Bookmarks