Generic User for Excel Connection String

Question

Is it possible to have a generic user reference in the data connection string of an Excel data connection?

I have a external reference to another workbook that I would like to share with my colleagues, and in the collaboration software that we use there is a path for each user's synced folder, such as:

C:\Users\"Username"\....

Is there a prompt similar to %USERPROFILE% that I could use in this instance? Here is a full connection string example:

DSN=Excel Files;DBQ=C:\Users\"Username"\...\File.xlsx;DefaultDir=C:\Users\"Username"\...;DriverId=1046;MaxBufferSize=2048;PageTimeout=5;

EEM · Accepted Answer · 2016-07-06 17:00:55Z

1

To generate C:\Users\Username use: environ("HOMEDRIVE") & environ("HOMEPATH")

see Environ Function and also Windows APIs & Wscript at Daily Dose of Excel - Get the Path to My Documents in VBA

answered Jul 6, 2016 at 17:00

EEM

6,6602 gold badges20 silver badges33 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

CJK Over a year ago

Thank you for the answer @EEM! Unfortunately, I am not using VBA to create the data connection parameters within the worksheet (and I am simply using the Data Connection wizard to define the path). I think I have a temporary solution, but I might need to resort to VBA in the end!

Collectives™ on Stack Overflow

Generic User for Excel Connection String

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related