I have found code to search a table and load cell values into the form. I need to be able to make changes and save the form data back to the table to update th
sFile = Dir(sPath & sFile) Debug.Print sFile 2022.txt is returned if sFile (the active cell) contains 2022.txt; how can I return the same if sFile contains
I am using the Update query inside VBA to Update one particular column. But I am getting the Data Mismatch in criteria expression error. Please find below the c
I am trying to compile my code but every time I get the same error: Syntax error (missing operator ) in query expression ' True Status.Subsystem Not LIKE '''
I am trying to create a timer that when reaching zero, it calls from the "Database" script, and then repeats the timer again from 30 seconds. Problem is, every
I have data on sheet A and want to duplicate it on sheet B. Because it is a lot of data, I do not want to use copy-paste. If I really simplify it, this is my co
I'm trying to run the following code, but I'm getting a runtime error 6: overflow for the last calculation that I am trying to do. The program stops when it rea
This should be a simple task and I've been coding in VBA for 10+ years but I cannot seem to get this to work. I have a UserForm with a MultiPage (with 2 pages)
I have a need to pass strings back forth from a python script to a VBA application running in MS Access. Communication from VBA to Python works great! Communica
I have coded a VBA macro that notifies me whenever a new comment has been added to a document using a MsgBox. I now require that no notification should be in th
Could you please help on the below code. I have 2 workbooks and i want to copy the columns from one to another with the matching header. It shows an error in th
So I am trying to calculate a test temp for 1hr from the last 12 hours of data. Sometimes this data can be several days some times it can be only 24hrs. The sta
I am working in VBA, and I need to set the .Interior property of a Range object, to the value of its own .DisplayFormat.Interior. More generally, I want to pas
I'm trying to find a native Excel function (or combination thereof) which will behave precisely in the manner of COUNTIF (i.e will handle wildcards), but is cas
So we are trying to create some ppt report based on excell data. I'd like for the first slide to have a background image or just an image that is set behind the
Very specific question. I got a task to learn vba, but i cant really find anything for my problem. screenshot of how it looks in project Basically if the column
I'm trying to make an Excel VBA macro to automate my saves. So if it is 2022 or 2023 and it is either the month of January, February, march, etc. The file will
I have 20 cases. For every row in my sheet, I have a cell that assigns related case numbers to it. A row could have multiple case numbers assigned to it in that
I was writing a simple script in VBA for batch updating project info posted on Project Web App. I've stumbled on a problem which seems unsolvable to me though,
iam gettin an error while running below code, i want to apply pivot table to dynamic data range ( data gets change everytime i.e rows and columns) i want macro