Macro to open a file on Dropbox from any computer

Hi guys,

I have the following macro:

Please Login or Register  to view this content.

Each computer in our company has a different user name... In my case, my username is NSW02 and the macro works well...
But if another user, in another computer, for example NSW01, if he try to open the file it doesn't work because of the location of the file (because of the username).

I had a look in the forum and I found the link below. This guy had ALMOST the same problem, but it didn't work for me. Message error is "File not found".
http://www.excelforum.com/excel-prog...-computer.html


Any idea?

Thanks guys

Look at replacing the UserName with Environ("UserName") in your code.

to test your user name. type this in the Immediate Window of the VBE ?Environ("UserName")

Hello Rick,

Try this...

Please Login or Register  to view this content.

Hello Rick,

It could be the the file path needs to include the quotes. Try this...

Please Login or Register  to view this content.

Hello Rick,

Time to pull out the big guns. This API call is for Windows 7 And later. Delete your old code and replace it with this...

Please Login or Register  to view this content.

Hello Rick,m

Can you post your workbook for review? The macro works on my system to open any pdf file I choose and I am running Windows 7 also.

Hello Rick,

Okay, that was my fault. The API call does not need to know where Acrobat Reader is since the file extension "pdf" is associated with the program. This version should work provided you have a file name in cell "V16", which I did not see in the posted workbook.

Please Login or Register  to view this content.

Hello Rick,

You're welcome.

@ Leith Ross,

Hi Leith,

As allways, very well done!

It is just a pity though that is looks as if it wont work on Excel versions earlier than Windows 7.