Re: [MSAccessProfessionals] Officelink from MS Access 2003 not working in MS Access runtime 2019 #'

On Wed, Nov 18, 2020 at 07:25 PM, novice012000 wrote:

I have a split database written and compiled in MS Access 2003. Every report has a toolbar with Excel Office Links.
One new computer is running the database with MS Access 2019 runtime. The program works fine, however the Excel function on the toolbar does not work.
I dont have time right now to convert this database to a newer version of MS Access
Can I do anything in MS Access 2003 to make the Excel Office Link work with 2019 ?

As always all help is greatly appreciated.
Thanks
Sarah

Sarah - How are you doing this? I have a 2003 mdb & mde that uses a command to export to Excel. The trick is to use the old .xls format.
DoCmd.OutputTo acOutputQuery, "myQuery", acFormatXLS

acFormatXLS is the old Excel format.
 
--

Regards,

Bill Mosca, Founder - MS_Access_Professionals

Microsoft Office Access MVP 2010-2016

My nothing-to-do-with-Access blog

http://wrmosca.wordpress.com

 

_._,_._,_

---

Groups.io Links:

You receive all messages sent to this group.

View/Reply Online (#115798) | Reply To Group | Reply To Sender | Mute This Topic | New Topic
Mute #'
Your Subscription | Contact Group Owner | Unsubscribe [sugeng.panjalu.access@blogger.com]

_._,_._,_