acspreadsheet.jpg

<div>
<div class="content wysiwyg-content">
I am having to update the value of the SpreadsheetType in DoCmd.TransferSpreadsheet based on the user's version of MS Access. &nbsp;<br />
<br />
Is there a vba code to determine the SpreadsheetType value without having to hardcode it as acSpreadsheetTypeExcel3, acSpreadsheetTypeExcel9, etc ?<br />
<br />
Thanks.
</div>
</div>


I am having to update the value of the SpreadsheetType in DoCmd.TransferSpreadsheet based on the user's version of MS Access.  

Is there a vba code to determine the SpreadsheetType value without having to hardcode it as acSpreadsheetTypeExcel3, acSpreadsheetTypeExcel9, etc ?

Thanks.

Dynamically Determine the SpreadsheetType value in DoCmd.TransferSpreadsheet Method

Most development for the Microsoft platform is done utilizing the technologies supported by the.NET framework. Other development is done using Visual Basic for Applications (VBA) for programs like Access, Excel, Word and Outlook, with PowerShell for scripting, or with SQL for large databases.

Microsoft Development

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.