I use this code to export my worksheets to a folder as separate flat files, so none of the formulas or references carry over, just the values.
It doesn't seem to work, it is only exporting the first worksheet.
Please Login or Register to view this content.
Maybe:
Please Login or Register to view this content.
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
Thank you for the help,
Still not exporting tabs into folder though
Well then maybe:
Please Login or Register to view this content.
Thanks dept. It is exporting the separate files with the formulas, anyway I can flatten them to just have values?
Last edited by JPSIMMON; 08-18-2015 at 03:31 PM.
Hopefully,
Please Login or Register to view this content.
Hi JP,
Thanks for the rep!
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks