1,533 questions with Developer technologies | Visual Basic for Applications tags
Personal Email
I am not receiving any emails to my personal account since I added my Gmail account to my Authenticator the message saying it’s not responding
Developer technologies | Visual Basic for Applications
Excel Macro
Since the file is a .xlsm (macro-enabled workbook), corrupted macros or external connections might be contributing to the issue. Go to: Developer → Visual Basic to inspect the macros. Data → Queries & Connections to check for broken external…
Developer technologies | Visual Basic for Applications
How can we configure External Authenticator with Keycloak
Hi Team We need to configure external Authenticator with keycloak. I need guidence for that Thanks,
Developer technologies | Visual Basic for Applications
VBA with MS Access Reports
"Me.TextZone = some value" is not allowed with a report, I want be able to use and change controls.
Developer technologies | Visual Basic for Applications
Bginfo and vbscript deprecation
Hi, Back in May 2024 Microsoft announced Vbscript (https://techcommunity.microsoft.com/blog/windows-itpro-blog/vbscript-deprecation-timelines-and-next-steps/4148301) will be deprecated with it moving to disabled by default in Features On Demand (FoD)…
Developer technologies | Visual Basic for Applications

What is the solution to getting oledbconnection properties
Developer technologies | Visual Basic for Applications
VBA with MS Access Reports
Pourquoi un formulaire d'une page A4 s'imprime étalé sur 10 pages ?
Developer technologies | Visual Basic for Applications
TransferDatabase help
I have a MS Database that when I close the database, I want to export the main data table to a back-up database. Here is my VBA script - destfilename = "PGA Matrix 6-2022 - REP VERSION.mdb" destfileloc =…
Microsoft 365 and Office | Access | Development

Developer technologies | Visual Basic for Applications
How do i permanently remove a module in vbaproject?
I've turned on developer option on the powerpoint. I've enabled VBA. The vba code is flawed, and i tried to remove and delete the module. However, it is still an apparent problem, and i have no way of fixing this issue.
Developer technologies | Visual Basic for Applications
Excel VBA compiles with no problem, but generates a type mismatch error when run.
Hello, I have an Excel VBA macro that is supposed to create, from a print area in a worksheet a PDF file, then save AND email it as an attachment when clicking on a button in the worksheet. No errors upon compiling and a PDF is created and saved;…
Developer technologies | Visual Basic for Applications
VBA Features Not Working After Recent MS Update
We are running the desktop version of Excel through Office 365. After the most recent Microsoft update (within the last few days) we have a file that is very VBA-dependent. Nothing has changed with the file itself (name, content, VBA, storage location,…
Developer technologies | Visual Basic for Applications
Workbook.Close method causes error/crash in Excel Version 2506 (Build 18925.20216)
Hello, I’m encountering errors when using the VBA method Workbook.Close in Excel. Environment: Microsoft Excel for Microsoft 365 Version: 2506 Build: 18925.20216 (Monthly Enterprise Channel) Issue: When I run VBA code to close a workbook (e.g.,…
Developer technologies | Visual Basic for Applications
refedit control button missing
I am looking to add a control which can take a range as input. I found out that refedit control allows to do exactly theat. However the refedit control button used in Excel VBA Forms is missing. I have turned on the Ref edit control from the preferences…
Developer technologies | Visual Basic for Applications
Declare Function not working in Access VBA
Declare Function not working in Access VBA. Getting an error message when compiling
Developer technologies | Visual Basic for Applications
vba excel broken reference autofix
there is a problem for example every autocad version has deferent tlb file name in the same path (example acax20enu.tlb or acax23enu.tlb or acax24enu.tlb) i wrote this code but it didn't work i see nothing wrong it should work after adding reference to…
Developer technologies | Visual Basic for Applications
DLL file not found when invoking function from Excel/VBA
I'm running Windows 11 with 64-bit MS/Office 2021. I have a very large (>25KSLOC) Excel/VBA application with a helper DLL written in C and compiled by Visual Studio 2022. The last time I used the app was May 4, 2025, and it worked perfectly. Today,…
Developer technologies | Visual Basic for Applications
Why not remaking a certified exams for vb.net language?
Just because it's one of the easier languages to learn, I think Microsoft should bring back the vb.net certification exams.
Developer technologies | Visual Basic for Applications
Power Query memory increasing when data connections refreshed simultaneously (manually or via VBA)
Hello all, I've been coming across an issue using Power Query in Excel 365 (Enterprise E3, both 32 and 64 bit version). I have 4 Power Query data connections using an API query to retrieve JSON data automatically every 10 seconds, transform into…
Developer technologies | Visual Basic for Applications
Community Center | Not monitored
Debugging VBA
I am a beginner in VBA programming, I am writing a function to retrieve the cell value from another file. However, I made a lot of attempts but still cannot get it work. May I know where can I get assistance?
Developer technologies | Visual Basic for Applications
VBA macro to file sent mails
I am using since many years a macro which executes when I send a mail and asks me, in which folder I want to store this sent mail (instead of leaving it in the "sent mail folder"). This macro is: Private Sub Application_ItemSend(ByVal Item As…