Macro *.csv import question

kdenney · Post by **kdenney** » Wed Jan 21, 2015 3:30 pm

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

jsc · Post by **jsc** » Wed Jan 21, 2015 5:00 pm

I think the command in a macro is:

Title1("$FILETITLE")

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

kdenney · Post by **kdenney** » Wed Jan 21, 2015 6:03 pm

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?

Post by **DPlotAdmin** » Wed Jan 21, 2015 7:17 pm

There is not, sorry.

kdenney · Post by **kdenney** » Thu Jan 22, 2015 8:44 am

Not a problem... Thanks!