i have been researching this problem a little bit and can find other trying to do it but no real solutions. i want to use filedialog to open an workbook, then recycle that same filedialog to open a second workbook. the problem is when i then try to manipulate the first workbook the contents seem to be that of the second workbook. i have included the macro enabled workbook if not enough i can sanitize the input files and include them.cost_report_v.1.xlsm
P.S. i left in commented out some things i tried to make it work based on a suggestion i found elsewhere but no dice.
Bookmarks