I need help with a macro to do the following:
Open a file in a folder G:\Fakepath\YYYYmmdd\filename_ABC_YYYYmmdd_Rec.psv
The YYYYmmdd needs to be the value of a cell in current active workbook, sheet1, cell A1
The YYYYmmdd will always be the same for folder and file name (i.e. G:\Fakepath\20150107\filename_ABC_20150107_Rec.psv)
Thanks!
Bookmarks