Access/Excel was Ugraded Issue

[cstimart]

My employer upgraded from Office 2007 to Office 365. I have an Access db that gathers/opens data from and Excel file and everything was working file in 2007. Now, the code will FREEZE below on the SET. In the References, I do have Microsoft Excel 16.0 Object Library.

Dim objExcel As Excel.Application

    Set objExcel = New Excel.Application

Any ideas why this freezes and/or how to fix?

Thanks!

 

[ranman256]

yeah, upgrades mess up everything.
you must go into references, and select a new Excel X.X library.
(scroll down the list)

 

[cstimart]

yeah, upgrades mess up everything.
you must go into references, and select a new Excel X.X library.
(scroll down the list)

In the References, I already have 'Microsoft Excel 16.0 Object Library.'....and it still freezes.

 

[xenou]

You can try:

dim objExcel as Object
set objExcel = CreateObject("Excel.Application")

 

[cstimart]

You can try:

dim objExcel as Object
set objExcel = CreateObject("Excel.Application")

Thanks, but it still freezes on the Set.

 

[ranman256]

we had a pc like that. It did not like the updgrade.
We tried another PC and it worked. Some PCs dont play well with upgrades.
try another pc.

 

[cstimart]

Thanks @ranman256 and @xenou for the help. It apparently is my PC