• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 4877
  • Last Modified:

Dynamically Determine the SpreadsheetType value in DoCmd.TransferSpreadsheet Method

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.
0
yvroger
Asked:
yvroger
1 Solution
 
Rey Obrero (Capricorn1)Commented:
xif access version is less than 12.0 , excel file extension .xls
use 8 for acSpreadsheetTypeExcel

docmd.transferspreadsheet acimport, 8,

you can also leave it blank

docmd.transferspreadsheet acimport, ,



for access version 12 and above, use 10 , excel file extension .xlsx

docmd.transferspreadsheet acimport, 10,
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now