ActiveX Save As function for Microsoft Excel 97- Excel 2003 & 5.0/95 Workbook (*.xls)

[krispiekream]

Can someone show me how to use Active X - Save As function?

I want to save it in  Microsoft Excel 97- Excel 2003 & 5.0/95 Workbook (*.xls)

thanks in advance!

[smercurio_fc]

please don't double post

As has been mentioned many times, this is a forum of volunteers, and most of us, like me, have full-time jobs. Please be patient.

All answers should go into the original thread - please don't post here. Thanks.

[krispiekream · Accepted solution]

Oh,

I thought people stopped reading my other post so I posted another.

sorry.

but i found the solution

FileFormat					variant name		integer code
Microsoft Excel Workbook			xlWorkbookNormal	-4143
Web Page					xlHTML			44
Template					xlTemplate		17
Text (Tab Delimited)				xlCurrentPlatformText	-4158
Unicode Text					xlUnicodeText		42
Microsoft Excel 5.0/95 Workbook			xlExcel5, xlExcel7	39
Microsoft Excel 97-2000 & 5.0/95 Workbook	xlExcel9795		43
CSV (Comma Delimited)				xlCSV			6
Microsoft Excel 4.0 Worksheet			xlExcel4		33
Microsoft Excel 3.0 Worksheet			xlExcel3		29
Microsoft Excel 2.1 Worksheet			xlExcel2		16
Microsoft Excel 4.0 Workbook			xlExcel4Workbook	35
WK4 (1-2-3)					xlWK4			38
WK3, FM3 (1-2-3)				xlWK3FM3		32
WK3 (1-2-3)					xlWK3FM3		15
WK1, FMT (1-2-3)				xlWK1FMT		30
WK1, ALL (1-2-3)				xlWK1ALL		31
WK1 (1-2-3)					xlWK1			5
WKS (1-2-3)					xlWKS			4
WQ1 (Quattro Pro/DOS)				xlWQ1			34
DBF 4 (dBASE IV)				xlDBF4			11
DBF 3 (dBASE III)				xlDBF3			8
DBF 2 (dBASE II)				xlDBF2			7
Formatted Text (Space Delimited)		xlTextPrinter		36
Text (Macintosh)				xlTextMac		19
Text (MS-DOS)					xlTextMSDOS		21
CSV (Macintosh)					xlCSVMac		22
CSV (MS-DOS)					xlCSVMSDOS		24
DIF (Data Interchange Format)			xlDIF			9
SYLK (Symbolic Link)				xlSYLK			2

 

I know that its saving in the correct format. BUT I don't know why it wouldnt save 2 worksheets, but instead it only have 1.