VBA File Path question

[mayoung]

I am creating a custom addin that takes reports that have been down loaded out of our business System and then through VBA uploads the data into excel.
The downloaded report out our business system goes into a download file on our computer.,
The file path would be: C:\User\ myoung\dowloads. The myoung would be the persons computer this particular file path is for. But several people want this addin in on there computer in excel. My question is, is there away to make a path so the VBA gets to the download folder of the persons which the addin is installed on or does each different file path have to be set up? Or is there a work around for this?

 

[fhqwgads]

maybe try

Path = "C:\Users\" & environ("username") & "\Downloads\"

gotten from Get current user path in VBA

 

[Fluff]

Another option

MyPath=environ("Userprofile")&"\Downloads\"

 

[mayoung]

Another option

MyPath=environ("Userprofile")&"\Downloads\"

How Do I get the Path & MyPath Code to open the DataminerFile.xml?

The only code I can get to work is the first one Workbooks.Open

Workbooks.Open ("C:\Users\myoung\OneDrive - Bobs Enterprises Inc\Downloads\DataminerFile.xml")
 
Path = "C:\Users\" & Environ("username") & "\OneDrive - Bobs Enterprises Inc\Downloads\DataminerFile.xml"
 
MyPath = Environ("userProfile") & "\OneDrive - Bobs Enterprises Inc\Downloads\Dataminer.xml"

 

[Fluff]

I have never used OneDrive or xml files, but you could try

MyPath = Environ("userProfile") & "\OneDrive - Bobs Enterprises Inc\Downloads\Dataminer.xml"
Workbooks.Open MyPath

 

[mayoung]

I have never used OneDrive or xml files, but you could try

MyPath = Environ("userProfile") & "\OneDrive - Bobs Enterprises Inc\Downloads\Dataminer.xml"
Workbooks.Open MyPath

That worked for Both lines of code. Thank You

 

[Fluff]

Glad we could help & thanks for the feedback.

 

[mayoung]

Glad we could help & thanks for the feedback.

What if this was a folder you wanted to open instead of a workbook? How would you go about that?

 

[Fluff]

That's a totally different question, so needs a new thread. Thanks.