J
John Keith
I am working on a macro that required the ability to loop through all
the files in a folder. I did all my development work on a folder in
the My Documents folder and got everything working correctly there.
Then I started the process of moving the target folder to a sharepoint
where all the real files lived. As soon as I did this and adjusted all
the paths I immediately got an error message "Bad file name or number"
from the following line:
First, this is the line that worked on my local drive:
'sfname = Dir("C:\Documents and Settings\keithjo\My
Documents\Test\*.xls")
and this is the line that now produces the error:
sfname = Dir("https://xx/yy/CIS/Shared Documents/*.xls")
(I've replaced the xx and yy to get this on one line)
I'm pretty sure the path is correct as I did a cut and paste from the
address line in windows Explorer and I've tried both " " and "%20" in
the space between Shared and Doucments but have not had an success
yet.
Any suggestions on what I might be missing?
I can pist more code if needed but I'm pretty sure it is this one
statement.
TIA
John Keith
(e-mail address removed)
the files in a folder. I did all my development work on a folder in
the My Documents folder and got everything working correctly there.
Then I started the process of moving the target folder to a sharepoint
where all the real files lived. As soon as I did this and adjusted all
the paths I immediately got an error message "Bad file name or number"
from the following line:
First, this is the line that worked on my local drive:
'sfname = Dir("C:\Documents and Settings\keithjo\My
Documents\Test\*.xls")
and this is the line that now produces the error:
sfname = Dir("https://xx/yy/CIS/Shared Documents/*.xls")
(I've replaced the xx and yy to get this on one line)
I'm pretty sure the path is correct as I did a cut and paste from the
address line in windows Explorer and I've tried both " " and "%20" in
the space between Shared and Doucments but have not had an success
yet.
Any suggestions on what I might be missing?
I can pist more code if needed but I'm pretty sure it is this one
statement.
TIA
John Keith
(e-mail address removed)