Override Access's Current Internal Choices

[JMay]

Whether manually or in VBA in Access 2007 when I run an Export to Excel
Access or somebody?? (internally) is deciding to Load Excel 2003 (which is
on my machine) and bring up the exported data inside Excel 2003, and NOT
Excel 2007 which I want it to do (and I also have installed as the Default
for all xls files. Further, In my VBA I have Tools, References set for Acess
2007 and Excel 2007 ) that No Excel 2003 to be seen. The file export name
even has an extention of .xlsx, but still Access is choosing Excel 2003, or
worse My system i s overriding Access and forcing the Excel 2003 to recive
the file. Is there a line of code that I can enter to Insure/force Xl 2007
to be the program of choice here...???

Any help appreciated,

Jim

 

[Roger Carlson]

If you're using TransferSpreadsheet in VBA, make sure you're using the
correct version

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel12, ...


--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[JMay]

I am not using such a command -- DoCmd.TransferSpreadsheet

My one line of code withing the CommandButton_Click is:
DoCmd.RunSavedImportExport "Export-Last_CBF_DB_Export"

Thanks,

Jim

 

[JMay]

Roger, Thanks I've substituted the TransferSpreadsheet for what I had
earlier.
However, If afterwards (the export) I double-click the file -- up it comes
being opened in Excel 2003 - I tried it again Opening Excel 2007 before
double-clicking the filename; Still the file opened in Excel 2003. grrrrr...

One slightly different question here; If I need to manipulate the
ExportFile.xlsx before copying it's final form to my
ExcelAnalysisTemplate.xlsm - Do I do all the coding to complete the entire
process from within the same Access VBA module? I've never been this far
into integration... Or, do I "transfer" control over to Excel using and
writing code in its VBA within the ExcelAnalysisTemplate.xlsm files VBE?

Thanks,

Jim

 

[Roger Carlson]

You should be able to do most of it by manipulating an Excel object within
Access.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L