【转帖】how to get a file browser in vba

yang686526

how to get a file browser in vba
i use this function in vb.net to get a user specified location:
function getlocationfromuser() as string
dim folderbrowser as folderbrowserdialog = new folderbrowserdialog()
folderbrowser.showdialog()
return folderbrowser.selectedpath + "\"
end function
what is the equivalent or how do i make this work on vba?
adrian velazquez
cswp
cswp-smtl
solidworks x64 2009 sp3.0
nvidia quadro fx 570
vb has a built-in common dialog function, but vba doesn't. you can either use windows api calls or reference a library that includes a common dialog (e.g. excel). see the thread below.
thanks
adrian velazquez
cswp
cswp-smtl
solidworks x64 2009 sp3.0
nvidia quadro fx 570
adrian
here is the module that i use when browsing for a folder. i save the module that does the work and import it into what ever program i need it in. i did not write the code, i found it on the internet and there is no author in the code.
the only thing that i don't like about it is that i haven't found how to make it start in a folder that i pick so it always starts at "my computer"
ivana also put similar code in the thread called "initiate a browse for file function" but i have gotten a chance to look at that hers yet.
dan
edited: 02/27/2009 at 10:44 am by dan miel
quick