Topic Options
#56426 - 02/14/18 08:22 AM Excel Direct from Invoices - Errors
Carol Lord Openhym Offline
5 Corgis and Counting

Registered: 04/06/05
Posts: 179
Loc: Baltimore, Maryland USA
Hi all,
My client is trying to use Excel Direct in Adagio Invoices and is getting the following:

1st Message – Error Code: 1001 on ToXLTransferCell
2nd Message – Error Code: 1001 on ToXLSetTextProperties

Version 9.2A (161013)
Excel 2016

She can use Excel Direct in Accounts Receivable. Another user is able to use Excel Direct in Invoices.

Thoughts?
_________________________
Carol Lord Openhym
Allegro Automation, Inc.
Baltimore, MD USA

Top
#56427 - 02/14/18 08:30 AM Re: Excel Direct from Invoices - Errors [Re: Carol Lord Openhym]
Dan_Desautels Offline
Adagio Maestro

Registered: 07/21/11
Posts: 1169
Loc: Thunder Bay, ON, Canada
Hi Carol,

Those errors generally suggest a problem communicating with Excel. Try closing all Adagio modules and Excel files and try again. If not reboot, since there may be an instance of Excel stuck in the background.
_________________________
Dan Desautels
DezTek Solutions Inc.
Thunder Bay, ON

Top
#56428 - 02/14/18 09:04 AM Re: Excel Direct from Invoices - Errors [Re: Dan_Desautels]
Carol Lord Openhym Offline
5 Corgis and Counting

Registered: 04/06/05
Posts: 179
Loc: Baltimore, Maryland USA
Thanks Dan. Will do.
_________________________
Carol Lord Openhym
Allegro Automation, Inc.
Baltimore, MD USA

Top
#56430 - 02/14/18 09:09 AM Re: Excel Direct from Invoices - Errors [Re: Carol Lord Openhym]
Carol Lord Openhym Offline
5 Corgis and Counting

Registered: 04/06/05
Posts: 179
Loc: Baltimore, Maryland USA
Reboot did the trick. Thanks again, Dan!
_________________________
Carol Lord Openhym
Allegro Automation, Inc.
Baltimore, MD USA

Top


Moderator:  Christa_Meissner 
Who's Online
3 registered (AGatewood, Tanya_Belanger, Jesse_Gilbert), 75 Guests and 1 Spider online.
Key: Admin, Global Mod, Mod
Forum Stats
1865 Members
5 Forums
14480 Topics
70718 Posts

Max Online: 432 @ 01/20/25 10:17 PM
May
Su M Tu W Th F Sa
1 2 3
4 5 6 7 8 9 10
11 12 13 14 15 16 17
18 19 20 21 22 23 24
25 26 27 28 29 30 31