LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 516
Default Programming Function

I'm attempting to program a new function that includes other functions
provided by Bloomberg professional service. The end result needs to look
like this:

BDP("AUD Curncy","LAST_PRICE")

The AUD Curncy is Bloomberg's security code, which I will be getting from
two separate cells. I am able to put the two cells together as follows:

BBCODE = AUD
BBKEY = Curncy
FULLBBCODE = BBCODE & BBKEY

My problem is that I need to get quotation marks around the FULLBBCODE in
the VBA code. When I've tried """ & FULLBBCODE &""" it just returns that
exact text, not what FULLBBCODE represents. Hope I've explained this enough,
any help would be greatly appreciated.
 
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
Programming or Function? jweasl Excel Discussion (Misc queries) 7 November 16th 06 04:32 AM
WORKSHEET FUNCTION or PROGRAMMING. rml Excel Worksheet Functions 8 November 11th 06 08:55 PM
Programming a Function in VB kdp Excel Discussion (Misc queries) 0 November 30th 05 09:10 PM
VBA programming-autofilter function ylchuah Excel Programming 1 July 19th 05 03:34 AM
Function tool or programming...Help please! Sukismomma Excel Programming 5 January 28th 05 12:05 PM


All times are GMT +1. The time now is 02:46 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"