I'm trying to save an Excel spreadsheet created with VBA as a text file within the code, but I am running into problems with
nested quotations. Currently, my code looks like this:
Filename = " File =" & """d:/tickers/news_tickers/weather""" & ""
Sheets("Sheet2").Cells(Cell,1) = Filename
If you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines
When this is saved in the excel cell it looks exactly as needed with quotes around the file path and one, but when I
use SaveAs to put this into a txet file all of the quotation marks show up. I need to have this line show up as:
in the text file so that it may be used in another program.
Any help would be greatly apprieciated,