Macro to shift between two sheet

[Chetan Chauhan]

Hi,

I have a macro which runs between two files. The problem is one file name is not consistent, it keeps on changing but the first 5 letters of the file name are constant eg "toJPM".
Now the problem is Macro does not shift to other workbook since it does not recognise the name. I have to change it every time.
Is there any code which I can add in

Windows("toJPM..").Activate  

so that macro run without changing the file name in the code everytime.

Thanks
Chetan

[venkat1926]

see whether this macro helps

Please Login or Register  to view this content.

[Chetan Chauhan]

Hey ! Venkat,

Cool dude its working. Actually the code contain worksheets which was not working. I just made it to workbook and it solve my purpose...

Thanks
Chet