To open a folder and select a file
Hi all!!
I need a code in Excel vba to open a folder and select a file and assign that file to a variable of object type.
Please help!!
Thanks in Advance
ExcelExperts.comExcel Consultancy, VBA Consultancy, Training and Tips Call:+442081234832 |
|
Excel / VBA ConsultancyFree Training VideosFree SpreadsheetsExcel / VBA JobsNavigationWho's onlineThere are currently 0 users and 767 guests online.
New Excel Experts
Current Excel / VBA Jobs |
To open a folder and select a fileHi all!! Please help!! Thanks in Advance |
Highest Ranked Users
Recent Blogs
ForumsRecent comments
User login |
have a look at this:
have a look at this: http://excelexperts.com/VBA-Tips-Get-A-File-Path
once you have the file path, you can open it if you want, or just pass the file path around in your code.
Thanks... That was of great
Thanks... That was of great help!! :)