Send a "Backspace" to word

Jon von der Heyden

MrExcel MVP, Moderator

Joined

Apr 6, 2004

Messages

10,907

Office Version

1. 365

Platform

1. Windows

• Apr 21, 2010

• #2

Perhaps;

Code:

Application.SendKeys "{BS}"

 

Upvote 0

C

counihan3

Active Member

Joined

Mar 9, 2007

Messages

458

• Apr 21, 2010

• #3

There was no luck with that. Here is the code I am using if that will help.

Code:

Sub coverletterbuild()
               
        Set oWord = CreateObject("Word.Application")
        If Err Then
            Set oWord = New Word.Application
            WordWasNotRunning = True
        End If
        
        oWord.Visible = True
        oWord.Activate

            Set oDoc = oWord.Documents.Add("C:\TEST COVER.doc")
            oDoc.Bookmarks("Line99").Range.InsertBefore "This is a test!" & vbNewLine
            oDoc.Bookmarks("LineTEST").Range.InsertBefore "1!" & vbNewLine & "TESTT"
            Application.SendKeys "{BS}"

End Sub

 

Upvote 0

C

counihan3

Active Member

Joined

Mar 9, 2007

Messages

458

• Apr 21, 2010

• #4

Does anyone know if word even recognize the character codes for backspace or delete? I assumed it would since you can use ascii code for special characters but we all know what happens when you assume.

 

Upvote 0

Jaafar Tribak

Well-known Member

Joined

Dec 5, 2002

Messages

9,621

Office Version

1. 2016

Platform

1. Windows

• Apr 21, 2010

• #5

Put this at the bttom of your code and see if it works :

Code:

With oWord.Selection
    .EndKey
    .TypeBackspace
End With

 

Upvote 0

C

counihan3

Active Member

Joined

Mar 9, 2007

Messages

458

• Apr 21, 2010

• #6

That works, but how do i move the courser to work with it.

 

Upvote 0

Jaafar Tribak

Well-known Member

Joined

Dec 5, 2002

Messages

9,621

Office Version

1. 2016

Platform

1. Windows

• Apr 21, 2010

• #7

counihan3 said:

That works, but how do i move the courser to work with it.

Click to expand...

Sorry. How do you mean ?

 

Upvote 0

C

counihan3

Active Member

Joined

Mar 9, 2007

Messages

458

• Apr 21, 2010

• #8

Or change the line it is selecting right now it is not effecting line that i need it to.

 

Upvote 0

C

counihan3

Active Member

Joined

Mar 9, 2007

Messages

458

• Apr 21, 2010

• #9

It just stays at the top of the page. I am not sure how to use the selection part of the code.

 

Upvote 0

Jaafar Tribak

Well-known Member

Joined

Dec 5, 2002

Messages

9,621

Office Version

1. 2016

Platform

1. Windows

• Apr 21, 2010

• #10

counihan3 said:

Or change the line it is selecting right now it is not effecting line that i need it to.

Click to expand...

I see. I am afraid I am not well versed with the Word Object model . Try recording a Macro in word , place the cursor where you want and see if generates some code which you can hopefully adapt.

Edit:
If you don't get the desired answer from someone here I suggest you post your question in this excellent Word Forum.

 

Last edited: Apr 21, 2010

Upvote 0