stoopid_newbie
New Member
- Joined
- Jun 26, 2002
- Messages
- 14
Having previously used excel 2000 I used a spreadsheet which contained Hlookup and Vlookup statements within a macro which point to a separate workbook.
Now using Excel XP I find that when this Macro is activated I am prompted for the location of this workbook.
This never happened before and the location of the workbook has not changed.
Is there a way to do this automatically???
Cheers.
Now using Excel XP I find that when this Macro is activated I am prompted for the location of this workbook.
This never happened before and the location of the workbook has not changed.
Is there a way to do this automatically???
Cheers.