Questions tagged as 'macro'

Tagged questions
0
answers

Macro to print PDF and delete in Outlook 2016

I'm working on a macro to print all emails received in PDF but it's not working, I do not know if it's the version of my adobe that is the latest one. Does anyone have any ideas? This script Public Sub PrintAttachments() Dim Inbox As MAP...
asked by 04.12.2018 / 17:19
0
answers

Exporting objects in Qlikview

I know that for objects of type / ID = TXT, we export as follows: set cs = ActiveDocument.GetSheetObject("TXT111") set XLApp = CreateObject("Excel.Application") set XLDoc = XLApp.Worbooks.Add XLDoc.Sheets(1).name="Export text object" setXLShee...
asked by 18.10.2018 / 22:25
2
answers

LibreOffice Calc Macro - Capturing Selected Intervals

I am creating a macro in LibreOffice Calc and need a way to select some non-consecutive cell ranges, and capture which are those selected ranges. For example, I want to select the intervals "A1: A10", "C5: C13", "H7: H9" and to be able to captur...
asked by 16.10.2018 / 02:52
1
answer

How to change position values for a given resource?

Another Hardcore challenge, I do not know if I can explain it well, but there it goes. In the table below, I have the "X" feature, where he has already made 8 contacts (5 completed and 3 unfinished) and I would like to automatically count which...
asked by 15.09.2018 / 20:41
0
answers

How to loop in VBA from autofilters using value "differing from"

Good afternoon, doing an automation in VBA in which I need to loop through filters on different lines (sequential values from 1 to 95) but my selection will be with the filter criteria "other than". Copy the excel tab to a new worksheet, sele...
asked by 08.05.2018 / 22:45
0
answers

How to select an item from a listview and change its information in the source cell (where the data is entered into the listview)

I'm having a difficulty on a Form, in which I have information from a plan1 (Database), plan2 (Support for the dynamic filter). Where Plan1 gives me the information about the listbox items, and plan2 serves to work with the filter with several c...
asked by 26.03.2018 / 17:44
2
answers

Excel: Transpose every 5 cells

Hello, I have the following problem, my spreadsheet has hundreds of data all in the same column this way: ButIwanttofindawaytotransferthesevaluestoothercells,sothatthefirstlineshowsthefirst5data,thesecondrowthenext5,thethirdrowthenext5,andso...
asked by 20.12.2017 / 19:08
2
answers

Pass values from one form to another

Dear I have two forms A and B. A = Has the listview and displays information from the base B = You need to receive form A information and display. (Information that is not displayed in form A) I need to make this happen through the l...
asked by 01.11.2017 / 17:01
0
answers

Userform as auth method not working Excel [closed]

Hey guys I think it's probably a very simple awnser but I'm not finding it. I made a simple user form that takes a user and a password and pops up before the workbook is visible as a simple auth method. The problem is that I want to hide the...
asked by 05.10.2017 / 23:42
0
answers

VBA Integration with IE, return Value where Value=""

I have a problem with a macro to return the value of a web page, my question is whether the value displayed in the HTML code is always null, but in the answer box it gives me the requested value. Even after performing the search there is no chan...
asked by 27.08.2017 / 21:32