Saving through vb

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?

Thanks!
TIgerVAsked:
Who is Participating?
 
Martin LissConnect With a Mentor Older than dirtCommented:
Okay then record a macro that does what you want and change it from

Sub Macro1() 

' code

End Sub 

Open in new window

to

 Private Sub MyMacroName() ' This can be Private or Public

' code

End Sub 

Open in new window


and then look up how to use OnTine if you don't know already.

If the code is still caught as a macro, which I doubt will happen, cut the code out of the sub,
create a new sub manually and paste the code.
0
 
Martin LissOlder than dirtCommented:
You have to use at least some VBA. At a minimum

Application.OnTime ….

with some parameters and a macro to do the SaveAs.
0
 
TIgerVAuthor Commented:
No way to do it all via VBA, though?
0
Cloud Class® Course: Microsoft Exchange Server

The MCTS: Microsoft Exchange Server 2010 certification validates your skills in supporting the maintenance and administration of the Exchange servers in an enterprise environment. Learn everything you need to know with this course.

 
Martin LissOlder than dirtCommented:
Macros are VBA so I assume from your first post that you can't use any code.
0
 
TIgerVAuthor Commented:
I have previously been successful in running vba, just not macros recorded through the macro feature.
0
 
Martin LissOlder than dirtCommented:
I'm glad I was able to help.

Marty - MVP 2009 to 2012
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.