Questions tagged as 'vba'

Tagged questions
1
answer

VBA Download pdf

I'm developing a macro in excel that through a list of ids and passwords in excel logs into a website and tries to download a pdf. I can log in to the site and navigate to the button that generates the pfd. The problem is that the button trigger...
asked by 26.05.2016 / 17:07
1
answer

Block fields in SubForms in MS Access

I have the following Form with a SubForm: IneedtoenableCheckin"Approve3" and block the other fields, but I only get "LOCK" all or none, how can I get around? Maybe for vba? I remember a SubForm inside a Form     
asked by 16.05.2016 / 15:25
2
answers

Delete a macro using another

How to program one macro to exclude another? It would be something like, like when, do I need to call? Ex.: Sub callmacro() Call macro1 End sub And, even better, if I want to program it to self-delete? Eg: Sub macro1() Dim i as... Fo...
asked by 17.02.2016 / 16:35
3
answers

How do I open a list of the "Queries SQL" category with VBA?

I want to invoke a VBA list of the " SQL Queries category". I know the PSO.Listas.GetF4SQL method but this way the list opens in "Modal" and does not allow to maximize the form. The goal is to use the PSO.AbreLista method, but I c...
asked by 24.06.2018 / 23:09
2
answers

Handle worksheet with userform loaded (excel vba)?

When we have userform loaded, can you change / browse in spreadsheets of excel ?     
asked by 22.03.2017 / 23:47
1
answer

How to modify VBA function to write extensively a number greater than 1 trillion in EXCEL cell?

In 2013 a user submitted a question about how to spell out a number stored in an EXCEL cell. One of the answers contained a VBA function that had already been published by UOL for some time. I consider one of the best functions already developed...
asked by 19.10.2015 / 12:11
2
answers

Find equal ranges in a list

I am a beginner user and have tried almost everything but I have not been able to resolve the issue and would like to know if anyone could help me. In a column I have numerical values and would like to compare the ranges of four cells "A2: A5...
asked by 02.10.2016 / 20:31
1
answer

macro to copy and paste

I have data in the "M" column, which are automatically entered in an average of 70 rows per month, only have empty cell ranges (the 12 months of the year are in column "M"). So I wanted to copy this data per month, to column "N", automaticall...
asked by 26.01.2016 / 12:26
1
answer

use excel spreadsheet to fill web form [closed]

I have a spreadsheet in Excel, it was generated from a form on a system and then some data was selected. After that I have to put this data in another web form, this form is in another system than the one that generated the initial worksheet. To...
asked by 23.11.2015 / 02:06
2
answers

VBA - Counting the number of cells filled in row

Hello everyone. I'm trying to create a code responsible for reading the number of cells filled in the rows .. I tried this way but I was not successful. For b = 1 To rMaior contador = Worksheets("1").Range("b:b").Cells.SpecialCells(...
asked by 10.11.2015 / 13:55