open the workbook in a folder

Dear all,,

Good day,
I am facing to run a macro in Office 2007 but it is working fine in Office 2003. Below is my coding:
i need to browse to the folder and open 1 by 1 workbook in the the folder: however, it seems this coding cannot run in office 2007. please help.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

does not work in excel 2007. See the answers I got for a similar query of mine
https://www.excelforum.com/showthread.php?t=711455

rgds

johnjohns

Hi Friend,

As per your title that "open the workbook in a folder",
Try below code
You may change as per your requirement

Please Login or Register  to view this content.