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.
code line from previous program:
@IFDEF EmitCSV @EMITTOFILE IO_#PlcName.csv
@ means it is a
# means it is a variable to be expanded
If EmitCSV = True Then Call EmitToFile("IO_" & PLCName & ".csv", Chr$(34) & Alarm_Tag &
"BP_ADDR" & Chr$(34) & "," & Chr$(34) & Item_Addr1 & Chr$(34) &
",Word,1,R/W,100,,,,,,,,,," & Chr$(34) & Chr$(34) & ",")
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