Questions tagged as 'vba'

Tagged questions
0
answers

Load multi-attachements into multiple form attachments

I'm trying to create a function to upload multiple files at the same time but I think that because I'm choosing the next function does not really attach the file, but rather creates a preview. In my opinion, what's wrong with the code is:...
asked by 03.07.2015 / 17:49
1
answer

Multi attchement upload function

I'm trying to create a function to upload multiple files at the same time but even with only one I get an error. What can I be programming wrong? 'FILE DIALOG OPENS UPLOAD PANEL Private Sub Comando715_Click() Call Selectfile End Sub The fun...
asked by 03.07.2015 / 13:09
1
answer

Macro to access website with login

I run a daily routine to access the Serasa site and make the CNPJ query. I need to develop a macro to access this Serasa site, log in and then the query, and then throw the information into Excel. Detail: I have already developed the macro to ac...
asked by 26.12.2014 / 12:09
0
answers

Organizing data EXCEL

My goal is to do Cubic Spline interpolation. For this I am organizing my data as follows: Imadeasimplemodification.IcalculatedtheusefuldaysbetweenthedayofcolumnBandthedates.ForthedatesthathavenovalueIdonotcareabouttheusefuldays.SoIgotthis: T...
asked by 24.07.2015 / 00:07
0
answers

Changes made to a record are reflected in the other records (Access + VBA)

I created a Form for Vehicle reservation where I have a field where the user must enter the destination of the trip. The user may also need more than one destination, so I created an add_destino button that makes inserting textbox into the Form...
asked by 17.03.2015 / 19:15
2
answers

Move images in VB6

Option Compare Database Private Sub Command0_Click() Do Until Me.Width < 4000 Let Image1.Left = Image1.Left - 5 DoEvents Loop End Sub As this allows you to move the image from right to left, how do the image to rotate t...
asked by 05.06.2014 / 14:00
1
answer

Check if an item in a ListBox has been selected

I have a ListBox1 q list of a ChckBox1 checkbox in a UserForm. I want to enable or disable the checkbox ( CheckBox1.Enabled = True/False if any items in the list are selected. The checkbox is disabled initially, but if so...
asked by 27.04.2017 / 22:11
1
answer

Manipulate Google Chrome with VBA

I am creating code that goes into my company's online system, but it can only be accessed by Google Chrome. The code to open Chrome is this: Sub Chrome() Dim GC As Object Dim WebUrl As String Dim NavigatorAddress As String...
asked by 31.05.2017 / 22:27
1
answer

Copying table record to itself via vba [closed]

Can you copy a record from a table and insert it into it? I wanted to copy a record into a new one in the same table. INSERT INTO Produtos ( Produto, Preco ) SELECT Produtos.Produto, Produtos.Preco FROM Produtos WHERE (((Produtos.Produto)="AN0...
asked by 21.01.2014 / 18:36
1
answer

report excel filter [closed]

I'm trying to make a report but I need a help for the worksheet to have to search by date and paste in another worksheet the data of that same date (example in the line that has today's date copy all of today and paste in the other worksheet). H...
asked by 25.07.2018 / 23:22