Questions tagged as 'vba'

Tagged questions
0
answers

How to open windows explorer with VBA in W10

Good morning everyone, First of all, I am new to Stackoverflow and, although I have been investigating different threads, I have not been able to find a solution. To put a little bit in situation, I am developing an application from the Movic...
asked by 16.11.2017 / 09:48
0
answers

Callout VBA word

I'm doing a macro in Visual Basic for word. I already have this code: Set Callout = ActiveDocument.Shapes.AddCallout( _ Type:=msoCalloutThree, _ Left:=170, Top:=119.5, Width:=widthsize1, Height:=heightsize1) Callout.Callout.Accent = msoFalse...
asked by 19.09.2017 / 08:22
0
answers

Manipulate a UserForm in Excel with Python [closed]

I have a button on an excel sheet that calls a form with several things like radio buttons, listbox, etc. I'm looking for ways to manipulate the comboboxes inside the form with a Python script but I have no idea how to do it. I have been p...
asked by 15.09.2017 / 05:16
1
answer

Format of text to message body

I'm doing a macro in Excel which is used to send a meeting with Outlook, everything works fine but in the body of the message I want the text to be formatted, for example to put the text of colors, with bold, etc. Which I have not yet achieved,...
asked by 10.08.2017 / 21:37
2
answers

Click on a variable ID

Good afternoon, I'm doing a small macro as a bot, to enter data in a web page that I have to use repeatedly. In the code I only need the last part, but I can not use getElementByID, since the ID is variable, I had thought of a couple of th...
asked by 16.10.2017 / 17:47
0
answers

Click on a span element that is inside an iframe with vba

The page shows a text that says MAINTENANCE; by clicking with the mouse enables some text boxes, the problem is that there is no id or name to access the element by id or name. according to me with my visual code I try to find the word maintena...
asked by 29.05.2017 / 18:22
0
answers

How to modify the value or link of a .href attribute from vba excel?

In my company we started using Altiris from Symantec At this moment I am in charge of the massive load of hardware inventories. I upload the information using Excel - VBA. The data loading formulations are in HTML and JavaScripts format In a...
asked by 03.05.2017 / 20:48
0
answers

VBA macros excel [closed]

I have a sheet with ActiveX buttons; Each button has a password to open a specific sheet. When I click on any button it takes me to: Private Sub Alpujarra_Click() formContra.Show End Sub Private Sub btnAceptar_Click() Clave = txtClav...
asked by 25.08.2016 / 21:07
1
answer

How to calculate how many items are associated with an ID

I'm working on excel and in one of the formulas I have to do, I calculate how many different items are associated with a specific ID. I have the following columns ID Item OPX-0020433077 Continuity Services OPX-0020433077...
asked by 04.12.2018 / 15:21
0
answers

How to create a ms word field with the number of the last page of the document?

Many academic texts have different page numbers. Usually the pre-textual part is listed with Roman numerals and starts on the second page. After the pre-textual part, immediately start the text with a Arabic numbering . Starting from 1 ....
asked by 10.09.2016 / 04:22