<p>General-purpose VBA techniques spanning the Office suite.</p>
I am trying to use FileSystemObject methods to find a specific line in a text file, and within that line replace a specific string.…
I have a userform in Excel that asks for a username and password. Once you enter your password if you press Enter it just…
I need to format these dates into yyyy/mm/dd to query a MySQL database - looking at these two statements, you'd think they would produce…
I'm trying to fetch data from this site using VBA in Excel. What I tried to do and what worked was using InternetExplorer object…
I have worked in Python earlier where it is really smooth to have a dictionary of lists (i.e. one key corresponds to a list…
I'm writing a conditional statement in vba like if(userID = 1 or userID = 2 or userID = 3 or userID = 4) then…
If I type the following into the immediate window I get Runtime error '6': Overflow. MsgBox 24 * 60 * 60 Why is this?…
Does anyone out there know how to do a stack trace in access-vba. I'm trying to do something like: Public Sub a() Call c…
I am working on an VBA program which would allow the user to type an address and find the location by matching elements of…
Currently I have a document system that launches documents in Star Office or LibreOffice in an iframe. Moving to the future I ideally want…