VBA and Workbook.Open

[sulmer]

I am using a workbook.open event in file 1 to open file 2 which has data validation lists used in file 1. File 2 opens fine (Excel.workbook.open file2) but when I go to file 1, nothing shows up in the drop down lists. Is there some additional VBA code needed?

 

[texasalynn]

has it ever worked? I'm not sure that a validation list can have data from other file

 

[sulmer]

Actually it can as long as both files are opened in the same instance. There are some other tricks to make it work but yes it can be done.

 

[RoryA]

How are your names defined?