Here is what I am trying to do.
I have a macro I created in excel that pulls data from a csv file (created by my weatherstation) and creates an xml file (used by my access program). This macro works great.
Sub Auto_Open()
'Open csv file
Workbooks.Open...
