Tezzies
02-19-2008, 07:11 AM
Everything worked great until.......I have a workbook called test1.xls which contains a macro which in turn calls a macro held within my other workbook called test2.xls. Since sharing the workbook test2.xls i am unable to call the macro using test1.xls.
The code used to call my macro is -----
Run ("Test2.xls!SaveandClose2") 'This line worked up until I shared test2.xls
I believe there are some limitations using shared workbooks have i found a big one or do you know of a workaround.
Many Thanks in advance
The code used to call my macro is -----
Run ("Test2.xls!SaveandClose2") 'This line worked up until I shared test2.xls
I believe there are some limitations using shared workbooks have i found a big one or do you know of a workaround.
Many Thanks in advance