Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Define a variable for dynamic chart
I have a excel file wich I have modified with a number of userforms, macros
and so on. One of the macros make a chart wich the user can page through several columns. One by one. I want the user to be able to save the file witout having to change the macro. I know how to define the open workbook as a variable, but I am not sure how to use a variable in this macro? ActiveChart.SeriesCollection.NewSeries ActiveChart.SeriesCollection(1).XValues = "='Log_1.xls'!XValues" ActiveChart.SeriesCollection(1).Values = "='Log_1.xls'!YValues" ActiveChart.SeriesCollection(1).Name = "='Log_1.xls'!Name" Can anyone help me? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Define a variable for dynamic chart
Maybe I didn't explain well enough. I want to exchange the
"='Log_1.xls'!XValues" with something like "=Variable!XValues". This is to be able to save the file with another name. BTW: VH skrev: I have a excel file which I have modified with a number of userforms, macros and so on. One of the macros make a chart which the user can page through several columns. One by one. I want the user to be able to save the file witout having to change the macro. I know how to define the open workbook as a variable, but I am not sure how to use a variable in this macro? ActiveChart.SeriesCollection.NewSeries ActiveChart.SeriesCollection(1).XValues = "='Log_1.xls'!XValues" ActiveChart.SeriesCollection(1).Values = "='Log_1.xls'!YValues" ActiveChart.SeriesCollection(1).Name = "='Log_1.xls'!Name" Can anyone help me? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Define a variable for dynamic chart
Hi,
try "=" & Variable & "!.XValues" Udo |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Define a variable for dynamic chart
Thank you Udo! Works perfect!
Udo skrev: Hi, try "=" & Variable & "!.XValues" Udo |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Define Variable Name using VBA | Excel Discussion (Misc queries) | |||
Define Dynamic Name | Excel Discussion (Misc queries) | |||
dynamic search in the Define Name window | Excel Discussion (Misc queries) | |||
How to define variable | Excel Programming |