I am not sure where to start. At present I run the Lotus program on Win 7 through a XP virtual window.
Each main program has several vlookup tables and a few macros for loading different sub files to main program.


I have been told I may have to install all of the sub programs and vlookup files as different pages with the one workbook. Do you think this is correct ?

Could you be more explicit please? You talk about " main programs" and macros. Are they in Lotus or XL?

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post