Guys,

I am using WriteLine function to write lines to a text file. Here's the
format of the line:

$insert_physical_layer(<layer_order, €œ<physical_layer_name€�,
€œ<logical_layer_name€�, €œ€�);

Above, both physical_layer_name and logical_layer_name will be substituted
with values from arrays i.e. everything else is a constant.

Here's what I have so far for the WriteLine code:

objStackupFile.WriteLine("$insert_physical_layer(< layers_counter,"<layers(layers_counter, 1)","<layers(layers_counter, 2)", "");")

Above line does not work...has to do with wanted or unwanted double quotes
and/or more objects. Can you please tell me what the writeline should look
like?

Thanks for help.

Try these changes. for a double quote to show in the out put you need to put
two in a row. Also I'm assuming that you have the variables layers_counter
and an array layers(X,2). The variables need to be seperate from the rest of
the string like I did below. I also added a message box so you can see the
results. if you can't read the entire string then put the string on a
worksheet like this

Range("A1") = WriteData

Here are the changes

WriteData = "$insert_physical_layer(<" & layers_counter & "," & _
"""<" & layers(layers_counter, 1) & """," & _
"""<" & layers(layers_counter, 2) & ", "");"
MsgBox (WriteData)
objStackupFile.WriteLine (WriteData)

"Varun" wrote:

Guys,

I am using WriteLine function to write lines to a text file. Here's the
format of the line:

$insert_physical_layer(<layer_order, €œ<physical_layer_name€�,
€œ<logical_layer_name€�, €œ€�);

Above, both physical_layer_name and logical_layer_name will be substituted
with values from arrays i.e. everything else is a constant.

Here's what I have so far for the WriteLine code:

objStackupFile.WriteLine("$insert_physical_layer(< layers_counter,"<layers(layers_counter, 1)","<layers(layers_counter, 2)", "");")

Above line does not work...has to do with wanted or unwanted double quotes
and/or more objects. Can you please tell me what the writeline should look
like?

Thanks for help.

Wherever you want a literal " character to appear in the string, use a
pair of " characters. E.g.,

S = "This has a ""quoted"" word."

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)

On Mon, 23 Mar 2009 14:24:01 -0700, Varun
wrote:

Guys,

I am using WriteLine function to write lines to a text file. Here's the
format of the line:

$insert_physical_layer(<layer_order, “<physical_layer_name”,
“<logical_layer_name”, “”);

Above, both physical_layer_name and logical_layer_name will be substituted
with values from arrays i.e. everything else is a constant.

Here's what I have so far for the WriteLine code:

objStackupFile.WriteLine("$insert_physical_layer( <layers_counter,"<layers(layers_counter, 1)","<layers(layers_counter, 2)", "");")

Above line does not work...has to do with wanted or unwanted double quotes
and/or more objects. Can you please tell me what the writeline should look
like?

Thanks for help.