Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,514
Default Quote constant?

On Sat, 13 Apr 2013 16:41:32 -0400, GS wrote:

But that defeats the whole purpose of using constants. Walter's
version...

Const vbQuote As String = """"


I agree! My reply was only to suggest a way to use Chr(34), which
she stated she wanted some way to do that.

Personally, I'd just use the keyboard in most cases, but I do see a
value in storing this in a variable/constant when passing double
quotes as an arg or when filtering...



Could it have to do with touch screen interface considerations?


Doubtful!<g
Which is easier typing...

""""

...to get "

OR

vbQuote

...when string building needs internal quotes within the string?

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Quote Ammendments Dude3966 Excel Discussion (Misc queries) 1 March 4th 08 05:31 PM
Constant loan payments vs. constant payments of principal lalli945 Excel Worksheet Functions 3 December 20th 06 10:33 PM
We are looking for a quote log. Mitch Excel Discussion (Misc queries) 5 April 30th 05 05:22 AM
Typing a quote character Vs pasting a quote character= what happens to the resulting CSV? Interesting!! Tom Ogilvy Excel Programming 0 August 3rd 03 02:53 AM
Typing a quote character Vs pasting a quote character= whathappens to the resulting CSV? Interesting!! Jon Peltier[_3_] Excel Programming 0 August 3rd 03 02:22 AM


All times are GMT +1. The time now is 11:29 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"