| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
help with macro to export data
can I use a macro to export data to another workbook? I mean, if I have data
on workbook 1, Sheet A ... can I use a macro to export all data from "Workbook 1, Sheet A" to "Workbook 2 Sheet B" ?? Thanks, Mayte |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
help with macro to export data
Maybe you can use this macro:
Sub sheetcopy() Workbooks("Workbook 1.xls").Sheets("Sheet A").Copy _ After:=Workbooks("Workbook 2.xls"). _ Sheets(Workbooks("Workbook 2.xls").Sheets.Count) Workbooks("Workbook 2.xls"). _ Sheets(Workbooks("Workbook 2.xls").Sheets.Count).Name = "Sheet B" End Sub Regards, Stefi €˛Mayte€¯ ezt Ć*rta: can I use a macro to export data to another workbook? I mean, if I have data on workbook 1, Sheet A ... can I use a macro to export all data from "Workbook 1, Sheet A" to "Workbook 2 Sheet B" ?? Thanks, Mayte |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
help with macro to export data
great ...thanks a lot !!
Cheers, Matyte "Stefi" wrote: Maybe you can use this macro: Sub sheetcopy() Workbooks("Workbook 1.xls").Sheets("Sheet A").Copy _ After:=Workbooks("Workbook 2.xls"). _ Sheets(Workbooks("Workbook 2.xls").Sheets.Count) Workbooks("Workbook 2.xls"). _ Sheets(Workbooks("Workbook 2.xls").Sheets.Count).Name = "Sheet B" End Sub Regards, Stefi €˛Mayte€¯ ezt Ć*rta: can I use a macro to export data to another workbook? I mean, if I have data on workbook 1, Sheet A ... can I use a macro to export all data from "Workbook 1, Sheet A" to "Workbook 2 Sheet B" ?? Thanks, Mayte |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| excel xml export macro | Excel Discussion (Misc queries) | |||
| how do i create a macro to export a chart to powerpoint? | Charts and Charting in Excel | |||
| Export custom Macro Button Images | Excel Discussion (Misc queries) | |||
| Macro to export as Text, only the results not the formula | Excel Discussion (Misc queries) | |||
| Export Excel Data to Access With a Macro!!! | Excel Discussion (Misc queries) | |||
Linear Mode
