How to pass CRLF to Excel in VBA

[BikeBoy20032004]

I'd like to code my GRANT EXECUTE statements in Excel, like if I have a sql stored procedure called myProc in Excel A1 field, this is the formula I'd type in B1:

="grant execute to " & A1 & CHAR(10) & " go"

But the result contains quotes, like this:

"grant execute to myProc
go"

How can I get rid of these quotes?

Thanks!

 

[SkipVought]

Hi,

The only way to get
[tt]
"grant execute to myProc
go"
[/tt]
is
[tt]
="""grant execute to " & A1 & CHAR(10) & " go"""
[/tt]


Skip,

_{[red]Be Advised![/red]
The band of elderly oriental musicians, known as Ground Cover, is, in reality...
Asian Jasmine!}

 

[BikeBoy20032004]

SkipVought,

Thank for the reply. My point is I don't want the qoutes at all. I want the expression to appear as:

grant execute to MyProc
go

But when my formula is ="grant execute to " & A1 & CHAR(10) & " go" it appears fine in Excel, but when I copy/paste it it has quotes, like this:

"grant execute to MyProc
go"

 

[SkipVought]

And my point was that it takes special effort to DISPLAY quotes.
[tt]
="grant execute to " & A1 & CHAR(10) & " go"
[/tt]
displays NO QUOTES.

Skip,

_{[red]Be Advised![/red]
The band of elderly oriental musicians, known as Ground Cover, is, in reality...
Asian Jasmine!}

 

[BikeBoy20032004]

That's correct, it DOES take special effort to display quotes. I don't want to display them. Not only do I not want to display them, but when I copy thje result of the formula from Excel to notepad, I don't want to see the quotes.

My problem is that when the formula is as:
="grant execute to " & A1 & CHAR(10) & " go"

The pasted result DOES display quotes. Try it and see, pasted result looks like:

"grant execute to MyProc
go"


Maybe this has to do with my Excel settings? I want the pasted result to be as:

grant execute to MyProc
go

Thanks

 

[BenRowe]

I got the same results using Notepad, however, if I used Wordpad, it works fine. Just be sure to save your Wordpad file as txt.

 

[SkipVought]

Who said ANYTHING about pasteing into Notepad or Wordpad.

The question was about Excel.

Paste or Paste Special - Values, results in NO QUOTES.

I simply do not understand the dilema!

Skip,

_{[red]Be Advised![/red]
The band of elderly oriental musicians, known as Ground Cover, is, in reality...
Asian Jasmine!}