Can you share your knowledge with the rest of us Keith?

I'm having a similar problem calling code from another workbook.

In one case it works and in the other it doesn't

my call line is as follows:

Application.Run (FinFile & "!AddShortCut")

The macro exists in both workbooks but in one case it gives me a
1004 error and says that it can't find the macro when it is clearly
there.

Any help would be appreciated.


--
bhofsetz
------------------------------------------------------------------------
bhofsetz's Profile: http://www.excelforum.com/member.php...o&userid=18807
View this thread: http://www.excelforum.com/showthread...hreadid=550070