Questions tagged as 'vba'

Tagged questions
1
answer

Error 3706 Microsoft Visual Basic

I'm doing an application and when I was programming the VBA code to connect to Access Database what was my astonishment gave the error:    "Microsoft Visual Basic Error 3706" The connection line is: .ConnectionString = "Data Source=" &a...
asked by 26.04.2017 / 12:53
1
answer

VBA Excel Reference Tools?

In Excel in VBA in Tools, Reference appears (ABS: Adobe acrobat 7.0 type library) where can I get this library and how do I include it in the reference list?     
asked by 10.04.2017 / 22:42
1
answer

When I refer to more than one column using FormulaR1C1

Good morning! I'm having trouble referencing more than one column in excel using VBA, for example: Stock! A: G and I create the macro, and it generates for me Stock! C [-6]: C , I did not understand how it when I migrate for FormulaR1C1...
asked by 30.03.2017 / 16:01
1
answer

Copy cells to another worksheet if it does not exist

In the "BASE" worksheet, enter various customer data (NIF, name, address, telephone, email). I have a "DATA" worksheet where you have a list of multiple clients. I need to create a button in the "BASE" worksheet that copies the client data to...
asked by 30.03.2017 / 13:18
2
answers

SQL Query VBA Excel

Good afternoon! I have a problem with an Access query via form. The form is from the Excel vba, which connects to the database. The full code is below. This is the button code. Clicking it validates which of the two buttons is marked...
asked by 28.03.2017 / 16:58
1
answer

how to make VBA interact with more than one tab in Internet Explorer?

I have a VBA macro that handles Internet Explorer, at some point when clicking an item, a new tab is opened in Internet Explorer. My question is: How to change the focus of VBA to handle this new tab that was opened? follow code: Sub x...
asked by 29.03.2017 / 20:31
1
answer

Add code in the Workbook using a macro

I have a code that registers who prints the document, but I have a thousand documents and I have to insert the code, I already have the code to put modules, but I need one to put in the Workbook to work when printing, but I can not find how. P...
asked by 04.04.2017 / 14:54
1
answer

Routines between different forms in VB

Well, I'm doing an application in VBA with 2 forms. In form1 I have a flexgrid that loads records from a database and in form 2 I have a textbox that inserts registration in the same database. What I want to do is to click the add button of form...
asked by 17.03.2017 / 00:54
2
answers

SQL Query in Excel VBA

Good morning! First of all I would like to say that I understand almost nothing of Visual Basic and that everything I have learned so far has been in the race in forums. So if that is too simple to solve, forgive me. Now to the problem. I...
asked by 27.03.2017 / 17:10
1
answer

USERFORM: Move ListBox item up or down

I have a ListBox on a UserForm that reflects a list of the display order of items in a Dashboard. I want the user to be free to change the order of these items by moving them down or up in the ListBox, as shown in the figure: Is there a...
asked by 08.04.2017 / 14:40