Create folder & export sheet, not working

**rinser** · 05-28-2009, 10:25 AM

Hi everybody,

I was working on some code that would create a new folder in My Documents and within that folder export the current worksheet and save it there with a particular name. After doing so I need it to return to the original worksheet and clear contents.
I would also need to export to the new sheet only contents of the cells without any macros or buttons.
If someone has any idea what is wrong with my code please help!

Please Login or Register  to view this content.

**rinser** · 05-29-2009, 04:27 AM

I am surprised nobody knows how to solve this. I guess people are just gone fishing!

I also posted this topic here, please check it:

http://www.vbaexpress.com/forum/show...271#post186271

Cheers!

**DonkeyOte** · 05-29-2009, 04:55 AM

When you say it doesn't work - which bit -- as I see it all but the clearcontents should work ... as is you're clearing contents of the new file as opposed to the old.

Please Login or Register  to view this content.

Be wary of how you declare variables... in VBA this:

Please Login or Register  to view this content.

declares a & b as Variants, only c is a String... (unlike .NET) you should therefore use

Please Login or Register  to view this content.

If the sheet contains code / objects your best bet would be to cre*ate a new workbook from scratch and then copy / paste values / formats etc from the main file to the new file (ie don't copy the sheet).

**rinser** · 05-29-2009, 05:31 AM

Thanks a lot DonkeyOte!
It works now

Only thing is in the workbook that is exported remains the button and module that generated it. I wonder if it's posible to get rid of it so that the final user sees only what was on the sheet. This only if it's not very complicated, otherwise it's not a big deal.
Cheers!

**Kenneth Hobson** · 05-29-2009, 08:31 AM

The method that I used in this thread might help. http://www.excelforum.com/excel-prog...ileformat.html

**rinser** · 05-29-2009, 09:00 AM

That's an interesting approach Kenneth!
Wouldn't have thought about that way in ages.
Good thing people now have two interesting solutions (a bit different task) in one thread. Wish I had the same when looking for answers

Thank you!