I have several lines of VB that I have in Excel that I am concantanting
and then wanting to drop into the VB editor. When I do this, Excel is
adding a " to the front and back of the code, why?
Example:
Cell A1 = Workbooks.Open Filename:= _
Cell A2 = C:\Documents and Settings\Richard Sabbara\My
Documents\Budget20060730.xls
Cell A3 = A1&CHAR(10)&A2
The result in A3 is:
"Workbooks.Open Filename:= _
C:\Documents and Settings\Richard Sabbara\My
Documents\Budget20060730.xls"
This becomes an even bigger issue for me when I am trying to build this
out using cell references, b/c it will add extra " to the cell
refrences as well. It might just be that Excel is not the program for
this.
Any suggestions?
Richard
Bookmarks