Questions tagged as 'excel-vba'

2
answers

Find element without ID tag and Name

Expensive, I need to find the element that does not contain id or name in HTML. Below is the example HTML <button type="button" class="btn btn-primary ng-scope" data-ng-if="novo2()" data-ng-click="novo()" clickonce="">...
asked by 28.02.2018 / 21:23
1
answer

Activate found cell

I'm having trouble activating the cell that was found. The code is as follows: Private Sub cmdPesquisar_Click() 'Verificar se foi digitado um nome na primeira caixa de texto If Txtnif.Text = "" Then MsgBox "Digite o NIF d...
asked by 06.12.2017 / 17:42
1
answer

How to replicate a value depending on what is inside the cell?

I have a code that always puts 264 empty characters after the last word entered inside the cell; then puts more "00000000000000" after the 264 empty characters and I export to txt, as I show below: MyquestionisdoIhavetoputattheendofthelineaf...
asked by 20.11.2017 / 15:58
2
answers

Pass values from one form to another

Dear I have two forms A and B. A = Has the listview and displays information from the base B = You need to receive form A information and display. (Information that is not displayed in form A) I need to make this happen through the l...
asked by 01.11.2017 / 17:01
0
answers

Userform as auth method not working Excel [closed]

Hey guys I think it's probably a very simple awnser but I'm not finding it. I made a simple user form that takes a user and a password and pops up before the workbook is visible as a simple auth method. The problem is that I want to hide the...
asked by 05.10.2017 / 23:42
2
answers

For nested parallel VBA Excel

I'm doing a For in another For , where it runs per column, finds the cell and copies, in the other For it runs column as well and it queues in a range. However, the code is executing a whole For first and then executin...
asked by 05.10.2017 / 01:17
0
answers

Copy multiple sheets into a single file

Good afternoon, I made a code to capture a sheets of a certain worksheet, but now I want to take more than one and save all in a single file, but I can not get someone to help me? Private Sub btnRelatorio_Click() Dim chamarWb As W...
asked by 26.09.2017 / 20:10
0
answers

Error trying to open an Excel file

I'm trying to open a document in excel via vbScript. I am not succeeding at execution, running is generated the following error, without description:    -2147417851 The problem occurs when you run the following command: Set objExcel = C...
asked by 11.10.2017 / 15:06
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
0
answers

VBA - generate csv from cells

I want to generate a CSV file from the 3-column data, but they present me with an error, could they help me? Follow the code below: Sub GravaTXT() Dim wbkExport As Workbook Dim shtToExport As Worksheet Dim name As String...
asked by 11.09.2017 / 16:04