Can I automatically create a daily chart from flat file?

  • Thread starter Thread starter dcibrando
  • Start date Start date
D

dcibrando

I have some flat file data being generated into a text file daily...

is it possible and if so how... can I generate a daily chart within
excel

basically we want to be able to pull up a webpage with charts so how
would I go about doing this?

(e-mail address removed)
 
I'm not sure how the web page fits in, but if the text file were local, I'd
record a macro when I opened it.

Do all the Text to column stuff. Add headers and filters and charts and then
stop recording.

Save that macro in a workbook of its own and then whenever I wanted to open that
text file, I'd open that macro workbook and run that macro.

If you need help making your macro work on the second text file, post back with
the snippet of code -- not the workbook and I'm sure you'll get help.
 
but can this macro be scheduled to run each day at a certain time?

I've never created a macro so this would be new to me... I'll see what
I can do
 
You can have excel run a macro at a certain time, but excel will have to be kept
open for all that time.

You might be better served by using a scheduling program. Some versions of
windows come with an application like this. And you could visit
http://shareware.com to look for scheduling programs if you don't have it.

This scheduler would open a workbook at a specified time. Inside that workbook,
there'd be a macro (called auto_open or put into the workbook_open event) that
would run whenever that workbook was opened.

After you've recorded that macro and want to tweak it some, post back if you're
having troubles.
 
Back
Top