Questions tagged as 'vba'

Tagged questions
1
answer

How to make a print in VBA

I have an excel full of information But I want to separate the information Imagining what I have in a cell A-ABC-DEF How can I get ABC to appear through a formula in VBA     
asked by 21.09.2018 / 12:43
2
answers

Vba interacting with IE

I need to click on an element of a website: TheproblemisthatthereareseveraloftheseandImadethiscode:ForEachobjInie.Document.allobj.ClickNextButthiscodeclicksonalltheobjectsonthepagecannotIjustgetspecificicons?Thereisnoie.Document.allthatdoest...
asked by 10.04.2018 / 16:18
1
answer

Excel VBA Advanced Filter Problem

I made a program in VBA to calculate the cost in my company. For this I used two connections to the Oracle database. What's strange is the fact that when I try to use the advanced filter manually, it works. However, when I try to use VBA (record...
asked by 27.02.2018 / 21:19
2
answers

Excel form (Block fields)

I have a question as to which formula I can use. I have a box with 3 options (Example: 1, 2, 3) and if I select the option 1 I can fill in the field 1 and the > options 2 and 3 . If you select option 2 , I can fill in the field 2 an...
asked by 21.12.2017 / 13:13
2
answers

How do I display button properties in VBA from an excel sheet?

I have a spreadsheet with buttons that hide and re-display fields as the data set is populated. When I try to view or change the properties of the controls, I can not. VBA only shows the properties of the worksheet.     
asked by 13.04.2017 / 16:46
1
answer

Update table dynamically last. VBA

I created a spreadsheet connected to my ERP via ODBC and I have some dynamic tables in the same spreadsheet. I'm trying to create a macro that updates all data, but using ActiveWorkbook.RefreshAll the command is updating the pivot tabl...
asked by 13.02.2017 / 12:10
1
answer

VBA + WhatsApp Web

Well, I set up a macro in VBA that triggers automatic messages according to some parameters determined in the table. The macro basically works by pressing keys on the keyboard, very simple. In short, the macro opens the browser on the Whats W...
asked by 07.11.2017 / 19:05
1
answer

Are there security issues when implementing and using "add-ins" in VBA (Excel)?

Due to macro security issues in VBA / Excel , I have doubts about whether it's the same (or something similar) when adding a add-in and use it later in VBA projects. Would this impact a user who "wheels" a system made in VBA with thi...
asked by 12.07.2016 / 19:42
1
answer

Automation Development in VBA - Error Handling in Loop

I'm developing a VBA automation that accesses a certain site and takes some information from it, but I'm having a problem with it. The site (Santander - Benner) is very badly done, many parts were built in a way that seems to mend with what t...
asked by 19.06.2018 / 15:15
1
answer

How to convert a VB6 project (.vbp) to VB.NET (.vbproj)? [closed]

I decompiled an application in VB, but it was not .NET, it was VB6. I would like to know how to convert since I already used the VbTo Converter and it crashed into one of the files.  I look quickly for answers: /     
asked by 17.02.2017 / 00:10