Posts by Paulo Semblano • 85 points
13 posts
-
1
votes1
answer574
viewsQ: Reset a dynamic array - Redeem or Erase?
I have a UserForm with three OptionButton and three ListBox. When opening the UserForm all three ListBox are loaded with different texts, because each one relates to a type of data as is explicit in…
-
0
votes0
answers115
viewsQ: Web Scraping on Infomoney page
I have the code below that accesses the Infomoney page and selects the All option from the button to return all results. The problem is that it only selects, but does not click to return all…
-
1
votes1
answer287
viewsQ: Excel x Web Scraping - FIPE table giving error
The code below works perfect to return data by Excel with Web Scraping. I installed in the file the module VBA-JSON-2.3.1 - module name Jsonconverter.bas. I enabled the Microsoft Scripting Runtime…
-
1
votes0
answers45
viewsQ: Web Scraping with error
I have the code below that is wrong on this line: Set JSON = JsonConverter.ParseJson(response) Below is the complete code. Option Explicit Sub GetCompanyInformation() Dim hReq As Object, JSON As…
-
1
votes0
answers67
viewsQ: Excel VBA on MAC
Good night! I use a lot of Excel VBA on a PC computer. The VBA used in Excel for MAC is the same?
-
0
votes1
answer4320
viewsA: Power BI - FILTER CUMULATIVE VALUE WITH SEVERAL CRITERIA
I grouped in Power Query by date as image. It’s better this way. Only the accumulated per line is missing according to each product.…
powerbianswered Paulo Semblano 85 -
-1
votes1
answer4320
viewsQ: Power BI - FILTER CUMULATIVE VALUE WITH SEVERAL CRITERIA
I have a stock database with four columns: Date - Product - Entries - Sales. 1) The 1st column contains the dates, all of them always with the 1st day of the month and year: 01/01/2010 - 01/02/2010.…
powerbiasked Paulo Semblano 85 -
0
votes1
answer114
viewsQ: Screenupdating x On Error Goto Errorhandler
With the code below: Application.ScreenUpdating = False Application.EnableCancelKey = xlDisabled On Error GoTo ErrorHandler 'Código Exit Sub ErrorHandler:Application.ScreenUpdating = True 'Código…
-
0
votes0
answers72
viewsQ: Excel VBA - strange behavior!
Strange behavior in VBA Excel! The code opens a source file, and copies an existing table. Pastes the Table into a target file - in the SUPPORT sheet - and closes the source file. In the destination…
-
1
votes1
answer54
viewsQ: Access - saving data
I have the VBA code below that saves a new release. When Close the Form, even if I have entered any name, it is not saved. But I noticed that Access automatically generates a new primary key, ie…
-
0
votes1
answer48
viewsQ: Reset Page every click
Have in the figure above this small Userform with three pages. On the first page, when clicking the Enable button, the next date is inserted with Textbox Data as False, so that the user does not…
-
1
votes1
answer497
viewsQ: Excel and SQL - Connection between Excel file
I have the code on (end) that I picked up on the internet. This line of code gives error in WHERE, because it is a text: strSQL = " SELECT [VENDAS$].[Data], [VENDAS$].[Vendedor], [VENDAS$].[Total]"…
-
1
votes0
answers1135
viewsQ: Check network connection with Excel VBA
I have a macro that saves on the network three spreadsheets of a PDF file. Loop and verify which spreadsheets will be saved in PDF, and save correctly. Macro hangs or gives error when network is bad…
excel-vbaasked Paulo Semblano 85