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
Bookmarks