Questions tagged as 'macros'

Tagged questions
1
answer

Problem with macro in outlook (vba) Not running

Good morning I'm doing a vba to outlook I found the following code and it worked, I began to add functions I need and everything was fine but I do not know what moved him that now the program (or macro) is no longer recognized by the outlook I a...
asked by 05.11.2018 / 18:09
1
answer

Generate link from outlook with a macro (vba) using FollowHyperlink

I have a macro to read the emails and extra information and based on that information will generate a link to respond to a server (in php) I already have that part but I can not generate the links from the macro and probe several things and I do...
asked by 06.11.2018 / 00:13
0
answers

Create several tables with different names from a macro

Hi, I'm new using python, I'm trying to read several csv files and create a table in python for each of them. I already managed to import them but I do not know how to make the name of each table change, here's the code: import os import glob...
asked by 04.11.2018 / 21:43
0
answers

How can I compare a txt with an excel and that this txt be traced line by line?

With a macro that I made I can perfectly pass a txt to excel from a route of choice. The problem arises that within the EOF function to get to the end of the txt I know only two instructions Line input and Input. Both read me line by line txt an...
asked by 25.10.2018 / 22:56
1
answer

Count cells in a filtered range

I am working on some Excel reports in which we need the amount of tickets that are not being attended (empty cells), according to other criteria. Currently this is what I have in my code gsh.Shapes("UnpickedCE").TextFrame.Characters.Text =...
asked by 06.09.2018 / 18:08
0
answers

How to save file in UTF-8 format in VBA

I have a macro that works well, it saves a file in .csv and puts double quotes, which I need. The problem that inside this file I have special characters (in Korean, Chinese, etc) and when I save it, it changes me. I was reading and I thin...
asked by 31.08.2018 / 19:08
0
answers

Macro Slicer runtime error '1004' application-defined or object-defined error vba excel

I need to create a slicer that affects all the pivot tables that belong to certain types of work orders. For that first I create the slicer from a pivot table, and then I try to add the other pivots by means of a macro Sub Button13_Click()...
asked by 24.08.2018 / 23:55
1
answer

Image (Image1) userform to excel sheet

Good morning. Greetings to all, I'm doing a small macro in excel with vb-userform where I have several text fields, this data is passed to an excel sheet with a button. This image I want to add it to my sheet. I am using this code, t...
asked by 15.08.2018 / 18:26
0
answers

Macro error print chips in pdf

I'm working on a code to execute a macro that prints different sheets of a book in Excel based on a series of variables. Step by step, the macro executes correctly at 100% but from its assigned button, the cards are printed correctly, except...
asked by 31.07.2018 / 14:58
0
answers

Question VBA Sub paste within sub paste VBA

I am working on a macro to copy and paste data into a table and into the blank cell that is available consecutively. However, there is data in another sheet that I want you to paste the data after the first SUB that ran. I mean I want you to...
asked by 20.07.2018 / 18:39