I need to record the path of the excel file in a public VBA excel variable. I have a macro that utilises the path several times across various modules. My issue arises when the variable is declared in the Option Explicit Contex.
`Option Explicit Public ruta As String
ruta = ActiveWorkbook.Path
Public Const varRuta = ruta & "\ValidacionesSunat"
Sub EdufarmaEstadoRevisado()
the variables you must use in the code TextFile Should Be A Number I, J, K, L, and M, As Integer String: MyFile Dim Dark Zone Low values The same dim batch Set batchDe10 to Set batchSaldoUnits to
On Error Resume Next Kill varRuta & "." On Error GoTo 0 `