View Single Post
 
Old 01-17-2014, 11:55 AM
gbaker gbaker is offline Windows 7 32bit Office 2010 32bit
Competent Performer
 
Join Date: May 2012
Posts: 111
gbaker is on a distinguished road
Default Open Folder in Excel 2010 VBA

Hi Bob,
I'm not that literate in writing code. I can record Macro's so the information doesn't help me!!! The files are excel.csv

Code:
Sub OpenFile()

fileToOpen = Application _ (Do I put the path here)
 .GetOpenFilename("Text Files (*.csv), *.csv") 
If fileToOpen <> False Then 
 MsgBox "Open " & fileToOpen 
End If
End Sub
Don't really understand how to make it work. Can you Help with the code?

Thanks in Advance GBaker
Reply With Quote