Questions tagged as 'vba'

Tagged questions
0
answers

Filtering PivotTables in VBA

I have two PivotTables and I want to always select the same item in them, which in this case are names. So I have a rule that picks up the names in another worksheet and the number of pending issues, if the person has more than 20 issues, it sho...
asked by 30.06.2015 / 13:28
0
answers

What can I do to slow RAM memory processing in VBA? [closed]

I'm doing a spreadsheet, and whenever I run my macros it starts to crash, I've seen how much Ram is using and it's 1.6GB and the file every time it saves it increases in size significantly, now it's 350mb. But in this spreadsheet I do not add ne...
asked by 28.05.2015 / 17:16
1
answer

Manual filter via VBA with the latest values available

I need to filter, via VBA, the last 30 values available in a dynamic table but in the "manual filter" which is the line ... Is it possible to read the values in the "manual filter" in VB?     
asked by 25.03.2015 / 19:46
0
answers

How to view queries that returned error?

Hello, I would like to know if in mySQL, in his own MySQL dictionary I can debug a query that returns with an error of a given application?     
asked by 22.10.2014 / 20:03
0
answers

VBA code to get values inside HTML

I want to collect two values from an HTML through VBA. The information '40 New 'and the' $ 19.95 '. My code succeeds in getting '$ 19.95', but in the following iteration it overwrites and gets '$ 17.38'. 'SetQuestionList=html.getElementById("...
asked by 03.12.2014 / 22:47
2
answers

How to find out if a number is odd or even? [closed]

How do I find even and odd numbers in this list? Sub kati() For li = 1 To 10 For col = 1 To 10     
asked by 02.07.2016 / 17:03
0
answers

Save data to excel file through Outlook

I've created a Rule , which every time an email arrives with a certain text in subject runs a scrip and store certain data in an Excel sheet. Code: Option Explicit Sub CopyToExcelMacro() Dim olItem As Outlook.MailItem Dim xlApp...
asked by 14.11.2014 / 11:23
2
answers

RANGE class SELECT method failed

The intention is that when you click on the Euro Synths tab, the macro impute the "L" character in cell D1 of the Local Synthesis tab and then return to the Euro Overview tab. I was able to solve the error problem by allocating the macro in the...
asked by 24.07.2018 / 15:55
1
answer

VBA Migration to C # - V10 FilledDataRated

Good morning, I need to migrate the following code: GCPEngine.Comercial.Compras.PreencheDadosRelacionados(ref _documento, (short) _preenche); I find the method FilledDataRated in the DLL ICmpBSCompras, which is an interface and not a cla...
asked by 16.07.2018 / 12:22
1
answer

Macro Excel capture redirects of links [closed]

Is it possible to create a macro that copies me the redirects I have in links in cells A1:A100 ? For example in cell A1 I have www.pplware.com , but when we open this url I'm redirected to another url https://pplware.sap...
asked by 30.12.2016 / 10:34