copy sheet name from one workbook to a cell in another workbook

hi,

i have a variable CSV file that is downloaded into one of my folders

what i would like to do is copy that sheetname/or file name ( they are the same )
to a cell in another workbook that will be open at the same time as i am coping data from the CSV file to the open Excel file
via a macro . The cell i would like it in is in "J1" "sheet2"

thanks
steve

attach your code with comments

Please Login or Register  to view this content.

hi,

if i run the code on it own it works

if i put this into my code i get an error about "newpath", "filenam" varibles not defined ,
could you help me with please

thanks

steve

maybe you have option explicit in your code, then you have to declare all variables
dim wbcsv as workbook, newpath as string, filenam as string