Questions tagged as 'vba'

Tagged questions
1
answer

VBA - Application definition or object definition error

I'm trying to retrieve the amount of rows from an excel worksheet to format it, however I'm encountering the application definition or object definition error. Below is the code snippet. Private Function formataPlanilha(pathWorkbook As String,...
asked by 22.09.2017 / 15:11
1
answer

VBA macro for Exel - copy data from one sheet to another with one condition

Live personal, I am completely new to VBA and programming. I need help to build a macro for Excel. Context: In the Excel workbook that is in the following link, I want to develop a VBA macro that fills in the "transatas", "finished" and "wa...
asked by 18.09.2017 / 15:06
0
answers

VBA Integration with IE, return Value where Value=""

I have a problem with a macro to return the value of a web page, my question is whether the value displayed in the HTML code is always null, but in the answer box it gives me the requested value. Even after performing the search there is no chan...
asked by 27.08.2017 / 21:32
1
answer

AlternativeText of sharpes to save config

wave I would like to know if there is any problem / risk of using the AlternativeText property of sharpes objects to save working parameters is there any risk that these data will be deleted / replaced suddenly by other actions inside the offi...
asked by 18.08.2017 / 12:29
1
answer

Procv Help Copy data

I have a database in which an employee has three or more dependents, when I do a PROCV to pull a dependent one at a time, only the first and last one appears. How do I select the first in a column the second in another column and so on? EX...
asked by 03.08.2017 / 02:03
1
answer

Save IE generated by JavaScript using VBA

I'm using the routine to access a page and download a file, which uses a javascript to be generated, but it needs to be saved automatically, without user intervention. Sub ConnectWeb() Dim ie As InternetExplorer Dim C Dim ULogin As Boolean, ie...
asked by 26.07.2017 / 14:33
0
answers

how to click the "ok" button in an Internet Explorer alert using VBA?

Hello, I have a VBA code that accesses a web page and excludes the registered items. When I click the "delete item" button it will open an alert on the screen with two buttons ( "ok" and "cancel" >) and displaying the message "Confirm d...
asked by 25.07.2017 / 18:57
1
answer

Field of view of surveillance cameras in Excel

Good afternoon Community, I have a question about Excel, in which I do not know if it is possible to make such a request. My goal is to take a plant and through a solver, place surveillance cameras at certain points of the plant to monitor th...
asked by 08.07.2017 / 14:02
0
answers

get value from the excel cell below or to the side after checking the field name

Good. I have an excel file that displays information information below. I want to extract some information and mount a single table with the following columns: theoriginalfile,itbreakstheinformationevery11lines...theideawouldbetocheckthefiel...
asked by 18.07.2017 / 21:45
1
answer

How to catch the cordenadas taking the line and changing the colunda

Set rgFound = Range("B1:B1000").Find(Sheets("FormAluguer").Range("E10")) If rgFound Is Nothing Then resposta = MsgBox("Não encontrado.", vbYesNo + vbExclamation, "stock incorrecto") Else Dim mrange As String Dim linha As Integer mrange =...
asked by 03.07.2017 / 14:59