Export multiple tabs & Ensure that All links are disabled &formats are retained

Hi all ...

in the attached workbook, i have a "generate graphs" tab/worksheet

I was the user to enter the destination folder they want the reports saved in cell e13 of this sheet.

then i want the user to enter the name of what the want the workbook to be called in cell e16

from these two variables, I want some code that exports all tabs a, b and c to the destination folder with the above file name.

THE MAJOR PROBLEM:

i had a programmer do this and everything exports ok BUT, the workbook that gets created has LINKS back to this original workbook. I do not want ANY links on the exported workbook.

Also my previous programmer, found that he can Not get ALL THE Charts formats exactly the same as the original. when he does the export, the charts change to numeric values for dates on the x axis and the y axis (without the $ signs on the y axis and bar labels)

All the charts on tab a, b & c in this attached workbook have dates on the "x" axis and Currency $ Signs on the y axis... as well as currency $ signs on each bar..

I need all these formats to remain EXACTLY the same as they are in the original attached once it has exported. I want this to remain a Static copy without any links back to the attached workbook..

its like i need to have a snapshot of all these tabs in the newly created workbook.

I need the workbooks to be exported very fast with all the above mentioned intact..

I need help urgently.. my other junior programmer can export fine, but can Not retain all the formats exactly the same and can Not disable links to the source.. I need one of you very smart geniouses to figure this out and provide me a solution please......

each a,b,c tab refers to data in the "charts" tab.. I do not want the charts tab exported though..

please provide me a solution ... kindly put the working code in this attached workbook,please test to see the output is exactly the same as orignial and attach it to this forum post.. pleaseeeeee

Thank you SOOOOOOOOOOOOOO much everyone...

Originally Posted by Domski

Personally I think you'd be better off getting your 'programmers' to post the questions that they need to complete the project and you never know they might learn something.

I can't open 2007 files so not sure where they've got to but to get you started this will replace any formula in a sheet with values.

Please Login or Register  to view this content.

Dom

hi there, i have attached the 2003 version here.. please solve the problem i am having... its not as straight forward with the above... by the way my programmer left me hanging and now i need help urgent... please help..

thank you and i wait for your solutions.. please attach you solution..

thankyou

Originally Posted by Domski

I can't see any code in the workbook. Can you try saving it again or posting the code separately.

Dom

I dont have any code for this workbook.. i deleted it as it wasnt working and dont have a copy... it was very messy .. please kindly redo..

thank you