I am creating a custom addin how would you open just a folder
The folder path would be: C:\User\ myoung\dowloads. The myoung would be the persons computer this particular folder 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 folder path have to be set up? Or is there a work around for this?
I have the below three examples for opening a file, but how can this code be changed to open a folder?
The folder path would be: C:\User\ myoung\dowloads. The myoung would be the persons computer this particular folder 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 folder path have to be set up? Or is there a work around for this?
I have the below three examples for opening a file, but how can this code be changed to open a folder?
VBA Code:
Workbooks.Open ("C:\Users\myoung\OneDrive - Bobcat Enterprises Inc\Downloads\DataminerFile.xml")
Path = "C:\Users\" & Environ("username") & "\OneDrive - Bobcat Enterprises Inc\Downloads\DataminerFile.xml"
MyPath = Environ("userProfile") & "\OneDrive - Bobcat Enterprises Inc\Downloads\Dataminer.xml"
Last edited: