I have JSON data string from which I try to extract the highest value of "id" without iterating. This is the JSON data string: "ball_coordinates": [ { "id": 3938706, "fixture_id": 18795544, "period_id": 4644037, "timer": "17:20", "x": "106", "y": "57" },…
the guy from the Baptism database is here again. In Visual Studio it's easy but here I don't get it done. I have form with two textboxes: login and password. I have a button to check the info Both must…
Thank you for taking the time to read this. I am trying to use the LIKE operator to open workbooks. Previously I went with this code which works really well Report_Name = "XYZ.xls" Workbooks.open Filename:= ThisWorkbook.Path & Report_Name My main…
I want to upload a photo from my local machine (e.g. a jpg) to a Facebook page I am the admin on, using the Facebook Graph API (using Access VBA). I can post an image that is on the internet…
I need help in working with big Excel Tables. Description I have an export of Data from our ERP System that has 400K Rows at least. In this report the format is quite messed up and I want to write…
I have issue with filling up recordset. I stored this query into txt file: DROP TABLE IF EXISTS "temp_invoice_id_amount_1"; CREATE TEMPORARY TABLE "temp_invoice_id_amount_1" AS SELECT ROW_NUMBER() OVER() "RN", c."ID" "CaseID", p."ID" "PackageID", trim(concat(d."LastName", ' ', d."FirstName")) "FullName", c."ContragentCaseID", i."ID" "InvoiceID",…
Assumptions The EventLists sheet contains a list of events by day of the week and start time. The Master sheet contains a list of events by date. The Master sheet contains only one month's data. The Master sheet is sorted…
I have two excel files, one is an export from Shopify with all the data of my products. The other is a list of barcodes and quantities that are available from the supplier. I want to be able to modify…
I have a page with too much Javascript and there is a search box where I would like to use SendKeys to put some text. The search box id is ctl00_ContentPlaceHolder1_txtSearch but when trying to use it directly, I encountered…
I am looking for a way of protecting the workbooks with VBA code. The case is: the student downloads a spreadsheet from a website (WooCommerce) and is able to run it on only one computer with no possibility to send…