Setting Excel version in Access Basic

T

Tim Ferguson

It sounds like you're saying that if the user doesn't tell you which
version of spreadsheet you are about to link to, then just use the
default and hope that it works.

I don't know if it helps, but this took me less than a minute to find in
Excel VBA help, as one of the properties of the Workbook object:

FileFormat Property

See Also Applies To Example Specifics

Returns the file format and/or type of the workbook. Read-only
XlFileFormat.

XlFileFormat can be one of these XlFileFormat constants.
xlCSV, xlCSVMSDOS, xlCurrentPlatformText, xlDBF3, xlDIF, xlExcel2FarEast,
xlExcel4, xlAddIn, xlCSVMac, xlCSVWindows, xlDBF2, xlDBF4, xlExcel2,
xlExcel3, xlExcel4Workbook, xlExcel5, xlExcel7, xlExcel9795, xlHtml,
xlIntlAddIn, xlIntlMacro, xlSYLK, xlTemplate, xlTextMac, xlTextMSDOS,
xlTextPrinter, xlTextWindows, xlUnicodeText, xlWebArchive, xlWJ2WD1,
xlWJ3, xlWJ3FJ3, xlWK1, xlWK1ALL, xlWK1FMT, xlWK3, xlWK3FM3, xlWK4,
xlWKS, xlWorkbookNormal, xlWorks2FarEast, xlWQ1
xlXMLSpreadsheet


Seems to me that it would take a couple of lines of code simply to check
it's a kosher workbook format, translate to the outgoing version code,
and put that into the TransferSpreadsheet method.

Or am I missing something?

Tim F
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top