Pros, I understand if this is ignored as I am pending membership to a more appropriate forum, but thought I’d throw it out here since traffic is light right now and there are so many VBA pros.
I have an excel file with an ODBC connection to an SQL Server using ADO. The code is running a bill of materials that could easily be 15 to 20 thousand lines and when I run it I can’t interact with my computer since it is moving from row to row, cell to cell, and populating recordset retrieval information.
I started it up at 3:30 and ran it until about 8PM last night and it only ran 4800 lines and our Citrix network will naturally time the process out.
Is there anyway I could do either/and 1. Speed this up 2. Run in the background 3. Automate it by some sleeper or task?
I can’t use my task manager as that is a windows process and I need this to run WITHIN the intranet using the Citrix connection.
Ideas anyone?
Respectfully,
Liz Ravenwood
Programmer / Analyst
B/E Aerospace | Super First Class Environments
1851 S Pantano Road | Tucson, Arizona 85710
Office +1.520.239.4808 | Internal 814-4808
beaerospace.com
Passion to Innovate. Power to Deliver
This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
Posted by: Liz Ravenwood <Liz_Ravenwood@beaerospace.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (1) |
Tidak ada komentar:
Posting Komentar