Need a macro to export a single sheet as - Paste special (Values)
Hi,
I have an excel file which contains 8 sheets. One sheet with name (Final Reports) I want to export as a different file as Values(The main sheet contains formulas). So I dont need the formulas. It should be only values. (Paste special - values).
The file name should start with Reports which is followed by date and time when I am exporting it.
Please help...
Last edited by kishoremcp; 06-11-2012 at 12:00 PM.
Try
Please Login or Register to view this content.
I tried to use that macro. It is asking me to save the file and asking for name also. It is not automatically saving the file with Reports followed by date and time...
Sorry I missed some "
This works for me
Please Login or Register to view this content.
Yes. Its working. Thank you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks