Page 1 of 1

Macro *.csv import question

Posted: Wed Jan 21, 2015 3:30 pm
by kdenney
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

Posted: Wed Jan 21, 2015 5:00 pm
by jsc
I think the command in a macro is:

Title1("$FILETITLE")

Which should assign the filename to the first line of the title block area.

Posted: Wed Jan 21, 2015 6:03 pm
by kdenney
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?

Posted: Wed Jan 21, 2015 7:17 pm
by DPlotAdmin
There is not, sorry.

Posted: Thu Jan 22, 2015 8:44 am
by kdenney
Not a problem... Thanks!