SendKeys Compile Error

[jagrenet]

Hello,

I am attempting to use SendKeys in vba to "send" Enter to a Word doc. I keep getting a Compile error even after the variable is declared.
This code already lives inside a working Sub Routine, just want to "add" this function.

Dim SndEnter As Variant

Set SndEnter = Application.SendKeys("{ENTER}", True)

With
(working Application.Selection code

SndEnter
End With

"Compile Error - Expected Function or variable "

Not sure why this error is coming up.
Any ideas ??

Thanks in advance

 

[Tetra201]

First of all, this is not an Excel forum question, so, most likely, the thread will be moved elsewhere.

To select an entire sentence, try

Selection.MoveRight Unit:=wdSentence, Count:=1, Extend:=wdExtend

You may want to set the Extend parameter to wdMove instead -- if you just need to move the cursor.

 

[jagrenet]

First of all, this is not an Excel forum question, so, most likely, the thread will be moved elsewhere.

To select an entire sentence, try

Selection.MoveRight Unit:=wdSentence, Count:=1, Extend:=wdExtend

You may want to set the Extend parameter to wdMove instead -- if you just need to move the cursor.

I have all of these procedures being performed from an Excel VBA Module which, is why I came here for help. I now have A huge gap from the beginning of the sentence to the last 4 words of the sentence. I am able to highlight ("Select") the 4 words using
.Next(Unit:=wdWord, Count:=13).Select ..... Then I have
.StartOf Unit:=wdParagraph, Extend:=wdMove ....... But the selection does not move and stays centered in the page. That's why I asked about potentially using "Justify". However, Justify does not appear as a method. I also tried "TypeBackSpace" but that did not work either.

 

[jagrenet]

First of all, this is not an Excel forum question, so, most likely, the thread will be moved elsewhere.

To select an entire sentence, try

Selection.MoveRight Unit:=wdSentence, Count:=1, Extend:=wdExtend

You may want to set the Extend parameter to wdMove instead -- if you just need to move the cursor.

Thank you for guiding me in the right direction. I FINALLY found the Format Method which permitted me to set the Selected text all the way to the Left, as it should be. ".Paragraphs.Format.Alignment = wdAlignParagraphLeft" -

 

[jagrenet]

I can't believe you would need Sendkeys for this at all. I would think you would simply add a carriage return (or similar, Word not being my thing) to the document text.

I don't like using SendKeys at all but, at that particular point in time, that's all I had to reference. Thank you for jumping in to help out. I surely do appreciate your efforts !!