We have an Excel 2016 quoting tool that uses VBA code to compare the product codes entered against an Access database and then update another sheet with the det
I need to encrypt SSN (nvarchar(25)) field in a SQL Server database table. Once encrypted, the Access program needs to be able to decrypt the field for user vi
I was just wondering: It is possible to create a click button in VBA Excel that opens the VBA editor when the button is clicked? UPDATE: The p
I am trying to simultaneously read from one sheet and print to another sheet, with additional format. I think my issue has to do with improperly referencing the
I have Outlook 365. I have multiple POP and IMAP accounts. During Send/Receive, I have a rule-script that needs to know which of the accounts is currently being
I am looking to send meeting invitations for each row in a worksheet. I am able to create an item that when displayed shows as an appointment, not a meeting re
I am new to macros and am having trouble creating a macro that will copy a range of cells and then paste just the values back into the same cells. Basically I
I have some code to keep my inbox clean. Process: Manually mall mails from outbox to inbox. Now I have all mails to be archived in inbox. Run code. When I had a
I don't really know VBA but have had some success with manipulating code in the past. I'm getting stuck with this one, where I tried to mix 2 different ideas in
There are options to get a contact detail from Mail id or Contact's Name using Namespace.CreateRecipient / Recipient.Resolve Is there any option to perform a d
I am looking for some pointers for a VBA code for Outlook. Specifically, run this code to clean up my inbox. We manually create a new folder each time we get a
I have now twice had this error, where I email a spreadsheet with macros to another person. It is working when I send it using share via email. When they get
The MS Word document has the ability to mark tags at the file level, which can be used from Windows Explorer to make it easier to search for files by document&r
Microsoft has web pages showing the local prices for Windows in over 200 countries. For each country, there are separate web pages for Windows Pro, Windows Home
I have a workbook that is about 8mb with about 20 different API calls (via formula in cells) using a 3rd party service. Everytime I try to close the workbook,
I have a spreadsheet that many people need to access (on sharepoint), for a few reasons, we need to do this locally (synced). however, there are constantly prob
I currently have the following code, which was made by a lovely member here Sub YearsNumberReduction() Dim LastCol As Long Dim DelCnt As Integer DelCnt = Sheet
How can I make the second set of code reference the selection made in the first set, instead of the hard coded location it currently uses? these two sets do exa
I've been learning all the nifty tools I have to debug in the VBA editor for excel, but I can't figure out if there's a way to have watches st
I have a macro that can send multiple mails with attachments to an specific user, this had no problem when I sent 1 file to 1 user, but I modified it so it loop