1994-06-01, English, Article, Journal or magazine article edition: Make informed design decisions; knowing when to choose between VBA and VB3 can speed OLE automation in Excel. (OLE Expert) Pleas, Keith

User activity

Share to:
 
Bookmark: http://trove.nla.gov.au/version/110626831
Physical Description
  • program
  • Magazine/​Journal article
Published
  • Fawcette Technical Publications, 1994 June-July
Language
  • English

Edition details

Title
  • Make informed design decisions; knowing when to choose between VBA and VB3 can speed OLE automation in Excel. (OLE Expert)
Also Titled
  • Make informed design decisions; knowing when to choose between VBA and VB3 can speed OLE automation in Excel.
Appears In
  • Visual Basic Programmer's Journal, v4, no.n5, 1994 June-July, p76(3) (ISSN: 1075-1955)
Author
  • Pleas, Keith
Published
  • Fawcette Technical Publications, 1994 June-July
Physical Description
  • program
  • Magazine/​Journal article
Subjects
Target Audience
  • Trade
Summary
  • Developers who understand when to use Microsoft Visual Basic Applications Edition (VBA) and when to use Visual Basic 3.0 (VB3) when developing programs for Excel can improve OLE performance in the spreadsheet program. It is difficult to tell which program should be used because Visual Basic does not have built-in profiling so developers have to time code execution themselves to determine speed. Developers should first avoid the assumption that the design of VBA makes it better than VB3. In some tests, VBA has taken 80% longer to execute specific tasks. Another design technique that can improve performance is minimizing the number of dots, the punctuation that describes object relationships, in the programming code. String-handling code should be developed in VB3 because VBA is slower in this procedure. Developers should also consider using better algorithms in code rather than trying to make small adjustments to the code.
Notes
  • program
Language
  • English
Database
  • Gale General OneFile
Identifier
  • 15575291

Get this edition

Some editions of the publication "Visual Studio magazine" are available from these libraries. The edition containing this article ( v4, n5, 1994 June-July, p76(3) ) may not be available:

  • Set up My libraries

    How do I set up "My libraries"?

    In order to set up a list of libraries that you have access to, you must first login or sign up. Then set up a personal list of libraries from your profile page by clicking on your user name at the top right of any screen.

  • All (5)
  • ACT (1)
  • QLD (2)
  • VIC (2)
None of your libraries hold this item.

These 5 locations in All:

Library Access Call number(s) Formats held Language
Central Queensland University. Rockhampton Campus Library. Open to the public <2334997>; Held Periodical; Journal, magazine, other English
Defence Science and Technology Group. DST Group Research Information Services - Melbourne. Not open to the public Serials; Vol. 11, no. 10; (2001)- Periodical; Journal, magazine, other English
Monash University. Monash University Library. Open to the public 99149982901751; 005.26 V834; v. 11, no. 10 (Sept. 2001) to v. 23, no. 1 (Jan. 2013) ; incomplete; Lacks: v.14, no. 7 (2004) ; v. 14, no. 12 (2004) ; v. 15, no. 14 (2005) ; v. 16, no. 8 to 9 (2006); HA; SER Periodical; Journal, magazine, other English
Parliament of Australia. Parliamentary Library. Not open to the public u111334; held Periodical; Journal, magazine, other English
Queensland University of Technology. Gardens Point Campus Library. Open to the public .b19819250; gper 005.26 69; Vol. 16 (2006)-v.23, no. 1 (Jan. 2013) Periodical; Journal, magazine, other English
Show 0 more libraries...

This single location in Australian Capital Territory:

Library Access Call number(s) Formats held Language
Parliament of Australia. Parliamentary Library. Not open to the public u111334; held Periodical; Journal, magazine, other English
Show 0 more libraries...
None of your libraries hold this item.
None of your libraries hold this item.

These 2 locations in Queensland:

Library Access Call number(s) Formats held Language
Central Queensland University. Rockhampton Campus Library. Open to the public <2334997>; Held Periodical; Journal, magazine, other English
Queensland University of Technology. Gardens Point Campus Library. Open to the public .b19819250; gper 005.26 69; Vol. 16 (2006)-v.23, no. 1 (Jan. 2013) Periodical; Journal, magazine, other English
Show 0 more libraries...
None of your libraries hold this item.
None of your libraries hold this item.

These 2 locations in Victoria:

Library Access Call number(s) Formats held Language
Defence Science and Technology Group. DST Group Research Information Services - Melbourne. Not open to the public Serials; Vol. 11, no. 10; (2001)- Periodical; Journal, magazine, other English
Monash University. Monash University Library. Open to the public 99149982901751; 005.26 V834; v. 11, no. 10 (Sept. 2001) to v. 23, no. 1 (Jan. 2013) ; incomplete; Lacks: v.14, no. 7 (2004) ; v. 14, no. 12 (2004) ; v. 15, no. 14 (2005) ; v. 16, no. 8 to 9 (2006); HA; SER Periodical; Journal, magazine, other English
Show 0 more libraries...
None of your libraries hold this item.

User activity


e.g. test cricket, Perth (WA), "Parkes, Henry"

Separate different tags with a comma. To include a comma in your tag, surround the tag with double quotes.

Be the first to add a tag for this edition

Be the first to add this to a list

Comments and reviews

What are comments? Add a comment

No user comments or reviews for this version

Add a comment