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

Nick's picture

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!! :)