Recent Posts

Pages: [1] 2 3
I do tons of coding in MS Excel and MS Access. When coding in Access, many times I find the need to use the excel application object in order to manipulate existing workbooks or to create new workbooks populated with formatted data from the database. I have found 1000's of % increase in code execution speed can be gained by modifying 3 settings in your excel application during runtime:


Here's a VBA example to get you going:

Code: [Select]
Sub ExcelAppExample
        Dim oXLApp as New Excel.Application 'Create a new Excel Application Object
        Dim oXLBook as Excel.Workbook

                With oXLApp       'Disable Events, Screen Updating, and Calculation
                                          'You can capture As-Found settings in variables if you find the need
                                          'then before closing out, reset the settings to original         
                     oXLApp.EnableEvents = False
                     oXLApp.ScreenUpdating = False
                     oXLApp.Calculation = -4135 'xlCalculationManual
                End With

        Set oXLBook = oXLApp.Workbooks.Open("Drive:\Workbook.xls")

' Add your code to manipulate the workbook as required....

                With oXLApp       'Enable Events, Screen Updating, and Calculation
                     oXLApp.EnableEvents = True
                     oXLApp.ScreenUpdating = True
                     oXLApp.Calculation = -4105 'xlCalculationAutomatic
                End With

            oXLBook.Save 'Save the workbook
            oXLBook.Close 'Close the workbook
            oXLApp.Quit 'Quit the Application

         Set oXLBook = Nothing 'Release the object from memory
         Set oXLApp = Nothing 'Release the object from memory
End Sub
In one of my more complex access applications, I had to create several workbooks and many worksheets within each workbook. The worksheet was populated and formated as data was added. The difference this addition made was astounding!

The operation to create a worksheet, populate it, and format it averaged 2 minutes per sheet. I had 1950 worksheets to create (Divided among several workbooks). Modifying the settings as above decreased the operation time to 5 seconds per worksheet! Thats's an increase of around 2400%.

In terms of total time required:
Settings enabled = (1950 * 120)/3600 = 65 Hours
Settings DIsabled = (1950 * 5)/3600 = 2.7 Hours

Nuff Said.....
General Discussion / Re: Golf Tournament!!
« Last post by Steven Carter on July 26, 2011, 05:11:52 AM »
I may, or may not have, voted 15 or more...
RCM Employment / Taking Applications: RCM Outside Sales Representative
« Last post by Casey W Little on July 13, 2011, 01:51:44 PM »
Job# RSL0111307
RCM is actively searching for an Outside Sales Representative to handle the South-East Texas area. Compensation is above-average for the ideal candidate, with a higher than average sales commission. If you think you are a match for this job, please initiate contact with us Here ASAP. Refer to this Job Number in your initial contact, please.

Pay Information: Base Salary (experience-driven) + Commission
Travel: 60%+

Job Description
An RCM Outside Sales Representativeís job necessitates determining, generating and capturing the sales outside the organization. The main task involves taking orders of existing customers and securing prospective non-member clienteles by telephone communication or by visiting. It is essential for the Outside sale representative to provide effectively the detailed information on various products, programs or services offered by the company.

Duties and Responsibilities
  • Scheduling appointments, meeting existing customers in order to review product requirements, and to determine other opportunities.
  • Effective planning to conduct sales presentations by meeting customers physically on daily basis.
  • Designing professional demonstrations or presentations of company products or services while on-site.
  • Liaising between the company and the customers for up-to-date condition on pricing, service and latest product release launches.
  • Generating and developing non-customer businesses accounts in order to increase revenue, through cold calling.
  • Continuously updating all customers on company product modifications, changes, and enhancements.
  • Enhancing up to date knowledge on new products, procedures, services and tools by attending departmental and training meetings.
  • Maintaining professionalism, diplomacy, sensitivity, and tact to portray the company in a positive manner.
  • Effectively attending conferences and trade shows.
  • Using marketing data to maximize sales effectiveness and efficiency by using relevant sales management tools.
  • Organizing joint sale calls and attending them with vendors.
  • Preparing reports for sales and marketing and maintaining expense accounts.
  • Performing updating and maintenance of accounts of customer including contact names and numbers for future sales.
  • Providing product quotes to customers as needed.
  • Ensuring follow-up after passing leads to managers with complete profile customer information, calls-to-action, sources, dates.
Skills and Specifications
  • Capable of preserving confidential or sensitive information (Your job depends on it!).
  • Effective time management, organization and multi-tasking skills.
  • Special people skills to deal with customers and an outgoing personality.
  • Able to prospect non-customer accounts.
  • Able to upgrade and deal major businesses.
  • Very strong communication skills in writing and verbal.
  • Very good team player and should work well under pressure.
  • Able to foster the member relation values.
  • Proficient in Microsoft Word, Excel, Outlook.
  • Proven forecasting and customer service skills.

Education and Qualifications
  • Bachelorís degree in sales or marketing related field from an accredited institution, or equivalent sales experience
  • Degree in any field of sales and marketing
General Discussion / Re: Golf Tournament!!
« Last post by Casey W Little on July 12, 2011, 05:24:31 PM »
Ok, so those of you (One of which was ME) that voted 2-5 win! LOL!
I lost 4 balls yesterday, although ONE COULD have been recovered with a four-wheeler and a little more time than we had on our hands!


Anyway, it was a nice tournament.

P.S. WhoEVER voted MORE THAN 15...Well, I SHALL find out who you ARE!!!
General Discussion / Golf Tournament!!
« Last post by Mathew Samuel on July 08, 2011, 08:30:28 AM »
How many balls will Casey loose at Monday's Golf Tournament?
General Discussion / Hello Everyone! Please Register!
« Last post by Casey W Little on July 07, 2011, 06:22:36 PM »
When you have registered, you will only be allowed to view posts in the public area. You will be manually assigned to a member group which will give you permissions to perform normal forum activities.

If you haven't been assigned a member group within a day or two, send me a WTH email and I'll get it done! Thanks, and enjoy!
General Discussion / Welcome to SMF!
« Last post by Simple Machines on June 21, 2011, 10:30:42 PM »
Welcome to Simple Machines Forum!

We hope you enjoy using your forum.  If you have any problems, please feel free to ask us for assistance.

Simple Machines
Pages: [1] 2 3