woodwyn
asked on
VFP can no longer export to Excel after O365 installation
After uninstalling Office 2010 and installing Office 365 I cannot export to Excel from VFP.
The line
loExcel = CREATEOBJECT("Excel.Applic ation")
generates the error
OLE error code 0x80040154: Class not registered.
I am seeing some suggested solutions online, but am wondering if they apply to the latest version of Office. Locating the Office version in Excel shows
Microsoft Excel for Office 365 MSO (16.0.11126.20234) 32-bit
Thanks in advance!
The line
loExcel = CREATEOBJECT("Excel.Applic
generates the error
OLE error code 0x80040154: Class not registered.
I am seeing some suggested solutions online, but am wondering if they apply to the latest version of Office. Locating the Office version in Excel shows
Microsoft Excel for Office 365 MSO (16.0.11126.20234) 32-bit
Thanks in advance!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
The Registry entry is in HKEY_CLASSES_ROOT:All the older versions point to the version 16 today.
ASKER
Thank you sir. It'll take a little while before I can get that done.
ASKER
This issue resolved itself. Perhaps after a reboot. I just noticed it is working now. None the less, thanks as always!!!
This is interesting. OLE class registration does not need the reboot but the office installation may require it so then OK.