To open Excel or CSV from another Excel macro

Here is the code:

Filt = "Excel Files (*.xlsx),*.xlsx,Excel Files (*.xls),*.xls"
FilterIndex = 5
Title = "File 1"
Filename = Application.GetOpenFilename(FileFilter:=Filt, _
FilterIndex:=FilterIndex, Title:=Title)
 Workbooks.Open (FileName)



 To get the file name


P = WorksheetFunction.Substitute(FileName, Left(FileName, InStrRev(FileName, "\")), "")

For any Custom Macro or Excel solution

If you need any cutom macro require for your work and soultion that you are facing with excel data or fromatting, you can contact me on Fiverr.

I just became a Level 2 seller on #Fiverr.com (@FiverrHQ). Check out my cool gigs:

http://5rr.it/s/qxtj