I have a problem with my application, below:
In my excel I have a sheet called parameters, in it I have two columns, where column A is the name of the parameter and column B is the value of the parameter.
I created a method called Busc...
Good afternoon,
I need to access a website and grab the data from the last day and copy them to a folder in excel, the site is highlighted in the macro below but I do not know how to proceed to select the data and copy them in my worksheet ....
When I'm running a VBA macro, eventually the code is interrupted, as if there were breakpoints.
The message displayed is:
The code execution has been stopped.
If you accept the message and continue running the code, the behavior rep...
I'm trying to copy a record from the table to a new record by changing some fields, but it still has an error and I can not find it, you can see where I made the mistake,
Dim strQtde As Integer, I As Byte
On Error GoTo Erro
If MsgBox("C...
I'm having trouble putting together a VBA program that does a google search.
I can not understand the HTML part.
The idea is to identify the open internet explorer, go to the google page and search for the word "test" in the search.
Follow...
I have a database composed of two vectors: u=(a,b,c) and v=(1,2,3)
In another worksheet, I have two blank vectors x and y . I need to complete the input of x (from u ), the code returns the corresponding e...
I have a question.
I've been testing the macros to populate a database but I'm having a problem.
ID - Name
ZZ1-A
ZZ2-B
How can I add this automatically? (Now ZZ3)
I have the following code that works with just numbers. I have trie...
I need to copy a graphic and paste it as an image on the same worksheet.
I'm trying to select the range that contemplates any special graphics and paste as a Bitmap or Enchanced file. Here is the code:
Range("AM18:BE22").Select
Selection...
Sorry if this question is repeated. I always try to get the answer before asking here, and this time I did not find it (suddenly I did not use the correct key words, maybe for lack of knowledge, but whatever).
CONTEXT
I work in a company...
In the text below, I would like a regular expression pattern, compatible with VBA, to extract the text located between the equal sign "=" and the first line break (highlighted in bold):
Home
Customer = WITH ABCD CLIENT
R $ 0 - (0.00%) - Max....