Most voted "macro" questions
91 questions
Sort by count of
-
0
votes0
answers565
viewstake excel cell value below or next after checking the field name
good. I have an excel file that presents information below. i intend to extract some information and assemble a single table with the following columns: the original file, it breaks the information…
-
0
votes1
answer73
viewsVBA / Macro - Cleaning Data
Hello, I’m here cracking my head on how to modify a spreadsheet through a macro. Can anyone please help me? I have a spreadsheet (Plan1) that has A1:AF720 formatting. I need to create a macro so…
-
0
votes1
answer871
viewsCopy data from one column (B), to another sheet, if column condition (F) is met. excel
I tried and I keep trying several codes to automate the data copy (column B, spreadsheet proposals) to another spreadsheet (Projects), also in column B, if the F column of the worksheet "proposals"…
-
0
votes1
answer40
viewsChanging excel cell values
Need through MACRO to change the value of a cell in excel. A field of the accounting type has the following value: R$15,326685459. I need to change the cell automatically to stay: R$15,32000000000.…
-
0
votes1
answer61
viewsClose Excel after running Macro vba on Qlikview
Macro set obj = ActiveDocument.GetSheetObject("CH1") obj.Export "caminho_para_salvar_arquivo" And now I need to close Excel, I used the following command. obj.Close caminho_para_salvar_arquivo' And…
-
0
votes2
answers1066
viewsExcel: Transpose 5 to 5 cells
Hello, I have the following problem, my spreadsheet has hundreds of data all in the same column like this: But I want to find a way to transfer these values to other cells, so that in the first line…
-
0
votes2
answers76
viewsLibreoffice Calc Macro - How to capture selected ranges
I am creating a macro in Libreoffice Calc and need a way to select some non-consecutive cell ranges, and capture which are these selected ranges. For example, I want to select the ranges "A1:A10",…
-
0
votes1
answer89
viewsHow to delete straight parentheses from some subfolders I have using an excel macro?
I have a folder called "Franchisees" where there are several subfolders with the names of franchisees. Inside each franchisee’s folder there are some subfolders whose names contain straight…
-
0
votes2
answers335
viewsDisable Vba Excel View Mode
How to Disable Display Mode by Vba Excel. Wanted that when opening the spreadsheet the user already came with this enabled feature…
-
0
votes2
answers2677
viewsCopy data from one spreadsheet to another
I have a problem in one macro, I am trying to copy data from one spreadsheet and paste into another, but this giving an error when doing the insertion of a new line (in yellow). Spreadsheets: Code:…
-
0
votes1
answer347
viewsError at runtime. Failure in attempted VBA Outlook operation
I created a macro to run a routine in outlook. The code works perfectly on a PC, but when I replicate the code to another macro I get the following message: Runtime error '-2147221233(8004010f)…
-
0
votes1
answer41
viewsCopy Macro between VBA files
Hello, I have a file (I will call WB1) in Excel, with two macros. One of them (macroA) does a data processing and formatting. The other (macroB) creates a new file . xlsm (WB2) and copies some data…
-
0
votes0
answers85
viewsHow to run a Word Macro via Python?
import os import comtypes.client path=r"path to the .docm file where I saved the vba macro" word=comtypes.client.CreateObject("Word.Application") word.Documents.Open(path,ReadOnly=1)…
-
0
votes1
answer23
viewsMacro and VBA that deletes the oldest records, if they are the same value
Talk, guys, I’m new here and I’m desperate for some help. I need you to delete the oldest records from a list of multiple trips, keeping only the latest of them. The print below makes it clearer. In…
-
0
votes1
answer213
viewsMacro in Word to format Whatsapp conversations
Hello, I’m doing a macro to edit Whatsapp conversations. When you access Whatsapp, open a conversation, tap the three points in the upper right corner, tap "More", and then tap "Send by email", the…
-
0
votes1
answer83
viewsHow to change position values for a given resource?
Another Hardcore challenge, I don’t know if I can explain it well, but here it comes. In the table below, I have the resource "X", where he has already made 8 contacts( 5 completed and 3 not…
-
0
votes1
answer41
viewsVba - Function number in full
I need a function in vba that returns a number in full, including the decimal parts until the tenth of a thousandth. Ex: 2,2466 -> 2 integers and two thousand four hundred sixty-six tenths of a…
-
0
votes1
answer2783
viewsHow to extract data from internet by VBA
I’m trying to extract a specific table from a website and paste it into a spreadsheet to update a database daily. But as it is impossible to download the table as excel or csv, I must extract the…
-
0
votes1
answer124
viewsFixed Range Macro Problem
I created a macro to select cell information from a dynamic table and copy to a new table. Sub tabela_tratada_3_var() ' ' tabela_tratada_3_var Macro ' ' Range("D1").Select ActiveCell.FormulaR1C1 =…
-
0
votes1
answer155
viewsAdd Item and Index to combobox
Hello, I would like to insert in a combobox the Item and the index of that Item. The item (function_name) I do through a query in a database and I wanted the index to be the working id_function.…
-
0
votes1
answer249
viewsSearch the Dynamic Table with a macro
I’m trying to set a button to copy the value of a cell, paste it into one of the children of the dynamic table and give ok. Sub Botão17_Clique() ' ' Botão17_Clique Macro ' ' Range("H3").Select…
-
0
votes2
answers684
viewsSave Path Name and Worksheet Name to a Cell
Good afternoon, Guys, I need a function in VBA that I can select a file and write the file name and its path in two cells. The file path I got, according to the code below. But the file name no, can…
-
0
votes1
answer262
views -
0
votes1
answer57
viewsMacro to open, stack and save several . sequential csv files in SPSS
How to program a macro that: Only import a few columns (for example: ano, mes, id, valor and motivo ) of sequential . csv files for SPSS. These files would have type names: DADOS_JAN_2010,…
-
0
votes1
answer53
viewsMacro that compares value and returns the difference between them
I have a spreadsheet Home and another BD, in BD I have data of various types of cars (Name, Type (Sports, Casual), Color, Seats(2 or 5) and Price. And in Home I have 1 group of Buttons option, with…
-
0
votes1
answer42
viewsRepeat image for lines below - MACRO
The VBA formula to insert pictures in the spreadsheet works, however I need to repeat the same code for lines below, however the image is deleted from the previous line, appearing only in the line…
-
0
votes1
answer154
viewsVBA excel perform action from dropdown selection
Talk people, good afternoon, all right? I came to ask for help from the university because I’ve been racking my brain for days and I can’t seem to solve my problem. I basically have this table: By…
-
0
votes1
answer22
viewsValue calculation and result print in cells on the right
I am developing a macro in VBA and I need to take each of the cells in this range and go through a select case function. So far so good, the problem is that it makes me calculating prices and…
-
0
votes0
answers15
viewsI would like a help to transform this VBA code to the Google Apps Script script script
I would like a help to transform this VBA code to the Google Apps Script script script. Dim HTMLDoc As HTMLDocument Dim oBrowser As InternetExplorer Sub Login() Dim oHTML_Element As IHTMLElement Dim…
-
0
votes0
answers43
viewsCheck Box(Form) - Copy to row below and change cell link
Hello! I would like to know if it is possible to carry out the following: I have several checkboxes, where each one is linked to the cell in which it is, when selecting the cell of this box and…
-
0
votes0
answers9
viewsHow to Save File Inside Folder(Variable Name) Excel VBA?
am having trouble saving workbook in created directory Code to create folder Sub CRIARPASTA() Dim VAR As Object, NOVAPASTA Dim Nome As String Dim OS As String Nome = Worksheets(3).Range("f5").Value…
-
-1
votes2
answers2049
viewsVBA Code Adaptation to fetch photos from a folder
Good afternoon. I have a macro, which searches a spreadsheet for the name of the photo (e.g., IMG0102.JPG), searches a predefined folder for the related photo and inserts it into the cell that bears…
-
-1
votes1
answer23
viewsVBA Macro Tip - Variable content selection
I’m doing a simple macro, but I’m not getting it. I want the macro to locate the value of a specific cell, that this value is varying while the macro is generating: Sub teste() Range("C1").Select…
-
-1
votes1
answer31
viewsvba data conversion
I have a macro that takes a file inside a folder, converts it from txt with fixed width to csv and saves it in another folder. I get about 400 to 450 files in this format for conversion, the macro…
-
-1
votes1
answer18
viewsMsgbox when he can’t find the search doesn’t show up
Msgbox in bold does not work. Or when it works it does not take the data located. sub MSIAPE() Application.Screenupdating = False Dim MSIAPE As String Dim Celula As Range Dim Valor Dim Assunto As…
-
-1
votes1
answer58
viewsExcel Spreadsheet Macro - VBA - Application definition or object definition error (Completed)
I am creating a macro by Activex Command Button, where it will first select specific cells, each column at a time(AT2:AT15, BI2:BI15, BX2:BX15) and sort them from A to Z. After, in these same cells,…
-
-1
votes0
answers22
viewsMacro Copy selection from one Worksheet to another
Hello! I have a macro of a "Control of Forms" button that copies the data of a selection of a Spreadsheet and pastes (Values and Original Formatting) in a selection of another Worksheet, however, if…
-
-1
votes0
answers27
viewsSelect WEB combobox with VBA
I have a code in VBA that should insert data on a site, I can insert the text, but there is a macro behind this code that when clicking on the text it opens more text boxes. What code should I enter…
-
-2
votes1
answer63
viewsMacro does not send emails
My macro does not send emails... it has the following options, open Outlook and do not send email, or send... but it just opens and does not send.. **' VERIFICAR SE DEVE ENVIAR OU APENAS EXIBIR O…
-
-3
votes0
answers22
viewsProblem with IE interaction in Vba, I can’t save
I’m new around here! I’m having a difficulty with save button, on windows screen, I’m doing an IE interaction in vba, enter a particular site, I dowload the file, I click save as, it goes to the…
-
-3
votes1
answer25
viewsAssign formula to a cell in VBA - Appears a @
I am learning VBA and in a sub where I try to assign the command below: =PROCX([@[Empresa Emitente]];FORNECEDORES[Empresa Emitente];FORNECEDORES[DEPART];"";0;1) Sub EXTRAIR_DEPART_UPDATE() Dim…