Excel VBA: Can my VBA code determine whether Solver is running?
Is there a way to test whether Solver is running? I have a section of VBA code that must be skipped if Solver is running. I'm using MS Office LTSC Professional Plus 2024 (Windows).
Developer technologies | VB
Validating user's input format is not working
Our requirement is to ask users to create a password with the following format: First letter of firstname+First letter of lastname+2 digits of month+2 digits of day+4 digits of year. For instance, a user with the name of John Doe, born January 1, 1900…
Developer technologies | VB
Developer technologies | ASP.NET | Other
Access database set Default Value of a short text field of another short text field
Hi there I have an access database with a short text field called TM Description. I have created another short text field called BrandingDescription that I want to set the Default Value to the text entered in TM Description, ie the two fields would show…
Developer technologies | VB
WebRequest Migration to HTTPClient - Needing Feedback to Calling Function
Hello.. I have some code migrating from VS Studio 2013 to VS Studio 2022. Seeing that WebReq has been deprecated. Working to migrate to HTTPClient. Seems that httpclient is async only, I am guessing here... My overall code is written to call a RoboCall…
Developer technologies | VB
VBA oledb open connection became slow
In my VBA project the opening of the OLEDB-connection has become really slow. (In the past it worked fast but since some months it has become slow.) It takes 13 seconds to just open the connection. I have tried this with only this coding in my project…
Developer technologies | VB
Windows Shutdown
I have a small app written in .NET 9, VB. The app does use an xml data file. When shutting down the computer, this app prevents windows from shutting down to allow user to save work. This is despite the fact that NO data saving is required at the time…
Developer technologies | VB
I'd like to know how VB.NET handles cookies
I maintain an old VB.NET WebForms app. I'm converting it to C# and updating it. However, when it comes to converting how the old app handled browser cookies and how to make the same thing work in a C# Blazor app, I am not sure how to proceed. Here's a…
Developer technologies | VB
Update tables linked in Access using VB.NET
I have an Access DB that has linked tables to other access DBs and links to Excel spreadsheets. I would like to scan the links, using vb.net, and validate that they are pointing to the current location of the files. If not I want to change the link…
Microsoft 365 and Office | Access | Development

Developer technologies | VB
How to insert two or more different values under one column name based on parent PK?
Greetings experts, We are designing internal ballot system that will be used to elect members into various positions based on election types.
Developer technologies | VB
What can I do with white space in the connection string?
I wrote a small application in VB.NET (VS 2022), and it worked well with the connection string without white space. When I put it in the folder with spaces and that is where I have issues with it. How do I solve this issue with the white space? I do…
Developer technologies | VB
Value cannot be null. Parameter name: format visual studio 2022
I can create new and work in projects, I can save them and send them to my instructor and they can open them, but whenever I try to open one of my own projects again I get this: at System.String.FormatHelper(IFormatProvider provider, String format,…
Developer technologies | VB
Request for Assistance with App Service Performance – High Time in ManagedPipelineHandler
Experiencing performance issues with an Azure App Service. Analysis revealed 4 slow request(s) where the module consuming the most time is: ManagedPipelineHandler (57.1%) The diagnostic message indicates: "To troubleshoot performance issues or to…
Developer technologies | VB

VBA: Copy and Paste with a TextBox do not work on Mac
VBA for Word; but there is no coding involved. Create a UserForm. Add a TextBox. Run it. On Windows - you can Copy and Paste to/from the TextBox - vs the Clipboard. On MacOS - you cannot. (at least, it never worked for me - please post if it works for…
Developer technologies | VB
Get free/used size of a whole disk
Hi On systems with multiple HDD/SSD disks, I need to get the total size and free or used size of the disk which system drive is in. Using MySearcher As New ManagementObjectSearcher("root\Microsoft\Windows\Storage", "SELECT * FROM…
Developer technologies | VB
When creating an Outlook email through VBA in Excel, this now results in error 287; more specifically on getting a string value from .HTMLbody. This problem now appears when we moved to the 365 version. Any thoughts?
The goal is to create an email, using the contents of an Excel sheet. The email should contain the Outlook signature (text and pictures) of the user that is working with the Excel sheet at that time (that can vary). So first the signature is supposed to…
Developer technologies | VB
VBA vs OneDrive: is it possible to use "Copy Link"s to work with files/folders?
VBA Word "Documents.Open" and "Document.SaveAs2" works with local files; but when OneDrive is present - they can also work with network path,…
Developer technologies | VB
VBA: Saving Excel file does not work on Mac, if the destination is in local OneDrive folder
Summary: writing Excel workbook fails, if the destination is under OneDrive, only on Mac, and only if the destination file does not already exist. I have a test routine that reads and writes Excel files (see the end of the post). The source and…
Developer technologies | VB
VBA: Word Application.WindowSize event does not work on Mac
I have implemented Word Application.WindowSize event, according to…
Developer technologies | VB
Can we get Visual basic 6.0 download for the product itself ?
We have couple of visual basic 6.0 applications being used in our organization. Is the download of Visual basic 6.0 still available ?
Developer technologies | VB

Get-StorageReliabilityCounter equivalent
Hi, These ps commands work fine, but I'm trying to get the StorageReliabilityCounter values in WinForms, and there's not a single working sample out there, do I need both MSFT_Disk and MSFT_DiskToStorageReliabilityCounter classes? If so, how to connect…