Hi,
I work in excel template where the last sheet of the excel needs to be imported in some software in csv format. This last sheet is hidden.
I want a macro where data from this hidden sheet is copied and pasted in new excel orksheet like it should form a separate excel. After copy paste of data the hidden sheet should be hidden.
Good if any help received on this.
-Shweta
Hi Shweta,
It will be advantageous if you can upload a dummy worksheet in order to receive a solution..
Honestly, I am no good in VBA, however, personally I have received help from the Forum several times and in one of my queries similar to your question , you can create a WorkBook with the Sheets you require however I am not sure about the Hidden aspects in particular...
This might be helpful for you..!
http://www.excelforum.com/excel-prog...amic-path.html
Warm Regards
e4excel
Last edited by e4excel; 02-08-2012 at 01:49 AM.
Whats the name of the hidden worksheet? Also, just like e4excel said, why dont you attach a dummy workbook?
Cheers,
Arlette
If I helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks