Questions tagged as 'vba'

Tagged questions
1
answer

How to separate edital String in Excel

I need to separate this type of String (Example): 1 Estruturas lógicas. 2 Lógica de argumentação: analogias, inferências, deduções e conclusões. 3 Lógica sentencial (ou proposicional). 3.1 Proposições simples e compostas. 3.2 Tabelasverdade. 3...
asked by 20.09.2017 / 20:13
1
answer

Rename PDF file [closed]

Good Afternoon Community, I'm trying to create a macro that renames 125 PDF files that are in a specific folder C: ... I want it to replace the name that is in my column B ... Type get the PDFs in the folder then rename them accordingly my sp...
asked by 27.07.2017 / 18:55
1
answer

VBA: Declare Variables Online

To declare variables in VBA , I always used the following method: all variables of the same type I would put on a same line and declare their type only at the end, as in the example below: Dim RngSource, RngDestin, RngCalc As Range Dim i...
asked by 11.04.2017 / 16:28
1
answer

VBA Doubt - Forms

Good morning. How to format the CPF field in the figure below? Thankful     
asked by 13.02.2017 / 15:29
1
answer

VBA how to look up the specific name of a worksheet and assign data to it

Personal I have a list in the plan ("Registration"). range ("H2: H10") I have Data in plan ("Treated"). range ("A2": "Q1862") I want to search for the name in the plan list ("Register"). range ("H2: H10"), in the plan ("Treaty"). line wher...
asked by 30.03.2017 / 21:50
1
answer

VBA: Placing a space before or after uppercase letters in a given text

I have a sequence of texts that represent customer names, but they do not have enough space between each word / name (for example: CarlosAlbertoGomes ). However the words can be differentiated because the first letter of each word is capitalize...
asked by 05.04.2017 / 19:00
1
answer

Macro Excel - Save image to chart export to directory and import to form

I upgraded my version of Office to 2016 and some macros stopped working properly. The routine when executed in isolation works properly, but when it goes into a process it stops working. The macro in question makes the following precedents. Copy...
asked by 18.08.2016 / 15:42
1
answer

How can I format equations in Word 2013 automatically?

I use Microsoft Word as a text editor (Office 2013 package). I built document with a document with lots of equations making use of the Microsoft Equation 3.0 . However every time I save the document, I ask to update the figure indexes, or open...
asked by 27.08.2016 / 22:25
1
answer

Why do ASCII characters differ from Excel for presentation through code in VBA?

Does anyone know why this occurs? I need to use characters from the " Wingdings 3 " font in Labels dynamically created in a VBA If these Labels are created directly on the form the problem does not occur, for example, when creating a...
asked by 18.03.2016 / 16:35
2
answers

How to delete dynamically created objects based on vector? (VBA / Excel)

The code below creates Labels dynamically based on a vector, it happens that I did not succeed in trying to delete (destroy) these objects. I tested the 'Nothing' and other features indicated, but none worked, that is, the Labels remain on th...
asked by 17.03.2016 / 23:42