Questions tagged as 'macro'

Tagged questions
1
answer

Macro email range + signature

Good morning. I need help with a macro for sending emails in Outlook 2007. I have a macro that selects a certain range of cells (everything to the right and everything down from a referenced cell) and pastes into an email, along with the i...
asked by 19.04.2018 / 16:07
2
answers

AutoFill - How to select the second line

Dear, I have the following problem: I'm filling a cell with one formula and need to be duplicated for the other cells. So I'm using the code Selection.AutoFill Destination:=Range("C2:C329") Problem: Whenever I run this function, I mak...
asked by 09.10.2017 / 16:36
1
answer

MACRO in Excel - print with sequential numbers

I have a macro from a few years ago that still works, when I click to print the production orders of my company, I put the start and end number, and the macro prints the OPs with the numbers in order, follows the macro : Sub PrintJobs() Dim i...
asked by 12.11.2015 / 13:55
2
answers

How to delete line with information after a blank line in the middle?

I am running a macro to import txt data. But this macro is bringing the information below after a white line    (9 rows (s) affected) The information of the data is correct, however it has this line that I need the macro to delete. Thi...
asked by 06.03.2015 / 20:53
1
answer

Read and write xlsm file in php

I have a fairly large hand problem which is as follows: I have an xlsm file with macros to read, write, and then download. It is a 4 MB file with formatting and embedded images. I have used PHPExcel just because I have not been able to rea...
asked by 13.04.2015 / 12:24
1
answer

Do you have a macro to create another macro?

I have a spreadsheet of analysts, however, when the analyst changes or some new one comes in I need to copy everything just like the other analysts just changing the name of it. I would like to know if there is a possibility of creating a macro...
asked by 29.06.2015 / 15:19
1
answer

Prevent Macro Using MAC Address on the Network

Is a spreadsheet available on the network, can be prevented from running a macro if the machine is not "authorized"? I need to block certain users or PC's by using the MAC address for example.     
asked by 24.02.2016 / 22:58
1
answer

Limit characters and type of characters

I need some help. I have a worksheet like this: AndIwanttolimitamountofcharactersandtypeInthesegmentcolumnIwanttolimititto6charactersifitislessthan6ormorethan6.Returnsthemsg"Character limit not reached" In the date column I want to lim...
asked by 09.11.2017 / 17:04
1
answer

ComboBox does not update and accepts wrong values

Well, I have this code for a combobox, and I have two problems. First: I can not get the combobox to just accept the list values Second: Listing only has value PrivateSubTempCombo_Change()DimvAsVariant,iAsLongWithMe.TempComboIf.Value&...
asked by 13.07.2017 / 18:34
1
answer

How to import data from the internet to excel vba

I'm trying to download a site's table: " link , and I've already" got it ". But there's a problem with my code. I want the user to set the team. This is done by selecting in a combo box on the site, well, I even change the combo box data, howeve...
asked by 31.12.2016 / 21:59