Cloud services problem

[billheath]

I am a novice, so, please bear with me.

Is there a way to directly link to the cloud from your computer? Let me explain.
I have 2 programs that the employees use to update daily records. One, an excel file has general pricing and other information and is updated daily. The other is an Access 10 Database which is password controlled and specific to each employee. Both programs reside in the cloud on "OneDrive". (I also tried "Dropbox".)

The access program has a VB sequence that is linked to the excel file. Problem is: Even though they have the same files and info on each computer through the cloud. The link looks for a specific "One Drive" folder. I know this is confusing:

Example, we all use this program in the office on our network and on our laptops when we are away.

When I set this up in the office, I am linked to a file at "C.Company.OneDrive". When I am away on my laptop, Access tries to link to "C.Company.OneDrive". But now, my laptop folder is located at "C.BH.Onedrive". The excel files are the same because they are in the "OneDrive" cloud but my computer doesn't know where to look. I get, "Cannot locate file C.Company.OneDrive.File.xls". All employees get a similar error.

 

[billheath]

A little more info. What I am looking for is a way to have VBA change the location to look for the excel link based on the individual computer. The Excel file will always be in a folder labeled "OneDrive". It will always be located at "C.Computer.Onedrive.file.xls". "computer" is the name of the computer and "File" is the filename.

Thanks,
Bill

 

[Andrzejek]

You can chack if this file exists: "C.Company.OneDrive". If it does, you are fine, if it does not, check for the file "C.BH.Onedrive".

You can use the function from here so you code may be:

If FileOrDirExists("C.Company.OneDrive") Then

ElseFileOrDirExists("C.BH.Onedrive") Then

End If

Have fun.

---- Andy

A bus station is where a bus stops. A train station is where a train stops. On my desk, I have a work station.

 

[billheath]

Thanks, I will try that