Excel " symbol in a text string
Posted on 2013-01-14
I am creating a VBA to open multiole CSV files and process the contents.
I am using excel to generate the VBA code then pasting it into excel's VBA
I'm running into problems with the " symbol
I need to be able to enter this text field:
However, I'd like to be able to have a column of numbers: 1,2,3,4...etc and use
="Workbooks.OpenText Filename:="X:\Projects\Data\" & format(A1,"00") & ".txt"
However, the " symbol in the string prevents this from working.
I can use @ instead of "
="Workbooks.OpenText Filename:=@X:\Projects\Data\" & format(A1,"00") & ".txt@"
Then use a text editor to replace @ with " but I'd like a more elegant solution as this will be used to add ~ ½ million data points.