find worksheet in another workbook

[arthurlee]

Hi,
I want to find a worksheet in another file. The worksheet name will be change in different date so I already set the worksheet name in a cell (e.g. "A1"="0001", it will be change to "0002", "0003"....). How can I set this marco to get the another workbook and go to the worksheet "0001".

Thanks!

 

[Matt Rogers]

Hi.

It must be a macro?

Excel Workbook
	A	B	C	D	E
1	C:\Documents\	Data.xlsm#	Sheet1!	A1	C:\Documents\Data.xlsm#Sheet1!A1
2	C:\Documents\Data.xlsm#Sheet1!			A2	C:\Documents\Data.xlsm#Sheet1!A2
Sheet