- Add Date Header and Page Number Footer - VBA
- Add Keyboard Shortcut to Custom Ribbon - OfficeUI
- Add String with Quotes in VBA
- Assign Keyboard Shortcuts to Macros via Macro in VBA
- Calling Batch file or CMD via VBA
- Certificate Signing of VBA Macro's/Projects
- Check if Directory Exists and If Not Create It - VBA
- Check if Variable is NULL - VBA
- Check or Add Reference Library - VBA
- Check Variable for Special Characters - VBA
- Compile Error: Expected variable or procedure, not module - Macros - Microsoft Office
- Copy Text to ClipBoard - Macro
- Copy to Clipboard via VBA
- Create Input Box with Default Setting - Office VBA
- Creating an Update MsgBox that only runs once with VBA
- Date Variables - VBA
- Declaring Function for Different Versions of Microsoft Office - 32 vs 64 - 2007 vs 2010
- Decode or Encode URLs via VBA
- Delete File VBA
- Display Variable in MsgBox - VBA
- Error: DataObject:GetText Invalid FORMATETC structure - Clipboard Gets Cleared During Macro Execution - VBA
- Folder Picker - VBA
- Forcing or Changing Value to Capital Letters in VBA
- Global Variables in VBA
- Input Box - VBA
- Install Font via VBA Without Admin Privileges
- Method 'Run' of object IWshShell3 failed - VBA
- Microsoft Excel - VBA
- ActiveSheet Name - Excel VBA
- Advanced Filter - Excel VBA - Unique Values
- Apply Conditional Formatting - Excel VBA
- Arrays - VBA
- AutoFilter - Excel VBA
- Autofit All Worksheets - Excel VBA
- BarCodes - Excel VBA
- Call Sub from Seperate Excel Add-In - VBA
- Check if Cell in Range - Excel VBA
- Check if Cell IsEmpty with VBA
- Check if Column Has Header by Comparing A1 to A2 - Excel VBA
- Check if Integer is Even or Odd via Function - Excel VBA
- Check if Range Is Empty - VBA
- Check if Value is Numeric - Excel VBA
- Check if Worksheet is Protected by PWD via VBA - Excel
- Check if Worksheet Is Protected - Excel VBA
- Class Modules - Excel VBA
- Close Open Workbook in Excel VBA
- Close Open Workbook via Batch - WindowTitle
- Collections - VBA
- Combine Two Columns - Excel VBA
- Compare Two Columns - Excel VBA
- Convert ActiveCell or Range to Column Letter in Variable - Excel VBA
- Convert Column Number to Letter - Excel VBA
- Copy Data from External Excel Instance - Worksheet to "ThisWorkbook"
- Copy Range - VBA
- Copy Rows and Columns - Excel VBA
- Copy Text to ClipBoard - Excel VBA
- Declaring WorkSheet and WorkBook - Excel VBA
- Delete Multiple Columns Simultaneously - Excel VBA
- Delete Rows in Excel VBA
- Dictionaries - Dictionary - Excel VBA
- Disable warning: You copied a large amount of data onto the clipboard - Excel VBA
- Excel DisplayAlerts - VBA
- Excel VBA Color Index
- Excel VBA - Font and Borders Settings Etc
- Excel VBA to use all filled cells in columns
- Extract Alpha or Numeric Portion of String - Excel VBA
- Filter Worksheet - Table - Query - Excel VBA
- Find ActiveCells Column Header
- Find Duplicates and Copy to New Sheet - Excel VBA
- Finding Last Used Column or Row
- Find Oldest and Newest Dates in Rng - Excel VBA
- Find or Delete Column Letter from Header Name Function - Excel VBA
- Find String in Range - Excel VBA Function
- Find Worksheet by Partial Name - For Each Worksheet - Compare Dates - Excel VBA
- For Each Cell in Range of Cells - VBA
- Format Integer to X Places with leading 0's
- Formatting Cells - Excel VBA
- Freeze Header Row - Column - Excel VBA
- Full Download Spreadsheet via IE - Save - Open - Copy - Close and Delete File - VBA Macro
- Function to Check if Sheet Exists - VBA
- Function to Check if Two Ranges are the Same Range - Excel VBA
- Get Column Letter from ActiveCell via Sub - Excel VBA
- Get Total Lines of Code in Macro Workbook - VBA Excel
- Have Macro run on Workbook Open - Excel VBA
- Hyperlinks - Excel VBA
- Import CSV - Excel VBA
- Insert Row or Column - Shift - Excel VBA
- Insert Value into cell near selected cell - Excel VBA
- InSTR - Excel VBA
- List Files in Folder without Extension - Excel VBA
- Merge and UnMerge cells - Excel VBA
- Move Columns via VBA
- Number From String or String from Number - VBA
- Pass Range as Variable to Sub with Rng Argument - VBA
- Pivot Tables with VBA
- Check if Pivot Table Exists and Delete - VBA
- Collapsing Pivot Tables - Excel VBA
- Create Pivot Table Sub - Check if Exists and Delete
- Create Pivot Table with VBA
- Function to check if Pivot Table Exists - VBA
- Groups and Pivot Tables - Excel VBA
- Pivot Table Settings for Orientation and Function
- Sub to Delete Pivot Table - VBA - By Name - Sheet - Or All
- Print Headers on Each Page - Excel VBA
- Remove $ Cell.Address - VBA
- Remove Duplicate Rows - Excel VBA
- Run Excel Macro from Command Prompt with XLAM - VBA - VBScript
- Run Macro After or Before Query Refresh - Excel VBA
- Save New Workbook - VBA
- Screen Update VBA
- Screen Updating and Refresh - Excel VBA
- Select All Cells with Data - Excel VBA
- Send E-Mail from Excel with VBA
- Set Cell Font to Text White and Background Black - Excel VBA
- Set Range to Empty Space of Last Sheet to be Printed - hpagebreaks
- Setup Print Procedures in Excel VBA
- Sheets and Excel VBA
- Sort Range - Excel VBA
- Spell Check Protected Worksheet - Excel VBA
- Swap Columns - Excel VBA
- Test if Workbook is 97-2003 old xls format and upgrade
- Use Column Number in Range - Excel VBA
- Use MsgBox to diplay Range - VBA
- UserForms - Excel VBA
- User InputBox for Range - Excel VBA
- Use Row of Active Cell
- VBA Regex Search
- XLStart Locations
- Microsoft Outlook - VBA
- Automatically Open Outlook Attachment - VBA
- Automatically Save Attachments From Specific Sender or Domain in Outlook with VBA
- Create Outlook Event - VBA
- Distribute Outlook Macros - VBA
- Mark E-Mail As Read or UnRead in Outlook via VBA
- Monitor Inbox or Custom Folders in Outlook with VBA via ItemAdd Event
- Search Outlook Mail Subject or Body for String - VBA
- Send E-Mail via Outlook with VBA
- Microsoft Word - VBA
- Adding Serial Number or Incremental Number to Word Document at Print Time
- Close Word Document via VBA
- Copy Text from Microsoft Word to New Excel Workbook - VBA
- Create Simple Greeting Macro - Word - Microsoft Office
- Disable Small Margins Warning - Microsoft Office - Word - Macro
- Final - Before Print Macro
- Find Index Number of Current Table
- Run Macro Before Printing - Word - Microsoft Office
- Spell Check Protected Word Document - VBA
- Word.OfficeUI Location
- Working with Tables in Microsoft Word VBA
- Multi-Line MsgBox in VBA
- ObjArgs - VBA - For Each ObjArg - Named Args
- Open External Workbook and Copy Sheet to Active Workbook - Excel VBA
- Open Internet Explorer URL via VBA
- Open Sharepoint/Teams Excel Workbook via VBA
- RegexReplace Function
- Remove Non-ASCII Characters - VBA
- Save Document - Microsoft Office - Macro
- Search AKA Grep for String in Text File with VBA
- Search String for SubString via LEFT - VBA
- SendKeys - VBA
- Set Value everything after or before = Symbol - VBA
- Simple VBA Template
- Sleep - Wait - Delay - VBS
- Split String by NewLine in Array - VBA
- Use Windows Environment Variables like %APPDATA% in VBA
- Using "Case" Statements with VBA
- Using Dates with VBA
- Using Functions in VBA to get Result
- Using GoTo with VBA
- Using Shell in VBS VBScript
- VBA - 1 Hour From Current Time - DateAdd
- VBA Data Types
- Working With Files - VBA - Does File Exist - Write - Read - To Text File
- Yes or No Input Box - VBA
Welcome to FreeSoftwareServers Confluence Wiki
Overview
Content Tools