Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA String Output adds Quotes when I cut and paste to Notepad
Hello all,
I have a very frustrating little problem with Excel VBA. I have a function which outputs a lengthly string back to an Excel cell. I need to then cut and paste that cell into Notepad. When I do the cut and paste, it adds quotation marks around the text. I don't see any quotation marks when looking at the cell in excel, nor does a cut and paste into Word add quotation marks, but Notepad and Access do. Any help would be appreciated. Thanks, rfusee |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA String Output adds Quotes when I cut and paste to Notepad
"rfusee" wrote: Hello all, I have a very frustrating little problem with Excel VBA. I have a function which outputs a lengthly string back to an Excel cell. I need to then cut and paste that cell into Notepad. When I do the cut and paste, it adds quotation marks around the text. I don't see any quotation marks when looking at the cell in excel, nor does a cut and paste into Word add quotation marks, but Notepad and Access do. Any help would be appreciated. Thanks, rfusee I should also mention, if I cut and paste from an adjacent cell, which is also just text but NOT text which comes via a VBA function call, there are no quotation marks added when pasting into Notepad. This is why I suspect it to be a VBA specific issue. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Line Feed in Formula Adds Double Quotes? | Excel Worksheet Functions | |||
displaying output of a formula to be in double quotes | Excel Worksheet Functions | |||
Output space-delimited file with quotes around text? | Excel Discussion (Misc queries) | |||
Problem: Copying a cell that contains line breaks adds extra quotes | Excel Discussion (Misc queries) | |||
Output to Notepad | Excel Programming |