Questions tagged as 'vba'

Tagged questions
0
answers

How to capture text from a textarea in vba?

I'm maintaining a program that maps a site through ids, updated the site and I'm changing the ids, but I got a part that has a textarea and I have to get the information that is inside it, and I do not know how do that. the part of the code is t...
asked by 08.11.2018 / 13:56
1
answer

Copy rows and paste based on a value in an excel cell

I would like to know how I can copy a set of lines. For example, line 1 through 5 and paste in lines 10 through 15. This action would be done with value 1 on another sheet and in cell A1. I have a button with VBA to do this, but I wanted to d...
asked by 01.11.2018 / 17:30
2
answers

Add paragraph in vba

I have several cells that I want to concatenate to send an email through excel It turns out that every cell I would like to have line breaks but I am not able to I have already used WrapText and Chr () but it is not working, can someone he...
asked by 26.10.2018 / 14:00
1
answer

Rename attachments before saving

Gentlemen, I have the following problem. Every Monday, I receive a system of 12 emails, which are: SIXTH: MIPS_1 MIPS_2 MIPS_3 MIPS_4 SATURDAY: MIPS_1 MIPS_2 MIPS_3 MIPS_4 SUNDAY: MIPS_1 MIPS_2 MIPS_3 MIPS_...
asked by 23.10.2018 / 15:04
0
answers

ReadyState wrong!

I'm trying to use a macro to download a spreadsheet on a system. However from ReadyState < > 4 the code no longer works. Sub FazerLoginSite() Dim i As Long Dim IE As Object Dim objElement As Object Dim Element As Object Dim objCol...
asked by 18.10.2018 / 15:35
1
answer

Sleep function or Wait locking worksheet in Excel

I'm programming a macro in vba, which makes the connection to a sql server database and makes a select in a table and returns me the time of the last change in the database. I created a program in vba that takes the system time and makes a calcu...
asked by 17.10.2018 / 22:04
1
answer

VBA to send email

I have a VBA code to send a range as an image, through outlook. But it does not always paste the image into the email body, but rather a part of the spreadsheet. Is there something wrong with the code? Thank you Sub EnviarEmail() Dim outApp...
asked by 18.10.2018 / 22:11
1
answer

Save php parameter in vba variable

I have form that I pass one parameter and at the same time opens an Excel worksheet.  Here's an example: <?php if (isset($_GET["param"]) && !empty($_GET["param"])) { $param = $_GET["param"]; exec("START teste.xlsx $...
asked by 15.10.2018 / 23:05
1
answer

I have a password in excel and I want to change it in vba

If Me.boxPassword.Value = "12345" Then Unload Me Sheets("Configuração").Visible = True Sheets("Configuração").Select Else Me.Hide Retry = MsgBox("Passe incorreta, Tentar outra vez?", vbYesNo, "Retry?") Select Case Retry...
asked by 22.10.2018 / 17:24
1
answer

Use VBA to delete rows with criteria determined by a cell

I need a Vba to do the following action: As soon as it is activated, read a specific cell and erase lines from another flap taking into account the specific cell as a criterion. Example: In Sheet1 I have two products: Blue Shirt A Blue Shirt...
asked by 19.10.2018 / 21:36