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:
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.
Bookmarks