| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
trending data from a csv file with one macro with changing worksheet name.
I currently have multiple csv files from a SCADA computer system that I am converting to excel spreadsheets. All of these files have a designated name like "TANKS000.csv". If the files are not converted within a 24 period then The SCADA Program will create another CSV file named "TANKS001.csv". Here is my problem, how can I write the macro to trend my data to a chart no matter what the worksheet is named? Here is a sample of the macro where I am getting hung up.
ActiveChart.SetSourceData Source:=Sheet("TANKS000").Range("B8:M103"), _ PlotBy:=xlColumns I need help!!!! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I display trending data in different colors (up=red) | Excel Discussion (Misc queries) | |||
| changing a macro each time the file name changes | Excel Discussion (Misc queries) | |||
| Trending data | Excel Discussion (Misc queries) | |||
| Unable to run excel macro after changing file name | New Users to Excel | |||
| Open delimited text file to excel without changing data in that file | Excel Programming | |||
![Ray Morton[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
