Here's my problem. I'm pulling data from a server daily, so the date o
the worksheet will change. Not only will the date change, but so wil
the number of rows, due to the data that is collected. I tried t
create a macro to automate the graphing of each worksheet, but th
problem that I have ran into is that the macro is programed with th
worksheet name and the range that the worksheet used. I need to b
able to use the same macro for differently named worksheets an
different ranges. Is there a better way of doing this? Or is there
better way to code the macro so it doesn't recognize the name of th
worksheet or the range? I am new to vba, so it's all greek to me.

Also is there a way where I can automate this process daily. TIA

--
Message posted from http://www.ExcelForum.com

Hi
create a dynamic chart (no macros required). See:
http://www.tushar-mehta.com/excel/so...art/index.html
http://peltiertech.com/Excel/Charts/Dynamics.html
http://www.tushar-mehta.com/excel/ne...rts/index.html


--
Regards
Frank Kabel
Frankfurt, Germany

"Vapanda " schrieb im
Newsbeitrag ...
Here's my problem. I'm pulling data from a server daily, so the date
of
the worksheet will change. Not only will the date change, but so
will
the number of rows, due to the data that is collected. I tried to
create a macro to automate the graphing of each worksheet, but the
problem that I have ran into is that the macro is programed with the
worksheet name and the range that the worksheet used. I need to be
able to use the same macro for differently named worksheets and
different ranges. Is there a better way of doing this? Or is there
a
better way to code the macro so it doesn't recognize the name of the
worksheet or the range? I am new to vba, so it's all greek to me.

Also is there a way where I can automate this process daily. TIA.


---
Message posted from http://www.ExcelForum.com/

Frank,

Thanks for your help, but I'm sorry I might have been vague with m
question.
1) I collect data everyday.

The data is not the same, which means I'll probably have to put in
different workbook, not add on to the current work book

The number of rows or columns.

2) The data that I collect I have to make a Line Graph

The is created the same way, but with different data set.

Thanks for the links though, I've tried it and it didn't work. An
other suggestions for this type of automation

--
Message posted from http://www.ExcelForum.com