Recent content by kingsransomracing

The current problem I am having is the code below works great when I don't have the Kestrelweather.csv file open, but when I open it (to simulate the weather station writing to the file) it generates an error saying it can't open the file. The funny thing is that when it opens the file it...

The reason is because the csv file is not just line by line data. it looks like this: ------------------------------------------------------------------------------------------ FoxTerm Info: Logging started. > S > DT WS TP WC RH MO HI DP WB AP...

Nevermind all. I managed to get it working. I just have one issue which I will create a new post with

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...