Worksheet name that changes into a chart title

[bolted4]

How do I put a worksheet name, or file name (.csv file) that changes into a chart title?
The worksheet name changes in a .csv file that I run a macro on to create chart. I want to name that chart the worksheet name or the file name.
Thanks In advance
Dave

 

[bolted4]

Nevermind I figured it out, sorry but I cant delete message, I was too slow

 

[Tazguy37]

Glad you got it solved. If you would, please post your solution for others that might have the same querstion. Thanks!!