Macro saves excel to Dropbox or one drive but with multiple users

[Mark Dynes]

Hi guys,

Really struggling with an Excel invoice program that requires file paths that have Users\user in the macros that then save the file to dropbox. I have multiple users that need access to this invoice file and don't know how to get them to successfully save the file with this current line of code which has to have Users\user when it could be Users\'anyname'\ in the code.

Appreciate all input!

Regards
Mark

[vba_php]

get them to successfully save the file with this current line of code which has to have Users\user when it could be Users\'anyname'\ in the code.

why could it be ''anyname''?? aren't you the programmer? why is ''anyname'' in there? why not just restrict it to what you want?

[Mark Dynes]

Hi Thanks for the reply, life took hold & changed my priorities for me, hence the delay in my response.

I wouldn't class myself as a programmer just yet as this was my first big project, so still learning!

Having upgraded the PC's to Microsoft 365, each user now has a different user name which doesn't match the file path I have in the code in VBA. When a save macro button is clicked in the macro enabled excel document, it saves an excel copy of the file to one folder in dropbox and then a pdf version to another folder in dropbox. The path is currently set to C:/User/user/blah blah. But with the 365 upgrade changing User to a name eg: C:/User/Name of person/ blah blah blah. I need a work around. I can either do an IF function for each user in the code but would prefer it to be simpler than that, so that when we get new users I don't have to update the code with their user name and IF command. (PS not sure IF would even work but that was my initial thought. If file path incorrect try the next path until it can save the files.)

Hope that makes some form of sense, appreciate you looking at this. All help is very welcome!

[Mark Dynes]

Hi Guys,

How do I get someone from Commercial Services to help me with this???

I could really do with solving this problem. Not really getting anywhere on the forum and its getting to crunch time. PC upgrades are the motivator.

I have multiple users and PC's accessing these files. (Invoice system)

Currently the file path for my macro's and code use is, C:\User\User\Dropbox\etc See below for full code. However moving to microsoft 365 meant I had to have a registered user on each pc so now everybody's file path is different. Eg PC1. might be C:\User\Mr C Cloggs\Dropbox\etc, PC 2 C:\User\L Somebody\Dropbox\etc and so on.

If somebody knows how to work around this I would appreciate it. Having never opted for the Commercial Services before I am unsure of how the pricing works also so please let me know how much this would cost.


Google searches has others searching for the same as my problem and they called it a dynamic username and have talked about using Environ but I'm out of time to get this sorted.

Thanks in advance.

Please Login or Register  to view this content.

[Fluff13]

How about

Please Login or Register  to view this content.

[Mark Dynes]

I will give it a whirl and see, thank you!

[Mark Dynes]

Hi Fluff13,

It worked!!!!!!!!!!! Just did a little jig around the office. Feeling very happy, Thank you very much!

[Fluff13]

You're welcome & thanks for the feedback.