Questions tagged as 'excel-vba'

Tagged questions
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
1
answer

How to identify a specific date in VBA?

I have a base with dates of several months and years, and a home screen where I update the submission date and enter the information. I made a code that will identify the month and year of the home screen, identify the month and year at the b...
asked by 28.08.2017 / 13:55
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

Upload image in Excel from a directory

Good afternoon! I'm using the code below to put load images in the excel of certain directory plus my formula is experiencing error Followthecode:PublicFunctiongetImage(ByValsCodeAsString)AsStringDimsFileAsStringDimoSheetAsWorksheetDimoSellA...
asked by 14.07.2017 / 19:37
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
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
0
answers

VBA x IE - collect data from a table

I'm programming in VBA a collection of information on the central bank's website. It turns out that the page does not load fully and when the macro ends only a few records have been loaded in the worksheet. I believe the page has some event that...
asked by 09.06.2017 / 16:47
1
answer

How to run macro with project locked?

Hello, I have a spreadsheet whose project has a password, but I want the macros to work and if the user tries to enter the macros they will have to enter the password (which I put in the project). I put a code that unlocks the spreadsheet upo...
asked by 21.06.2017 / 16:17
1
answer

How to convert multiple .XLSL sheets to .CSV from a book and export it individually to the desktop?

I want to save multiple sheets by the name itself. And that are converted from .xlsx to .csv (separated by commas).     
asked by 31.05.2017 / 21:59