This may not be the place to look for this sort of help - if so sorry, but I'm in a bit of a corner with a deadline looming. I am writing a macro in Excel which opens a text file, converts it to an Excel file (in a new workbook). That all works nicely. Then I want it to plot a graph of the data in the new workbook using data from that workbook. How do I tell the VBA editor running in the first workbook to work on data and plot the graph in the second workbook. Any help greatly appreciated.