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: 180
Loc: Baltimore, Maryland USA
(173.64.94.197)
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: 1174
Loc: Thunder Bay, ON, Canada
(50.70.188.43)
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: 180
Loc: Baltimore, Maryland USA
(173.64.94.197)
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: 180
Loc: Baltimore, Maryland USA
(173.64.94.197)
Reboot did the trick. Thanks again, Dan!
_________________________
Carol Lord Openhym
Allegro Automation, Inc.
Baltimore, MD USA

Top


Moderator:  Christa_Meissner 
Who's Online
1 registered (Tanya_Belanger), 262 Guests and 3 Spiders online.
Key: Admin, Global Mod, Mod
Forum Stats
1874 Members
5 Forums
14564 Topics
71079 Posts

Max Online: 630 @ Today at 02:28 AM
November
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