Questions tagged as 'vba'

Tagged questions
0
answers

Increase the source of the list in Data Validation

Hello, I have a field in my spreadsheet that has a list of data validation, I would like to know how to increase this font, making it more visible. NOTE: Without the zoom scheme. Here is the list:     
asked by 27.06.2017 / 16:00
0
answers

Import Internet Table For Excel

Is it possible to import the following table into this site for excel using VBA? The path is as follows: link 1-) Click complete list 2-) Click on (one business day) I tried to use Excel's New Web Query tool but apparently for this...
asked by 23.03.2016 / 13:54
3
answers

VBA - How to split a word mail merge into multiple .pdf files

Personally, my case is this: I participate in the organization of some events in the area of IT and free software and the printing of certificates is always a problem. In the last event that I participated as an organizer the mission was to issu...
asked by 21.07.2016 / 05:24
2
answers

Restart numbered list VBA Excel Word

I'm trying to create a macro in VBA to create a word document from Excel. At the moment I'm having problems with lists. I want list numbering to be linked to my Header1 and Header2 Styles so they look like this: 1. Header1 1.1. Header2...
asked by 08.10.2014 / 18:19
2
answers

auto filter Vba

I am developing a macro to perform filters using VBA, however in some columns, I have to uncheck some values, for example: Column Paulo Fernanda Carla Lais Renata I want everything that is different from Paulo, Fernanda and Rena...
asked by 26.06.2015 / 19:46
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
3
answers

How to create an Excel macro to delete duplicate rows

You can show someone an example of Macro in Excel that removes duplicate rows, but comparing all rows in the same cell, or selecting which rows to compare, eg para linha_atual em todas_as_linhas faça para linha_de_comparacao em todas_as_l...
asked by 29.08.2014 / 17:19
2
answers

Event triggered when changing a Document header field (eg change the exchange).

I'm looking for an event triggered by changing a document header field (eg change the exchange), this all in VBA in Spring version 9. The final idea is when changing the value of the exchange in the header to update all lines with the new cha...
asked by 24.07.2018 / 09:28
2
answers

Split in VBA does not work

I have the following code snippet: CorpID = rsSQL.Fields("Name") Tmp14 = Split(CorpID, , 1) Tmp15 = Join(Tmp14) Me.nomeUsuario.Caption = Tmp15     
asked by 15.10.2014 / 16:27
2
answers

How to draw a variable from others?

My intention is for the code to pass through 9 TextBox checking if they are filled with names or empty. For each filled TextBox would be added 1 in a count variable and would be allocated the text of the TextBox in another variable (p1, p2, p...
asked by 04.09.2017 / 16:48