export worksheets

Hi, I am currently working on a VBA code that has a specific button to export a copy of the worksheet in question. The table has a column for date and time together in this format: dd-mm-yyyy hh:mm AM/PM;@ The import of the data into this worksheet works fine, however when exporting the...

Hi Guys, I am using a code to create duplicate workbooks for each page of my master workbook, and send them into a folder. Is there any way I can alter this code to just pick specific worksheets to export to individual workbooks? Sub CreateWorkbooks() Dim wbDest As Workbook Dim wbSource As...

I have been using the below macro to export worksheets without macros/formulas, now I am looking to export the whole workbook without formulas and macros. Export it as a "flattened" workbook. Sub Flatten() Dim wbDest As WorkbookDim wbSource As Workbook Dim sht As Object Dim strSavePath As...

I am using an export code to take my worksheets to a destined folder in xlsm format. I am looking to adjust this formula so when the worksheets are exported it is a flat file that just contains the values in the cells NOT the formulas. Sub CreateWorkbooks()Dim wbDest As Workbook Dim wbSource As...