I would like to name the sheets of Excel with a specific format "name of the day corresponding to the date" and "date entered by the user" , it works for me well the code except for the part of the name of the day, always shows me "Sa...
I need in Excel (vba) to make a macro or robot to enter some data in a web page taking as values a list of data (cedula and date) that I have in an Excel sheet, those parameters I can already pass to the form with this element "IE.Document.getEl...
From the following previous image I want to create a macro that does the following:
What I want is to make a cycle that runs through the rows of my data:
compare row1 of column A with row1 of column G and compare row1 of column B with r...
I'm building a database in Access, and I want to run an update query in vba .
I know the syntax a little bit, but it's giving me a bug.
The problem is that I try to pass some values to him by means of two variables, and it seems that...
I want to do a self-filtering through VBA of a table with multiple columns.
My intention is that it does not filter to infinity, if I do not always have control knowing which is the last record of my table.
My code is the following:
last...
Good day to all the problem that I have is a table with the following info
COMPANY PRODUCTS
AAA A,B,C
BBB A,C,D,F
CCC D
DDD F,G,H,I,J,K,L
and I would like to see if it can be saved with some code in the following way:...
Is there any way that the values of a column can not be copied in excel?
I tried to make the column not selectable and protected it with a password, but you can still copy the values by selecting the columns on the sides.
I think the solut...
I have the following number 34076 which is equivalent to the date 17-04-1993, which function can I use to transform that number to the date indicated, I am working with VBA and that number is retrieved from an excel to a datagridview.
If someone can tell me how to save and close multiple open excel from an excel with macro
Sub SaveAll()
Dim Wkb As Workbook
For Each Wkb In Workbooks
If Not Wkb.ReadOnly And Windows(Wkb.Name).Visible Then
Wkb.Sav...
I do not know why my MsgBox is duplicated twice, it is supposed that when the spaces are blank send a message that they are blank, all this when pressing a radio button, the first time it works, but in the Second, the third one already shows the...