Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Help writing string with commas and quotations VBScript

Status
Not open for further replies.

jcb0806

MIS
Oct 20, 2017
2
0
0
US
I am trying to write the below line to a string without causing line breaks in CSV. Can any one help. I've tried enclosing with quotations as recommended but no luck.

=BDP("FMDG EQUITY","CUST_TRR_RETURN_HOLDING_PER","CUST_TRR_START_DT=20170901","CUST_TRR_END_DT=20170930")
 
You don't show any code I will just take a guess:
[tt]"=BDP(""FMDG EQUITY"",""CUST_TRR_RETURN_HOLDING_PER"",""CUST_TRR_START_DT=20170901"",""CUST_TRR_END_DT=20170930"")"[/tt]

Also, if this is VBA, that forum is here: forum707
 
Thanks, its vbscript. I got it to work.

I used:

"""=BDP(""""FMDG EQUITY"""",""""CUST_TRR_RETURN_HOLDING_PER"""",""""CUST_TRR_START_DT=20170901"""",""""CUST_TRR_END_DT=20170930"""")
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top