Questions tagged as 'vba'

Tagged questions
2
answers

Export data from an array to a table using VBA

In Sheet1 I have a table with only the Header of each column but blank values, I run a VBA that creates an Array that has the same number of columns in the table. Is there any way to export all values from this array to the Excel table at...
asked by 10.10.2014 / 23:17
1
answer

Class not registered - Imagelist

When customizing my imagelist and listview the following error appears:    Class not registered. Searching Object with CLSID: {7EBDAAE0-8120-11CF-899F-00AA00688B10} I think it's because my Office is 64bit, does anyone with 64bit Office ev...
asked by 03.10.2018 / 16:35
0
answers

Join Separate fields in a cell

Folks, I'm making this code, but I wanted the field P.O to divide into the values of P.O, but it only pulls a field, so does it in the division .... Sub CalcularNotas() ' pl_Respostas.Unprotect "Multa123" Dim UltimaLinha As Long Dim LinhaAtu...
asked by 27.08.2018 / 15:33
0
answers

Improvement in my code (basic) to import files in excell VBA

Good evening. I've been working on various spreadsheets with vba code for importing files, and after that, working on their numbers is with macro or formulas. I'd like to get hints on improving this code, reducing rows, whatever. Any tips...
asked by 21.07.2018 / 00:54
1
answer

VBA - Select a file to attach to email

Good morning, ladies and gentlemen, this is my first question. I never did, because I always find the answer in some forum, but this time, I lost! So let's get my question. I used a code mix on the internet to create this routine that enters...
asked by 08.05.2018 / 17:41
1
answer

Insert comment via function

How to insert a comment with the text of a cell through a function?     
asked by 09.11.2017 / 20:26
0
answers

Access Query via VBA

I have an Access database and I'm having problems with QUERY's results. When I run this same QUERY in access, it runs normally, but when I play in VBA it does not give an error, but it does not return any record in RECORSET. Below is the Q...
asked by 30.10.2017 / 20:55
0
answers

Interact with Silverlight

Good to all, I'm developing a VBA system that looks for documents (.pdf) on a particular site. But I came across a problem I had never seen, the site opens an IE tab with a Microsoft Silverlight viewer, so I have my problem, I can not interact w...
asked by 03.11.2017 / 17:43
0
answers

Access database getting heavy after running query via VBA

Next, I have a Access database with a table named tblDados . This table contains 19 initial fields. I import a CSV file que contains 1 million records, so far, save and close the uncompressed and repaired database , it...
asked by 25.05.2018 / 19:40
0
answers

How to use the same .xla add-in on two machines on the same worksheet?

I created a file with functions in VBA .xla that can be configured as an excel add-in, but after using the functions in any spreadsheet on my machine and sending the spreadsheet to someone else it can not visualize the function return is that #N...
asked by 08.12.2017 / 13:21