[RESOLVED] Send keys and quotation marks

[Static]

Using Sendkeys is a very unreliable way to do it.

Great thing is, Excel lets you use VBA! (AS u know)

so, that being said u can do this quickly and reliably:

put this code in a module:

Public Sub Replace34(sFilename As String, sReplaceWith As String)
    
    Dim tmp As String
    Open sFilename For Input As #1
        tmp = Input(LOF(1), 1)
    Close #1
    
    tmp = Replace(tmp, Chr(34), sReplaceWith)
    
    Open sFilename For Output As #1
        Print #1, tmp
    Close #1
    
End Sub

now to use it.. call it from somewhere...

Replace34 "C:\path\to\file.txt", "X"

where "X" is what u want to replace the double quotes with
just do "" if u want to remove them

understand?