Questions tagged as 'vba'

Tagged questions
0
answers

Generate VBscript log

I have the following code. ' Ajuste o número de psts a serem feitos backup. *Obs.: comece por 0* ' ReDim pst(0) ' Defina o local referente a cada arquivo a ser feito backup ' pst(0) = "C:\Users\teste-pc-1\Documents\Arquivos do Outlook\backu...
asked by 28.11.2017 / 14:39
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
1
answer

Collecting HTML tag data with VBA

How can I get the return of an html tag through getElementById? I'm testing on the application below, but I'm not getting it. My intention is to get what's inside the tag. Sub teste() Dim IE As Object Set IE = CreateObject("internetexplore...
asked by 09.11.2017 / 18:45
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
1
answer

Problem handling dates in an ACCESS / VBA application with SQL Server database

I needed to migrate the bank of an application made in vba using the access. The database was native to access and I switched to SQL Server. In access, as everything is native everything worked perfectly, but in migration a problem that is gi...
asked by 20.10.2017 / 06:19
0
answers

Import access data to excel based on criteria

I have a table in access and I can even pull its data to an excel worksheet (I can do this using the code below), but I would like to be able to pull only some data (based on criteria such as an advanced excel, only realized between excel and ac...
asked by 18.10.2017 / 18:18
1
answer

How to Give SaveAs in I.E

I have a problem downloading a file via vba, because as I can open the document (pdf format) I can save it with name and location quietly, but how much it does not open in the browser itself, when it is a .doc file it opens only the tab below....
asked by 02.10.2017 / 15:49
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