hello there!
were are you exporting from? excel, access, text file?
If it is excel then you can use the macro below...
Code:
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
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.