I try to connect to the Web Service of the AEAT (SII) to send XML files.
I have a tremendous amount of research and testing, but I am very close to abandonment, or postpone it until there is more information on the net.
For sending, I am tryi...
I have an Excel with a UserForm , from which using a CommandButton I open another Excel file by:
Workbooks.Open Filename:= "XXXX.xlsx"
The book opens it to me well, but I can not edit it and the most serious thing, I can not ev...
Des of VBA I execute a bat using Call Shell (...) and it works correctly.
Now I need to pick up the answer of this bat, which has an "Echo answer".
Any ideas on how to do this?
Thank you,
I want to copy data that I have in a csv to an excel using vba. I have the code that does it, but I do not want to copy the first row of the csv and I do not know how to do it.
This is my csv:
And this is my vba code of an excel:
Priv...
I have a problem when coding with Private Sub Worksheet_Change(ByVal Target As Range)
Because there are so many cells that make changes and that in turn are triggers of each other, that the time has come when excel tells me "the pro...
How to give a function to execute a button in excel, the excel button is a drop-down list button, so I want to execute an action, the action I want to give me is that I see a box to complete in which I already have the macro for it, what I do no...
I have the error 91 in VBA with the following code:
Dim i, c, b, a,
With wsMissingSCM2.ListObjects("tblReportData2")
.TableStyle = "TableStyleLight6"
'
' LocationColumn
'
i = 1
.ListColumns(i).DataBodyRange.Hor...
Dear good afternoon, I would like to know if there is a form or method either by VBA or other means by which at a certain time Outlook automatically opens a new mailing sheet and that this process is automatically and consecutively.
that is,...
When I run the next Code it triggers an alert that says Error '70', but when I run it Step by Step It works Perfectly !!!!
Sub Arribos ()
Dim IE As Object
Dim objElement As Object
Dim objCollection As Object
Dim i As Integer
Dim j As Double...
I have the following line of code:
columna_inicio = Range("4:4").Find(fecha).Column
The problem is that if date does not exist, the program releases an error.
How can I handle this?
I tried using the Try Catch but I can not get it to...