Should work. You can also put things in the registry. Check out XL VBA
help for the 'SaveSetting' statement. Don't forget to check the 'See also'
links from that page.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...

I have a directory with about 20 excel files and want them to all share
the same global variables once they are run. I was thinking of doing
this by creating a "vars.ini" file in the same directory and have them
all load the variables once opened. This way I can set the ini file
once, and it would affect all the excel files equally. Is this a
feasible approach?

Matts


--
mattsvai
------------------------------------------------------------------------
mattsvai's Profile: http://www.excelforum.com/member.php...o&userid=31134
View this thread: http://www.excelforum.com/showthread...hreadid=508150