Thanks for the replies Bob and Jeff
Jeff you have the hit the nail on the head and simplified the problem,
which is that i have a procdure that switches between 2 open workbooks
using there workbook names which at present is hard coded (as below)
Windows("SAStanCosts WE 11 19 05.xls").Activate
I am trying to change it so the user specifies the 2 workbooks to use.
I have captured the file path for each workbook but don't know how to
use it to make it work in my code as if it was the hard coded workbook
name?
Regards
Adrian
--
SandyUK
------------------------------------------------------------------------
SandyUK's Profile:
http://www.excelforum.com/member.php...o&userid=17487
View this thread:
http://www.excelforum.com/showthread...hreadid=547362