Questions tagged as 'vba'

Tagged questions
0
answers

Doubts in excel

I'm creating a macro where I send emails, but I'm stuck in a process. I would like to know if it is possible to create a column where I select a pending reason, for example "lack of rg" that when selected, it has a script ready and is automat...
asked by 29.05.2018 / 19:13
1
answer

Excel (VBA) - Copy file data

I'm trying to gather data from multiple files into a single worksheet. In some searches I did for the network, I found several suggestions, and below is the code I found and met the need. I made some adjustments to adapt to what I needed but I'm...
asked by 29.05.2018 / 17:13
1
answer

How to load a listview with more than 30 columns?

I'm trying to load a ListView with more than thirty columns using the following code: With ListV_P Sheets("BANCO").Select Dim UltimaLinha As Variant Dim Linha As String '.GetFirstVisible = True 'Abilita as linhas de Grades '.View = lv...
asked by 22.05.2018 / 02:28
0
answers

Problem Set InvokePattern = Button.GetCurrentPattern (UIA_InvokePatternId)

I'm having trouble with the save button in IE11 - I changed the field to the language of the program (Portuguese), but then I'm not getting it. Sub DownloadFile(h As Long) Dim o As IUIAutomation Dim e As IUIAutomationElement Dim iCnd As IUIAut...
asked by 22.05.2018 / 16:36
1
answer

insert value of another form automatically into active textbox

I come again to you for help. this in my view is from the hard level. I have two forms the first has five textboxes the second is a numpad with the buttons from zero to nine, the comma, the enter and a textbox that serves as a display where I ca...
asked by 27.06.2018 / 02:09
1
answer

VBA code to insert images into excel can not recognize images that have letters and special characters in the image name

I use the following VBA code to grab images from a folder and insert it into a spreadsheet, but the VBA code can not recognize images that have letters and special characters in the image name, eg: (SP20-TP02), if the name of the image is just n...
asked by 09.05.2018 / 14:03
1
answer

Delete unwanted VBA values

Good morning guys, I have the following macro to run a filter inside a column and bring me a certain value. but in that same column there are other values, I would like to delete the values that I will not use, how can I do it? follow the code....
asked by 23.05.2018 / 15:43
0
answers

Click for interactive online chart

I need to make the selection of the information on the left side of the chart according to my need, but I can not reference the information. I did not put any code because I tried it in many ways (according to what I learned from my other questi...
asked by 10.04.2018 / 15:07
1
answer

Skip digits when running

I have a problem, I got a script here to insert the ninth digit if the phone starts with 6,7,8,9 .. Function ValidarCelular(Myrange As Range) As String On Error GoTo ErrHandler: Dim regEx As New RegExp Dim strPattern As String...
asked by 04.05.2018 / 16:29
0
answers

Skin windows media player Adjust window to video size

I'm building a very simple skin for windows media player. How do I make the video open in its original size? That is, WMP has to capture the size of the video and already open in its size. For example, if a video has 200x200 WMP already opens th...
asked by 26.04.2018 / 16:49