Best answeres tagged with vba

1

answer

How to copy multiple excel files into an access 2010 database using vba [closed]

I'm new to VBA programming. I need a vba code in excel that copies several excel files to an access table.

asked by 18.05.2016 / 20:41

1

answer

Macro execution is interrupted repeatedly - How to avoid? [closed]

When I'm running a VBA macro, eventually the code is interrupted, as if there were breakpoints . The message displayed is: The code execution has been stopped. If you accept the message and continue running the code, the behav...

asked by 29.09.2015 / 20:18

1

answer

Macro in Outlook 2010 OnTime ()

asked by 25.08.2015 / 14:10

1

answer

Macro to delete filtered table row

I created a table with data from an account balance and I am making a macro to select only a few values. A macro assignment would filter all zeroed values into one of the columns to exclude the rows of those accounts that had no movement. Aft...

asked by 21.08.2015 / 23:26

1

answer

Adding cascading data from a column in Access

asked by 04.12.2015 / 17:23

1

answer

Problem importing text file via VBA

I'm trying to import a text file into excel through the following macro: Sub Teste() Dim intervalo As String intervalo = "intervalo" Workbooks.Add ActiveWorkbook.Sheets("Plan1").Select With ActiveSheet.QueryTables.Add(Co...

asked by 10.07.2015 / 21:31

1

answer

Multiple Access Instances

As you open multiple instances of the same Access Bank, I saw that an old coworker used the command: Shell "MSACCESS.EXE " & Chr(34) & CurrentDb.Name & Chr(34) But when I run it returns an error saying that the Bank is a...

asked by 25.06.2015 / 19:05

1

answer

Select a row from the listbox object

I have a spreadsheet (PLan1), with its cells listed in listbox1 , I would like to capture a row with multiple cells of information and list it in userform , how should I do it?

asked by 10.06.2015 / 20:37

1

answer

Convert EUR-US and USA-EUR currency formats into Excel

My problem: Convert a Range Excel with currency format (USD) into (EUR) and vice versa. Format USD 123,456,789.00 Format EUR 123 456 789,00 I tried to code a replacement in VBA but I'm a newbie to these things. Can anyone hel...

asked by 13.03.2015 / 19:20

1

answer

Consolidation of tables in MSAccess and VBA

I have the following database in access: mov_atm n_mov conta data valor mov_sc 100 200 1/8/2014 500 n_mov conta data valor 101 900 5/8/2014 800 200 900 5/8/2014 80...

asked by 19.05.2014 / 18:03

Questions tagged as 'vba'