Home » Forums » Open Source Learning Center » Question and Answer

To open a folder and select a file

Submitted by pratyu on 22 June, 2012 - 04:50

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

‹ Assign Cell Value to array I can't save excel as csv file with semicolumns when I use macro for that action ›
»
Nick's picture

have a look at this:

Submitted by Nick on 22 June, 2012 - 06:41.

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

Submitted by pratyu on 22 June, 2012 - 06:46.

Thanks... That was of great help!! :)

»