Windows Server 2012 Scheduled Task

Richard Korts
Richard Korts used Ask the Experts™
on
Is it possible to do the following on a Windows 2012 server using a scheduled task:

1. Log into Quick Books (QB) as the administrator.

2. Run a Excel 16 Macro that exports a QB table, into Excel & saves it.

3. Ftp  that Excel file to a web server.

4. From a browser start a web server script.

5, Log OUT of Quick Books

Thanks.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Business Consultant (Owner)
Most Valuable Expert 2012
Expert of the Year 2018
Commented:
QuickBooks itself does not support command lines. QuickBooks Launcher can start a Company File.

But once in, there is no native QuickBooks automation.

So, no, you cannot do what you want.

You would need go the QuickBooks Marketplace and use something like Transaction Pro Exporter to do what you want outside of QuickBooks. I think it support command line.
Richard KortsBusiness Owner / Chief Developer

Author

Commented:
Thanks, John.

Richard
JohnBusiness Consultant (Owner)
Most Valuable Expert 2012
Expert of the Year 2018

Commented:
You are very welcome Richard and I was happy to assist you.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial