Imagine this condition; We are in the middle of doing something using Excel VBA macro, then we want the macro to automatically show the File Open dialog box to make us (user) able to choose another Excel file to be opened by Excel.
Got the picture? Below is vba procedure that do exactly like that, show the File Open dialog box, and open the Excel file selected by user.
Sub OpenExcelFile()
Dim vFile As Variant
'Showing Excel Open Dialog Form
vFile = Application.GetOpenFilename("Excel Files (*.xl*)," & _
"*.xl*", 1, "Select Excel File", "Open", False)
'If Cancel then exit
If TypeName(vFile) = "Boolean" Then
Exit Sub
End If
'Open selected file
Workbooks.Open vFile
End Sub
Pingback: image
Pingback: cuisinart automatic ice cream maker
Pingback: fun times
Pingback: maryland internet
Pingback: How to Tie a Tie
Pingback: Juegos de fubol callejero
Pingback: Safety Label Changes
Pingback: wood snow fence
Pingback: baby contest
Pingback: Peripheral
Pingback: Software
Pingback: anti aging cream
Pingback: beat maker
Pingback: used sub zero refrigerator prices
Pingback: check advance
Pingback: Immobilier Quimper
Pingback: bad credit unsecured personal loan
Pingback: start online business free
Pingback: look into skate ski
Pingback: "best laundry detergent
Pingback: austin search engine optimization
Pingback: understandable
Pingback: fibersource tube feeding
Pingback: http://www.casquebluetooth.org/
Pingback: "fun tasticdental
Pingback: gogo games
Pingback: http://www.la-mutuelle.com/
Pingback: tv live
Pingback: fast car insurance
Pingback: servis char
Pingback: promoting and celebrating Virginia creativity
Pingback: read about payday advances
Pingback: Red Wines
Pingback: duluth tree removal