I am converting a proprietary program that belongs to our company to excel. Most of the work is done but a portion of it requires me to output a large number of concatenated strings with many double quotation marks and variables. What i am looking for is an application or plug-in of some sort that does that same as this but for excel 2007.

example of code line from previous program:

@IFDEF EmitCSV @EMITTOFILE IO_#PlcName.csv "#Alarm_Tag\State_Addr1","#Item_Addr1",Word,1,RO,100,,,,,,,,,,"",

@ means it is a function
# means it is a variable to be expanded

VBA equivalent:

Please Login or Register  to view this content.
the VBA Function FormatSTR simply adds preceding 0
if in the above example BP_ADDR were to equal "103" then Item_Addr1 would equal "00103"

EmitToFile(File Name, String to append)

I can do the conversion to a VBA string by hand but it is very time consuming considering i have over 1000 different lines like this to convert.

Any help would be greatly appreciated.