Code amended to look for zip folder in Data_Extractor location as default.
Code deleted
Code amended to look for zip folder in Data_Extractor location as default.
Code deleted
Last edited by mdmackillop; 08-31-2017 at 01:45 AM. Reason: Modified to set GetOpenFileName location
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
Thanks, ActiveWorkbook.Path seems to be the right approach, however there still seems to be an issue, see below the issue regarding the path for external drive name W.
screenshot 31.08.17.PNG
2screenshot 31.08.17.jpg
"ActiveWorkbook.Path = "E:"