JsonConverter question
VBA Express Forum » Excel Help
by xyz987
4h ago
Hi sirs i want to catch data from "https://www.twse.com.tw/rwd/zh/afterTrading/MI_INDEX?date=20240327&type=ALLBUT0999&response=json&_=1711564048882" i try to use JsonConverte, but it show run-time error "450", but i check ResponseText correct. what mistake in this case ?? code like list, thanks Sub FetchAndParseData_1() Dim xhr As Object Dim URl As String Dim response As String Dim json As Object Dim tables As Object Dim data As Object URl = "https://www.twse.com.tw/rwd/zh/afterTrading/MI_INDEX?date=20240327&type=ALLBUT0999&response=json&_=1711564048882" Set xhr ..read more
Visit website
Extract and Copy Data from an Array to a Cell with Criteria
VBA Express Forum » Excel Help
by JUES
4h ago
Dear friends, I hope you are well. prueba.xlsm What function or combination of functions should you use to be able to extract solely and exclusively those Data contained in the Ranges Índice "A" (MATRIZ2!$L$2:$L$2138), Índice "B" (MATRIZ2!$M$2: $M $2138 ), Índice "C" (MATRIZ2!$N$2:$N$2138) and Índice "D" (MATRIZ2!$O$2:$O$2138) of Sheet 4 (MATRIZ2) that meet the Year Criteria (MATRIZ2 !$ B$2:$B$2138;$H$6) and Month (MATRIZ2!$C$2:$C$2138;D$10) whose results can then be automatically copied to Sheet 10 (INDICES): INDICE A - 2000 = D$11 Up to O$11 INDICE B - 2000 = D$18 Up to O$18 INDICE C - 200 ..read more
Visit website
VBA Date Filtering Issue
VBA Express Forum » Excel Help
by telobamipada
4d ago
I am using the below vba code to filter a spreadsheet on open to show the current month and all future dates and I can't for the life of me get it to show null values... where the date isn't populated. Any help would be appreciated! Private Sub Workbook_Open() Sheets("Sheet1").Select 'startdate as date Dim startDate As Date 'startdate as long for excel Dim lstartDate As Long 'get start date, day = always 1 startDate = DateSerial(Year(Now), Month(Now), 1) lstartDate = startDate 'filter everything before current month 'you see this month + future ActiveSheet.Range("A1").AutoFilter Field:=6, Cri ..read more
Visit website
Turn Excel Object Broswer into a 4-column long list, in Excel
VBA Express Forum » Excel Help
by Romulus
5d ago
Hello All, I need an Excel macro that will loop through following object libraries: Excel, Office, stdole, and VBA, then for each library will loop through all object Classes, on each class it will loop through all class members and create a table having following 4 columns: Library, Class, Member and Type, where type can be Function, Constant, Sub, Property, Enum, etc. Table must start from cell A1 of the Sheet1 tab. I suppose I need to activate/tick first Microsoft Visual Basic for Applications Extensibility 5.3. I expect the list will contain thousands of rows, maybe more. This would b ..read more
Visit website
Multiple chart combined into one
VBA Express Forum » Excel Help
by Aussiebear
5d ago
Rather than visually clog up a worksheet with multiple charts, is it possible for one chart to reflect different sets of data depending on the selection made from a Data Validation cell? In the attached workbook "Varroa 2.xlsx" Im trying to show the different temperature bands that each of the chemicals may be safely used in, compared to the actual day by day temperatures recorded. In these charts provided (one for Formic Pro, the other ApiGuard), they share the same common Dates and Actual Max & Min temps, but differ with regards to the safe temp bands. Formic Pro uses Columns D:E whilst ..read more
Visit website
Plausibility check via VBA
VBA Express Forum » Excel Help
by Jean-pierre
5d ago
Hello everyone, thank you in advance for your support! What should the vba code look like if I want to do an automatic data check for the file (see attachment) and output the result as a message box? Basically, all three sheets should be checked and if errors are found, the names of the sheets + coordinates of the respective cells should be output in the message box. The following rule applies to all sheets: if a value is missing in columns A,B,C (as in the Volume sheet), then this is an error The following rule applies to the Sales/Volume sheet: All values ​​in columns D-O must be posit ..read more
Visit website
Renaming File Name
VBA Express Forum » Excel Help
by buvanamali
5d ago
Dear Experts Now I request for 3 more requirements. 1) The value whatever I type in K11 shall be appended to (Filelist) sheet "C" Column. 2) If the file name repeated in Col C then Filename 1 , Filename 2 , File Name 3 likewise renamed 3) If I put delete in C Col, while renaming the files, delete row should delete images in the folder. Yours Sincerely Buvanamali ..read more
Visit website
Offset value as ".Text" use
VBA Express Forum » Excel Help
by Aussiebear
6d ago
The following code was provided as a solution to this issue. Quote: Ideally what I would like is to look at column D and if it is not blank "" then look at column J and take the first 5 digits and put them into column O Code: Sub Test() Dim c As Range With Sheets("Sheet1")  'amend as appropriate     For Each c In .Range("D2:D" & .Cells(Rows.Count, "D").End(xlUp).Row) 'assumed header in row 1         If Not IsEmpty(c.Value) Then             c.Offset(, 11).Value = Left$(c.Offset(, 6).Text, 5)         End ..read more
Visit website
Update cell value for all files in a folder
VBA Express Forum » Excel Help
by MathiasDW87
1w ago
I'm trying to find a VBA code to update one specific cell (B14) in the first sheet for all files in a folder. The macro should update this cell B14 with the value in cell H1 in my macro file. The folder path, where all files are located that should be updated, is in cell B4. So shortly, cell H1 from my macro file should be copied to cell B4 for all files in a folder ..read more
Visit website
Excel Image Viewer and Rename its File Name
VBA Express Forum » Excel Help
by buvanamali
1w ago
Dear Experts I would like to view image in Excel and rename the current file name. In excel I can’t view the file in full size. Please help me to view the image in full size. Also please put an DELETE button to remove the image in the folder. Attached herewith the fotos folder and the excel file for your kind perusal. Thanking you in advance. Yours sincerely Buvanamali p.s. I had already posted here. But no response. https://www.excelforum.com/excel-pro...file-name.html Attached Files Fotos.zip (772.1 KB) Sample File.xlsb (1.14 MB ..read more
Visit website

Follow VBA Express Forum » Excel Help on FeedSpot

Continue with Google
Continue with Apple
OR