opening a file using file name

[jluft]

assume that i have two spreadsheets open, A and B. I have the full file path name defined for both file a and file B

my operations begin in file A, but at a point in the code, i would like to activate file b. how, using the filename to toggle between the two sheets, can i do this?
thanks very much

 

[PHV]

How are A and B open ?
Have a look at the Windows and/or Workbooks properties of the Excel.Application object.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886