Search results

  1. S

    ThisWorkbook.Path / PathToFile

    I am currently trying to make work some of codes, which work fine in standart excel. According to instruction: 12.17 Why is ThisWorkbook.Path not working? I apply this code: Dim XLSPadlock As Object On Error GoTo Err Set XLSPadlock = Application.COMAddIns("GXLSForm.GXLSFormula").Object...
  2. S

    VBA not working in .exe format

    The following code works in regular excel file, but in converted .exe file not working: Sub PASTEIT() On Error Resume Next Range("A" & Rows.Count).End(xlUp).Offset(1, 0).Activate ActiveWindow.ActivateNext Selection.Copy ThisWorkbook.Activate ActiveCell.PasteSpecial Paste:=xlPasteValues...
Back
Top