A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

removing alpha



 
 
Thread Tools Display Modes
  #21  
Old June 4th, 2007, 08:31 PM posted to microsoft.public.excel.misc
Ron Rosenfeld
external usenet poster
 
Posts: 3,719
Default removing alpha

On Mon, 04 Jun 2007 11:38:13 -0700, Gord Dibben gorddibbATshawDOTca wrote:

Thanks Ron

I just keep learning.


Gord



Me too!
--ron
  #22  
Old June 4th, 2007, 08:34 PM posted to microsoft.public.excel.misc
Ron Rosenfeld
external usenet poster
 
Posts: 3,719
Default removing alpha

On Mon, 4 Jun 2007 14:35:09 -0400, "Rick Rothstein \(MVP - VB\)"
wrote:

True, you could incorporate the reference that way, but I don't think that
changes the way the compiled version of VB handles calls to the script
engine... I think it still temporarily "drops out" of the compiled code to
interface with the script engine... that action, and the interaction to pass
values back and forth, is what I think slows down the compiled program when
it uses scripts. VBA, not being compiled, does not appear to have this
problem; or, if it does, its impact is less noticeable than in compiled VB.
Of course, with a regular expression engine, the time saved by the regular
expression parsing may offset the script interaction slowness; but as a
rule, compiled VB'ers tend to stay away from scripts.

Rick


Well, I have no experience with compiled VB, only VBA.

Programming is a hobby with me -- not a vocation. I have a familiarity with
BASIC (I was a student at Dartmouth when it was being developed); Pascal, JCL,
Assembly language and now VBA. This familiarity was provoked by various needs
at the times.
--ron
  #23  
Old June 4th, 2007, 08:51 PM posted to microsoft.public.excel.misc
Rick Rothstein \(MVP - VB\)
external usenet poster
 
Posts: 1,319
Default removing alpha

Well, I have no experience with compiled VB, only VBA.

And my experience with VBA is quite limited (as I am sure you have deduced
from some of my postingsg).


Programming is a hobby with me -- not a vocation.


Same here. I started on a Texas Instrument 99/4 back in 1981 and have been
hooked on programming ever since. As for professionally, I was a Civil
Engineer (Road Design; retired now) for the first half of my career and fell
into "professional" (I use that term very loosely) programming when I
started developing "helper" programs to simplify some of the more routine,
but lengthy, processes we engineers were required to follow. Eventually, I
joined the CADD development group (covering the second half of my career)
when it was formed and, as part of the work I did there, created "helper"
programs for that venue. I am completely self-taught, which will explain
some of the large gaps in my programming knowledge; still, I am able to
wrestle a program into shape when needed.


I have a familiarity with BASIC (I was a student at Dartmouth
when it was being developed); Pascal, JCL, Assembly language
and now VBA.


You sound like you may be older than I am (I am on the young side of 60).
With me it was mostly BASIC and VB, but I have also worked with FORTRAN,
C/C++ and various Unix scripting languages.


This familiarity was provoked by various needs at the times.


Ditto.


Rick

  #24  
Old June 5th, 2007, 01:06 PM posted to microsoft.public.excel.misc
Ron Rosenfeld
external usenet poster
 
Posts: 3,719
Default removing alpha

On Mon, 4 Jun 2007 15:51:34 -0400, "Rick Rothstein \(MVP - VB\)"
wrote:

You sound like you may be older than I am (I am on the young side of 60).
With me it was mostly BASIC and VB, but I have also worked with FORTRAN,
C/C++ and various Unix scripting languages.


Well, I'm pushing 60, too. But from the high side. Almost ready for Medicare.
Someone has written that this sort of activity keeps the brain "young". Use it
or lose it, I guess.

Best,
--ron
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 01:07 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.