View previous topic :: View next topic |
Author |
Message |
kdenney
Joined: 20 Nov 2014 Posts: 6
|
Posted: Wed Jan 21, 2015 3:30 pm Post subject: Macro *.csv import question |
|
|
Hello,
I looked briefly for a topic related to this but couldn't find anything.
I have written a macro to import a large quantity (1000s) of csv files in a single folder and generate plots and images, set scales, colors, etc. The *.grf and *.png files that are generated inherit the filename of the *.csv that is imported - this is great. Now to the question... Is there any way to link the Title of the chart to the csv filename as well? I've found when I generate a plot using the excel add-in, the title is inherited from either the filename and/or sheet name, but I can't seem to find any way to automatically set the title using the Title1("string") macro command.
Any help with this is greatly appreciated
Thanks in advance!
kd |
|
Back to top |
|
|
jsc
Joined: 02 Dec 2005 Posts: 222
|
Posted: Wed Jan 21, 2015 5:00 pm Post subject: |
|
|
I think the command in a macro is:
Title1("$FILETITLE")
Which should assign the filename to the first line of the title block area. |
|
Back to top |
|
|
kdenney
Joined: 20 Nov 2014 Posts: 6
|
Posted: Wed Jan 21, 2015 6:03 pm Post subject: |
|
|
jsc,
Thanks for the reply. Worked like a charm... Out of curiosity, it seems to be grabbing the "*.grf" in the title as well, do you know if this is editable? |
|
Back to top |
|
|
DPlotAdmin Site Admin
Joined: 24 Jun 2003 Posts: 2310 Location: Vicksburg, Mississippi
|
Posted: Wed Jan 21, 2015 7:17 pm Post subject: |
|
|
There is not, sorry. _________________ Visualize Your Data
support@dplot.com |
|
Back to top |
|
|
kdenney
Joined: 20 Nov 2014 Posts: 6
|
Posted: Thu Jan 22, 2015 8:44 am Post subject: |
|
|
Not a problem... Thanks! |
|
Back to top |
|
|
|