Questions tagged as 'excel-vba'

Tagged questions
0
answers

Opening excel in php on different servers

I have an excel file that stays on a server, for example: \192.168.0.1\arquivos\teste.csv And I have an Apache server on another server, for example: \192.168.0.2\www\index.php I want the apache server to put a button to open the file...
asked by 06.12.2018 / 19:12
1
answer

Limit FormulaArray

Range("B11").Select Dim Rmts As String Dim Busca As String Rmts = "C:\Users\Treinamento\Desktop\Trabalho em vba\BC\[Relacionamentos.xlsx]Matriz_Trein_Obrigatórios" Busca = "'!R8C6:R394C34=Busca!R8C2,ROW('" Range("B11:B450").FormulaArray = _ "=I...
asked by 20.09.2018 / 07:20
0
answers

Iterate XML with VBA and pass data to cells

I am now starting to mess with VBA and I have the following problem: I was able to make a code that makes a SOAP request for a webservice and returns me an XML with the electronic point marking data of a person. So far the code works quietly....
asked by 17.07.2018 / 23:36
0
answers

Questions about objects in Excel vba

I'm working with vba now, but it's a language I had little contact with at the undergraduate level, I'd like to ask some questions. When a macro in an excel file calls another excel file that also has macro that was closed there is no error,...
asked by 20.06.2018 / 18:13
1
answer

Consolidate data from multiple tabs into one (same workbook)

I have 18 worksheets (tabs) with user data and I need to copy and paste the data into another worksheet (tab) in the consolidated name. I need to copy the header only from the first worksheet and at the end remove the empty lines. It's all in...
asked by 15.06.2018 / 00:12
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
0
answers

Check network connection with Excel VBA

I have a macro that saves three sheets of a PDF file to the network. Loops and checks which worksheets will save to PDF, and saves correctly. The macro hangs or gives error when the network is bad or it has fallen, needing to use the ESC key....
asked by 24.04.2018 / 14:02
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