Re: Could MVP's please review these Instructions

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Bob Phillips (bob.phillips_at_notheretiscali.co.uk)
Date: 02/29/04 

Date: Sun, 29 Feb 2004 15:00:55 -0000

> "Dave Peterson" <ec35720@msn.com> wrote in message
news:4041EAF7.4942EAD2@msn.com...
> Just some thoughts that you can ignore.
>
> Too many words!
>
> I've found that the longer the instructions, the more they're ignored.
>
> Put your instructions in MSWord, add some screen prints and add some white
space
> to make it easier to read.

Good stuff, someone actually addressing the OP's origiunal question - we had
all forgotten.

>
> And maybe you could modify your code so that instead of using references,
you
> could use late binding.
>
> Do all your developing with the references so you can get the VBE's nice
> intellisense, but before you release it, change your declarations to a
more
> generic "as object".
>
> And change all the constants to their actual values:

A different suggestion, declare all Excel/App/VBA constants (such as
vbReadOnly, xlHidden) as constants in your code, and then you can leave that
bit of code alone, still referencing through a constant. Like this

Const olBCC As Long = 3
Sub Macro1()
Dim olApp As Object

    Set olApp = CreateObject("Outlook.Application")
    Debug.Print olBCC
End Sub

Relevant Pages

  • Re: error 5004.183
    ... A search on google turns up nothing except a thread from an Italian ... newsgroup that references a VB runtime error with Norton Internet Security ... "VB runtime" is a reference to a common set of ... Programs access these instructions to ...
    (microsoft.public.windowsxp.accessibility)
  • RE: Highly used programs: any better replacements out there?
    ... > data typically have more references than instructions do, ... > references are more likely to be unrelated to each other. ... to each literal that would be altered by the proposed zap. ... For IBM-MAIN subscribe / signoff / archive access instructions, ...
    (bit.listserv.ibm-main)
  • Re: Mainframe Assembler Coding Contest
    ... For at least the past few generations of mainframe processors, "storage ... references" have been pretty much the most "costly" kind of operation. ... in various stages of execution all at the same time. ... appearance that several instructions have executed in a single machine ...
    (bit.listserv.ibm-main)
  • Re: 10 rules for benchmarking (was Re: Teaching new tricks to an old dog (C++ -->Ada))
    ... references, e.g. formal economic, or organisational. ... Some people do know how to write a benchmark, ... instructions to a specific computing machine. ... So combining "human user interface" and "not just ...
    (comp.lang.ada)
  • Re: active sync
    ... You can use this as another point of references: ... > Have a look in our Bluetooth Guides. ... We have these instructions there in ... >> the xp wizards for network connections and suddenly I am able to surf the ...
    (microsoft.public.pocketpc)