Questions tagged as 'macro'

Tagged questions
1
answer

How to use getElementsByClassName on an Internet Explorer object in VB.Net?

I'm trying to use a getElementsByClassName in an Access macro. You're experiencing an error on the line: If ie.Document.GetElementsByClassName("msgErroAdic").Length > 1 Then Being Dim ie as Object and Set ie = CreateObject("Int...
asked by 17.04.2017 / 18:59
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

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
1
answer

How to remove brackets from some subfolders I have using an excel macro?

I have a folder called "Franchised" where there are numerous sub-folders with the names of the franchisees. Within the folder of each franchisee there are some subfolders whose names contain brackets. I want to program a macro to remove the b...
asked by 13.11.2018 / 11:34
1
answer

Macro in Word to format WhatsApp conversations

Hello, I'm doing a macro to edit WhatsApp conversations. When you go to WhatsApp, open a conversation, touch the three dots in the upper right corner, touch "More," and then touch "Email," the conversation comes in a ".txt file ". I would...
asked by 13.07.2018 / 06:44
1
answer

Change cell values excel

I need MACRO to change the value of a cell in excel. An account type field has the following value: $ 15.326685459. I need to change the cell automatically so that it stays: R $ 15.32 billion. Does anyone know how I can do this?     
asked by 14.06.2018 / 15:02
1
answer

Copy data from one column (B) to another worksheet, if column (F) condition is met. excel

I have tried and continue to try various codes to automate the copying of data (column B, worksheet proposals) to another worksheet, also in column B, if column F of the "proposals" spreadsheet contains the terms "Accepts" or "Sent". Both wor...
asked by 16.05.2018 / 13:49
2
answers

Copy data from one worksheet to another

I have a problem in a macro, I'm trying to copy data from one worksheet and paste it into another one, but it's giving an error when inserting a new line (in yellow). Sheets: Code:SubcopiarDadosEntrePlanilhas()Application.ScreenUpdating=Fal...
asked by 23.04.2018 / 14:10
1
answer

VBA / Macro - Cleaning Data [closed]

Hello, I'm here here breaking my head on how to modify a spreadsheet through a macro. Can someone please help me? I have a worksheet (Plan1) that have the formatting A1: AF720. I need to create a macro so that it is split into several other s...
asked by 24.04.2018 / 14:03
0
answers

How to extract data from the internet by VBA

I'm trying to extract a specific table from a site and paste it into a worksheet to update a database on a daily basis. But as it is impossible to download the table as excel or csv, I should extract the table directly from the site....
asked by 03.01.2019 / 14:40