ACCESS FEED: Re: [MS_AccessPros] wrong forum, but excel VBA

Kamis, 30 Juli 2015

Re: [MS_AccessPros] wrong forum, but excel VBA

Afterthought, if your IT department will allow you to build a temporary table in the database, then this code shared before will allow for the range method to work using a simple query to set up the recordset to be used to create the worksheet.

I cut the run time down from hours to a few minutes by using an Excel range rather than a cell by cell copy.

-----Original Message-----
From: "Liz Ravenwood liz_ravenwood@beaerospace.com [MS_Access_Professionals]"
Sent: Jul 30, 2015 1:23 PM
To: "MS_Access_Professionals@yahoogroups.com"
Cc: Richard Miller , Hal McGee
Subject: [MS_AccessPros] wrong forum, but excel VBA

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.