View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Torben Laursen Torben Laursen is offline
external usenet poster
 
Posts: 12
Default How to insert: " into a string

Hi Tom and Dana

Thanks but I must be very slow <g
What I want is to insert quotes around the string FileName in the code
below;
I don't see how I can do that using double quotes

FileName = Application.GetOpenFilename("VLXE Files (*.XML), *.XML")
If FileName < False Then
str = "=VLXE_WriteFileIntoDll(" & FileName & ")"
ActiveCell.Offset(rowOffset:=0, columnOffset:=0).Value = str
end if

Thanks
Torben Laursen



How do I insert a: " into a VBA string?

Thanks
Torben Laursen



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.786 / Virus Database: 532 - Release Date: 29/10/2004




---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.786 / Virus Database: 532 - Release Date: 29/10/2004