Hmm, on my computer its not working may be due to version,(i have Excel 2010.)
and what should i replace so that it gets copied in notebook because i think in word it gets copied in table format.
debraj,
i tried but i was only able to record whatever i was doing on excel sheet in macro when i copied the data to note pad it was not recorded in macro.
hi ,
i am new and i was trying to learn macro thing so that i can do one simple thing(for me its hard doing in vba). i wanted to copy sheet1 from excel to notepad file (test.txt) and then rename it to test.doc .i tried to record macro and i was able to record the macro for only doing copying but...
hi,
i am new to excel and vba macro.
i wanted to create a text file copying everything on sheet1 and then saving it to that text file.
even it would be better if i can rename that text file.
is it possible.
regards,
Abhisekh