macro-exporting to new workbook

[gray78]

I have a macro but need the code to export the data (and headings) to a new workbook. How is this done using VB code?

Thanks
DK

 

[BoniR]

hello there!
were are you exporting from? excel, access, text file?
If it is excel then you can use the macro below...

Sub export()

' export Macro

    ActiveWorkbook.SaveAs Filename:= _
        "filepath\name.xls", FileFormat:=xlNormal _
        , Password:="", WriteResPassword:="", ReadOnlyRecommended:=False, _
        CreateBackup:=False
End Sub

you will need to change the filepath and name of the file to your save location...and you can add a password or change the False settings to True if needed...

hth~
Boni
)

Boni J. Rychener
Hammerman Associates, Inc.
Crystal Training and Crystal Material
On-site and public classes
Low-cost telephone/email support
FREE independent Crystal newsletter

http://www.hammerman.com

800-783-2269

 

[SkipVought]

Hi,

If you turn on your Macro Recorder and go thru the process of doing what you want, your'd at least have a starting point for a macro.

Skip,

_{[red]A palindrome gone wrong?[/red]
A man, a plan, a ROOT canal...
PULLEMALL!}