Questions tagged as 'vba'

Tagged questions
1
answer

C # InteropServices and Visual Basic 6.0 error reference error

I made a dll in C # for use with Visual Basic 6. When I create the reference in vb6 VB6 I get the following error:    Error 91: Object variable or With block variable not set I have tried it in several ways but it always gives me the same...
asked by 03.02.2018 / 18:34
0
answers

C ++ Map as function output in VBA

I have a C ++ code that returns a map to me. I have created a dll and I call it from an Excel macro. Then, in that macro, I need a dictionary (Scripting.Dictionary) . I tried to do the following: Declare Function ExlFunct Lib "dire...
asked by 26.04.2017 / 14:10
1
answer

How to execute a loading bar when a macro is running? [closed]

I have a book
asked by 14.06.2016 / 06:05
2
answers

Error: VBA types do not match

I'm doing a macro that compares two columns at the same time to perform an operation, column A is of type Integer and column C is of type Date, the problem is that when closing the cycle it throws me the error of <Se ha producido el error...
asked by 08.11.2017 / 05:47
2
answers

For loop that does not run without giving any error too

I've done a test with this Sub but when I compile, it does not do anything. Also, it does not give any errors. Then I do not know how to compile it. Can you help me? Public Sub calculerScore() Dim colonne, ligne, ligne_referencej, colonne_...
asked by 04.01.2017 / 18:51
1
answer

VBA Select html element by classe

I need to access the value of an input and click on another with an Excel macro and I need to select the inputs through its class, since they do not have an id. I've seen googling that the .getElementByClassName () method exists, but there's no...
asked by 20.04.2018 / 22:47
1
answer

Date operations in Excel VBA

I was asked to perform a macro in VBA and I am having a problem that I have to perform an operation with dates, I recover the date in the format "hh, mm" [15:59 ] and trying to make a subtraction between two dates generates an error 13, that t...
asked by 14.09.2017 / 16:28
1
answer

Migrate MSSOAP.SoapClient30 from VB to c #

The issue is that I'm migrating a project from VBA to C #, and along the way I found: Set SoapClient = CreateObject("MSSOAP.SoapClient30") 'Objeto Web Service Soap SoapClient.ClientProperty("ServerHTTPRequest") = True so I started t...
asked by 30.10.2018 / 16:45
1
answer

How to find data and export it to another excel sheet

I am currently working on a code which should: Read the item that the user selects from a Combobox, for example: Go to a page called "MEMORIES ACT" and search for this item, in the columns "CJ" and "CK" (it is done in these 2 c...
asked by 27.07.2018 / 18:29
1
answer

Validate if you find an attachment VBA macro gmail

I have this macro that sends several emails at the same time with different attachments to X number of previously specified emails. Always the emails must have an attachment (this is the reason for the email), I am trying that when I do not f...
asked by 26.07.2017 / 17:15