Bob answered you literal request, but to illustrate:

lpStr = Activeworkbook.Name
? lpStr
Book1
? workbooks(lpstr).Name
Book1
? workbooks(chr(34) & lpstr & chr(34)).Name

the last command gives an error because there is no workbook named "Book1"

--
Rgards,
Tom Ogilvy


"Bob Phillips" wrote in message
...
Greg,

Try

x = Chr(34) & CStr(Lpfilename) & Chr(34)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Greg85374 " wrote in message
...
Thanks for the reply....the problem with putting quotes in the string i
was too vague about...

ie..you put...
sStr = "The name of the book, ""The House on the Hill,"" was visible to
all"...


put suppose its a variable im calling on

ie...LpFileName....suppose ive an instance where it store the path of a
file...how would i pute quotes around the output of the string ie....

LpFileName = app.path & range("f7")

now i want to call it
x = str(LpfileName)
now I WANT x to be "c:\whatever,1-2-04"
but it comes out as c:\whatever,1-2-04
without the quotes


---
Message posted from http://www.ExcelForum.com/