I realise this is probably a very simple question but I would be grateful
for any help offered.

I have a workbook that has formula's linked to another worksheet.
Unfortunately the sheet it is linked to is a csv file so the links will not
update without the sheet being open.

Therefore I wanted to write a makro that opens the csv file and then closes
it again. I have managed to do that with the record Makro command however I
do not know how to get this Makro to run automatically on the worksheet
being opened.


ChDir "H:\SHARED"
Workbooks.Open Filename:="H:\SHARED\susprecpt.csv"
ActiveWindow.Close
ActiveSheet.ShowAllData

Thanks for your help

Rob