81 expert-verified Q&A posts in this category, sourced from the top-voted answers on Stack Overflow.
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…
I have a legacy application developed in VBA/Excel which uses ListView controls. Unfortunately, it looks like these controls can't be used with 64-bit versions…