If True = False Then
-
Seen in a VBA app in lieu of commenting out/deleting 138 lines of junk code. Yes, the VBA editor is a steaming pile of excrement, but any decent text editor will let you insert the ' via a global insert/replace. :((
Today's lesson is brought to you by the word "niggardly". Remember kids, don't attribute to racism what can be explained by Scandinavian language roots. -- Robert Royall
dan neely wrote:
but any decent text editor will let you insert the ' via a global insert/replace.
AFAIK, the VBA editor within any MS Office application does have this feature...
-
dan neely wrote:
but any decent text editor will let you insert the ' via a global insert/replace.
AFAIK, the VBA editor within any MS Office application does have this feature...
-
IF so, could you please tell me where? I can't find it in excel 2k7.
Today's lesson is brought to you by the word "niggardly". Remember kids, don't attribute to racism what can be explained by Scandinavian language roots. -- Robert Royall
Well, I don't use MS Office 2007... :) In 2003 though, it is a button in the "Edit" tool bar (Menu -> View -> Toolbars)
-
Well, I don't use MS Office 2007... :) In 2003 though, it is a button in the "Edit" tool bar (Menu -> View -> Toolbars)
TY. The VBA editor didn't change except that it uses the same theme color as the rest of office in the menu/toolbar backgrounds. All the dividers/headers elsewhere are still win32 gray. The combination is almost WTF enough to make you think no one in MS cares. :rolleyes:
Today's lesson is brought to you by the word "niggardly". Remember kids, don't attribute to racism what can be explained by Scandinavian language roots. -- Robert Royall
-
TY. The VBA editor didn't change except that it uses the same theme color as the rest of office in the menu/toolbar backgrounds. All the dividers/headers elsewhere are still win32 gray. The combination is almost WTF enough to make you think no one in MS cares. :rolleyes:
Today's lesson is brought to you by the word "niggardly". Remember kids, don't attribute to racism what can be explained by Scandinavian language roots. -- Robert Royall
dan neely wrote:
no one in MS cares.
:) That's probably true, given that MS now recommends using VSTO instead of VBA.
-
dan neely wrote:
no one in MS cares.
:) That's probably true, given that MS now recommends using VSTO instead of VBA.
Not to mention office 2k8 (mac version of 2k7) doesn't support VBA at all. To make it perform well on early/mid 90's level hardware the VBA compiler/interpreters were written with large amounts of assembly code for speed so porting the PPC version to x86 wasn't an option, and the PC/mac versions ended up with very different back end connections for what were good reasons at the time; which meant they couldn't port the wintel version over either. Office for mac doesn't sell enough copies to have a very large team (it's fully funded on it's own sales), and the dev team estimated 2 years to rewrite the VBA engine.
Today's lesson is brought to you by the word "niggardly". Remember kids, don't attribute to racism what can be explained by Scandinavian language roots. -- Robert Royall
-
dan neely wrote:
but any decent text editor will let you insert the ' via a global insert/replace.
AFAIK, the VBA editor within any MS Office application does have this feature...
Yes, it does have it. When I have to swallow my pride and do any VBA in Access, the search and replace is there and it is useful.
"The clue train passed his station without stopping." - John Simmons / outlaw programmer "Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon "Not only do you continue to babble nonsense, you can't even correctly remember the nonsense you babbled just minutes ago." - Rob Graham
-
IF so, could you please tell me where? I can't find it in excel 2k7.
Today's lesson is brought to you by the word "niggardly". Remember kids, don't attribute to racism what can be explained by Scandinavian language roots. -- Robert Royall
I cannot find it either. As you have mentioned in the other post, it must be a VSTO thing.
"The clue train passed his station without stopping." - John Simmons / outlaw programmer "Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon "Not only do you continue to babble nonsense, you can't even correctly remember the nonsense you babbled just minutes ago." - Rob Graham
-
dan neely wrote:
can it match on the newline char itself
Not that I've found, I usually resort to opening the file in Word to do that. X|
I'd recommend Notepad++ a free replacement for Notepad, with all those regex goodies you've been missing
-
I cannot find it either. As you have mentioned in the other post, it must be a VSTO thing.
"The clue train passed his station without stopping." - John Simmons / outlaw programmer "Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon "Not only do you continue to babble nonsense, you can't even correctly remember the nonsense you babbled just minutes ago." - Rob Graham
-
dan neely wrote:
any decent text editor
Like Notepad?
:omg: It even forgets CTRL+Z after two usage instances. I would say, WordPad should be safe and reliable though it nags us against saving in plain text formats.
Vasudevan Deepak Kumar Personal Homepage
Tech Gossips
All the world's a stage, And all the men and women merely players. They have their exits and their entrances; And one man in his time plays many parts... --William Shakespeare -
I have no problems at all using GOTO in small sections of code. Beats all that complicated logic and program flow nonsense :)
I still remember having to write your own code in FORTRAN rather than be a cut and paste merchant being pampered by colour coded Intellisense - ahh proper programming - those were the days :)
-
There is a book called "Code Complete", that says that GoTo statements should always be avoided unless you're coding with Fortran
-
There is a book called "Code Complete", that says that GoTo statements should always be avoided unless you're coding with Fortran
Check the sig :) Nothing wrong with GOTO.
I still remember having to write your own code in FORTRAN rather than be a cut and paste merchant being pampered by colour coded Intellisense - ahh proper programming - those were the days :)
-
Check the sig :) Nothing wrong with GOTO.
I still remember having to write your own code in FORTRAN rather than be a cut and paste merchant being pampered by colour coded Intellisense - ahh proper programming - those were the days :)