Forum Widgets
Latest Discussions
The EXCEL worksheet disappears
MACBOOK . Hi guys, when I was using excel today, because there were a lot of worksheets, I moved one of the worksheets out, thinking it was going to be a separate one, and the worksheet disappeared, and the back key didn't work. I was wondering how anyone could find the worksheet before it disappeared.
Extract image from http response and save it to local folder
Below excel macro code triggers provider to generate an image in .png format: Sub GetImg () Dim MyRequest As Object Set MyRequest = CreateObject("WinHttp.WinHttpRequest.5.1") MyRequest.Open "GET", _ "https://<provider addr>?text=<instruction for image>" ' Send Request. MyRequest.Send 'And we get this response with the .png image MsgBox MyRequest.ResponseText End Sub The image is there, content type is image/png. How can I extract it from the body and save the image to a local folder e.g. to the same folder where the .xlsm excel file is.Automatically record the value of one cell into a different cell each day
Each day I record the current value of my shares into cell B2 on Sheet1. Below, in B5, C5 etc I have all future dates for the next few years in 1 row. In cell C2 I have todays' date (=TODAY()). How can I automate excel to record the last value of cell B2 every day into a different cell under the dates. So far I've got =IF(B5=$C$2,$B$2,""). So, if false, I want to keep the last value of B2. Essentially a basic database that I can use to create an ongoing graph.
Utilizing Excel's turing capabilities to create Conway's 'Game of Life'
The Background It's been said with Lambda (and LET and a wealth of functions in 365) Excel has become 'turing-complete'. To quote the article linked below: "You can now, in principle, write any computation in the Excel formula language." https://www.microsoft.com/en-us/research/blog/lambda-the-ultimatae-excel-worksheet-function/ The Challenge I thought it would be fun to create Conway's 'Game of Life' in Excel 365 to see how far I could push things. Conway's Game of Life - Wikipedia The rules are simple: A 'cell' has up to 8 adjacent cells (less if the cell is on the edge of the board). A 'neighbor' is a cell with a 1 while a 'dead' cell is empty. An 18x18 board Multiple iterations Bigger boards! more (it's relaxing to create new shapes and designs) The Approach My first thought was to use MAKEARRAY because I could use 'r' and 'c' coordinates and there would be no stacking. I devised a recursive function that worked for 1 iteration but failed on subsequent iterations because the use of TAKE/DROP was slowly shrinking the board! The revised approach is essentialy a recursive MAP that uses 3 arrays: the input matrix, the 'r' array (row numbers) and the 'c' array (column numbers). It's my way of using r/c without using MAKEARRAY. For Discussion I welcome any improvements to the existing function and any different approaches someone may have to creating Conway's Game of Life. Conway Lambda follows: Conway =LAMBDA(matrix, iterations, IF( iterations = 0, matrix, Conway( LET( height, ROWS(matrix), width, COLUMNS(matrix), r_arr, SEQUENCE(height) * SEQUENCE(, width, 1, 0), c_arr, SEQUENCE(height, , 1, 0) * SEQUENCE(, width), CheckNeighbors, LAMBDA(lattice, r, c, LET( RCx, LAMBDA(row, col, IFERROR(CHOOSECOLS(CHOOSEROWS(matrix, row), col), 0) ), N, RCx(r - 1, c), NE, RCx(r - 1, c + 1), E, RCx(r, c + 1), SE, RCx(r + 1, c + 1), S, RCx(r + 1, c), SW, RCx(r + 1, c - 1), W, RCx(r, c - 1), NW, RCx(r - 1, c - 1), compass, VSTACK(N, NE, E, SE, S, SW, W, NW), neighbors, SUM(compass), IF( AND(lattice = 0, neighbors = 3), 1, IF( AND(lattice = 1, OR(neighbors = 2, neighbors = 3)), 1, 0 ) ) ) ), MAP(matrix, r_arr, c_arr, CheckNeighbors) ), iterations - 1 ) ) )
Date_in_VBA
Is there a way I can save date so that the date does not come across a number. I have =today() which gives me the days date. For example, if I save 4/9/2025. The document returns with "nameofdocument"45766. I want it to save the document as "nameofdocument"4/9/2025(the actual date the document is created. Is this possible?
