Using Excel VBA Macro To Capture + Save Screenshot of Specific Area In Same File?

I'm trying to create a macro which uses an ActiveX control button (click) to take a screenshot of my desktop screen ...

Code to loop through all records in MS Access?

I need a code to loop through all the records in a table so I can extract some data. In addition to this, is it also...

Find Column Header By Name And Select All Data Below Column Header (Excel-VBA)?

This is my first post... I'm attempting to create a macro to do the following: Search a spreadsheet column header...

How can VBA connect to MySQL database in Excel??

Dim oConn As ADODB.Connection Private Sub ConnectDB() Set oConn = New ADODB.Connection Dim str As String str = "DRIV...

Control Break out of Infinite Loop In 2010 (2013) Excel VBA?

If I write code creating an infinite loop, with my new Excel, the Ctrl + Break no longer works. Neither does the Esc...

How can I generate GUIDs in Excel??

I have an excel file with one order on each row, and I want each order to have a unique identifier, so there will be...

Connect to web service in MS Access with VBA?

Is it possible to connect to a web service (for example send a HTTP Request) via VBA in Microsoft Access? For exampl...

Disable/Enable button in Excel/VBA?

I'm trying the following function in VBA/Excel: Sub function_name() button.enabled=false Call Long_Function ...

How to run SAP GUI script from Excel Macro?

I am trying to create a Excel macro which executes the SAP GUI Script. I already created the SAP script but I didn't...

When opening a RecordSet in Access VBA, if the type is dbOpenSnapshot, does it make the option dbReadOnly redundant??

In Access VBA, when opening a recordset as a snapshot, does it make the read-only option redundant? At first thought...

How to hide button control in VBA?

Is there anybody out here still programming VBA? I'm trying to get this code to work Private Sub button3_click() ...

How can I calculate deciles with a range of 12,000 cells in excel??

I have a column of 12,000+ numbers, both positive and negative, sorted from highest to lowest in an Excel spreadshee...

Getting AD Details based on username?

I have a code to retrieve the details of a user from the AD such as email address, phone number etc, etc. The codes ...

How can I use Outlook to send email to multiple recipients in Excel VBA?

I am trying to set up several buttons on an Excel form to email different groups of people. I made several ranges of...