LinkBack URL
About LinkBacks
Hey guys...
First time ever working with network path...This gives me a badfilename error...any ideas...
Please Login or Register to view this content.
Hey guys...
First time ever working with network path...This gives me a badfilename error...any ideas...
Please Login or Register to view this content.
Last edited by sintek; 03-05-2021 at 10:57 AM.
Good Luck
I don't presume to know what I am doing, however, just like you, I too started somewhere...
One-day, One-problem at a time!!!
If you feel I have helped, please click on the star to left of post [Add Reputation]
Also....add a comment if you like!!!!
And remember...Mark Thread as Solved.
Excel Forum Rocks!!!
yes, you are checking bad file name cuz you are doing
and result isPlease Login or Register to view this content.
so you check then, thisPlease Login or Register to view this content.
but you need to check thisPlease Login or Register to view this content.
DIR() does not like spaces in paths. =)Please Login or Register to view this content.
Result is
"https://d.docs.live.net/1234/SawisAuto/March 2021"
isPlease Login or Register to view this content.
Please Login or Register to view this content.
sorry. i just check. yes you are right. but, dir is vba function. you are checking if dir exists on a drive, not on windows machine. i think that is the issue. almost positive. if so, probably nothing you can do. what is d.docs.live.net?
I am wondering if users pc is connected to the network?...Will have to check...This could be reason it is causing error..Just assumed it was...
like i said, vba functions should not work to check actual URL. that makes no sense.
I am so over this....
System works perfectly when pc is synced to one drive...And file is opened from one drive folder...
Problem however...is it possible for the system to be opened in OneDrive Online 365 version and have all the same functionality...If opened via the Excel desktop app...
When this is done the initial paths used in code ("C:\Users\Steven\OneDrive\") does not work as the paths have now changed to "https://d.docs.live.net/1234/SawisAuto/"
Last edited by sintek; 03-05-2021 at 11:13 AM.
Maybe you just find out why I don't prefer microsoft. LOL.
My feeling is that whoever create OneDrive as a cloud service was not paying attention like they should regarding how it rolled into the operating system. I have had many weird things happen with one drive on networked machines that made no sense whatsoever. Automatic syncing, file saving where they shouldn't,..
That is why I do not use Microsoft unless I have to :-(
So...Lets try this again...
File is saved into OneDrive Folder which is synced with OneDrive in Cloud...
When opened from the OneDrive folder Path is ...
All functions run perfectly...Please Login or Register to view this content.
When this file is opened from the Cloud however, File is opened with "Desktop App"...365 Option...this allows macros to run...
Path then changes to "https://d.docs.live.net/1234/SawisAuto/" which causes the errors when saving pdf's and trying to attach to Outlook...
Last edited by sintek; 03-10-2021 at 12:23 AM.
K, I'm going to put this one to rest...This Function solves as it changes the path to the locally saved OneDrive Path...Thanks Rory...
Please Login or Register to view this content.
Now the other side of this for another thread...Please Login or Register to view this content.
Last edited by sintek; 03-10-2021 at 12:21 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks