SendKeys ctrl + s not saving file

62 views Asked by At

I have a problem with SendKeys "^s". If I save my csv file with ActiveWorkbook.Save I'm getting an error with another software that uses this csv file to input data to system. Could someone help me with that?

Sub Copy_selected_to_CIM_Item()
    Workbooks("ITEM.csv").Activate
    Range("A2").PasteSpecial Paste:=xlPasteValues
    Application.CutCopyMode = False
    SendKeys "^s"
End Sub

I was using SendKeys "^s" yesterday and it seemed to work fine but today I'm back on the code and SendKeys "^s" is not doing anything.

0

There are 0 answers