String Quotes Messing Me Up/How to Pass Variable Through a String

[rdsmit1]

This is a simplified version of what I'm attempting:

Dim InventoryName As String
Dim temp As String
temp = yesssss
InventoryName = "temp"

Print #1, " <Part Name=""" & InventoryName & """

When using the above code the word temp is passed into the InventoryName field, but what I really want it to say is yesssss. I can't figure out how to make that happen, which I believe requires getting around the usage of the quotation in line 4 of the code. When I just remove those quotes nothing gets passed to the last line of the code for the InventoryName.... head banger! please help.

 

[BarryL]

temp = "yesssss"
InventoryName= temp

 

[rdsmit1]

The problem is that the yessss is actually going to be plucked from a file name so I won't be able to make that change. thanks though, anymore ideas?

 

[WUDA1]

Why not just set the yesssss as the file string?

Edit: is the yessss a file string, like "blah\blah\blah.xls" or something like a title, "Hours Sheet"

 

[rdsmit1]

There's a good reason I can't do that. too long to explain.

 

[Rick Rothstein]

This is a simplified version of what I'm attempting: Dim InventoryName As String Dim temp As String temp = yesssss InventoryName = "temp" Print #1, " <Part Name=""" & InventoryName & """When using the above code the word temp is passed into the InventoryName field, but what I really want it to say is yesssss. I can't figure out how to make that happen, which I believe requires getting around the usage of the quotation in line 4 of the code. When I just remove those quotes nothing gets passed to the last line of the code for the InventoryName.... head banger! please help.

You have too many quote marks...

Print #1, " < Part Name=" & InventoryName

Note: Remove the space that I inserted after the less than symbol (it prevents this forum's display processor from assuming it is the beginning of an HTML tag.

 

[WUDA1]

The only thing I can think of is doing something like this (although I don't know why you just don't cut out the temp part of the code):

[COLOR=#333333]Dim InventoryName As String[/COLOR]
[COLOR=#333333]Dim temp As String
Dim yesssss as String

[/COLOR]yesssss = INSERTCODEHERE to pull the string you want
[COLOR=#333333]temp = yesssss[/COLOR]
[COLOR=#333333]InventoryName = temp

[/COLOR]