refer one excel from another excel with partial name

[syprakash]

Hi,
Is it possible to refer one excel from another excel with partial name?

Below is my macro(working fine), in this example I am refering "September2_MonthData.xls"(excel will be open when refering) excel document from another excel "consolidated Data.xls".

Now the question is it possible to refer "September2_MonthData.xls" excel doc like any excel open(active) document ending with "%%%%%_MonthData.xls" from another excel "consolidated Data.xls".

Because for every week, there will be one excel document, so instead of changing name of excel doc name in macro everyweek, is it possible to refer like "%%%%%_MonthData.xls" from another excel "consolidated Data.xls"?

------------

Please Login or Register  to view this content.

===============================

[teylyn]

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

[syprakash]

Hi,
Is it possible to refer one excel from another excel with partial name?

Below is my macro(working fine), in this example I am refering "September2_MonthData.xls"(excel will be open when refering) excel document from another excel "consolidated Data.xls".

Now the question is it possible to refer "September2_MonthData.xls" excel doc like any excel open(active) document ending with "%%%%%_MonthData.xls" from another excel "consolidated Data.xls".

Because for every week, there will be one excel document, so instead of changing name of excel doc name in macro everyweek, is it possible to refer like "%%%%%_MonthData.xls" from another excel "consolidated Data.xls"?

Please Login or Register  to view this content.

[shg]

Please Login or Register  to view this content.

[syprakash]

Dear Shg,
This works perfectly , thanks a lot

Regards,
Prakash