Saving through vb
Posted on 2013-01-31
I have a spreadsheet (larsonator.xlsx) which imports new data every 5 minutes from a web site.
What I would like to do is save the data out to a .CSV file (tiger.txt) every 5 minutes. It does NOT need to coincide with the import.
(I really only need the first line to export)
I was trying to do it with macros, but alas, my IT department has a GPO that prevents macros. I've been successful with running vb, however.
Is there a module I could add to save the file automagically without input?