Hi Guys

Firstly I truly apologize if this is Nth time something like this has been answered but I couldn't see a solution and in all honesty time's against me in this, so any help would be gratefully received.

Secondly the issue: I am launching Excel (2010) remotely from another application which produces a csv file (e.g MyFile.csv) using a call to the excel file name "MyExcelFile.xlsm". In the Sub Workbook_Open() my first line is: Workbooks.Open Filename:="MyFIle.csv". However this opens another instance of Excel called MyFile.Csv which then formats etc the way I want with the rest of the code in Workbook_Open. The problem is that I wish the csv file to be opened in the original instance of excel (MyExcelFile.xlsm) so that the data can be manipulated etc, other macros to be run eg sheet names changes etc. The question, therefore is how to automatically open the MyFile.csv file and load the data into MyExcelFile.xlsm and not create MyFile.csv?

Thank you

Nick