I would like to pipe the results of all the applications on my Citrix farm to an excel file which is fine but I would also like that excel file to update the tables in another excel file so that I always have an accurate list of the applications in my enviroment. Thank you, Leto the just

Can't you use something like this in Book2? =[Book1]Sheet1!$A$1

Yes, but I want one file to update a separate file because the qfarm /apps > qfarm.xls creates a new file or overwrites the existing file. I need a separate file to pull information from the new file. Thank you, Leto the just

You said: "I need a separate file to pull information from the new file." I guess I'm confused because that is what I think I suggested. When you use something like this in a cell in Book2.xls: ='C:\Documents and Settings\MyName\Desktop\[Book1.xls]Sheet1'!$A$1 you will see whatever is in A1 on Sheet1 in Book1.xls. As far as I know, even if the file gets overwritten, as long as the name remains Book1.xls, Book2.xls will show the data currently in [Book1.xls]Sheet1!A1 - i.e. the new data. Now, if the filename changes, then you'll need something more fancy. Perhaps some VBA in Book2.xls that reads the directory where the changed file resides and determines the name based on some criteria that you supply. Once it finds the file, VBA could build the formulae required to pull the data. If you could provide some specifics as to what is happening with the filenames, etc., I might be able to offer some other suggestions.

I am sorry, I was thinking of sheets, I will try what you suggested. Thank you, Leto the just