I have a excel 2007 workbook , with current worksheet named 'a'
Now what I want is,
1. When user clicks a button in sheet a, it should ask which csv file to import,
2. Ask for name of that new sheet user want (where that csv file is to be placed).. Say, to simplify user says 'b' now.
3. After that copy 'sheet a' into the new sheet b.
4. Import the csv into that new sheet, comma delimted, and allow overwriting of existing cells in copied sheet.
What can be basic start level code to accomplish all these tasks.
I will be grateful for any help in this regard.
Thanks
Sal
Bookmarks