- Insert Data in Closed Excel File
- Highlight Cells with Formulas
- Hide Titlebar for Userform
- Get Hard Disk Number from VBA
- Get Google result in Excel Sheet
- Remove Blank Line from VBA Project
- Get all Printer Detail
- Get the Latest Data from SQL Query
- Get File Name and File Path from full Address
- Get Existing Open Internet Explorer
- Get All Macro Detail (Name and Lines)
- Find All Reference used in the VBA Project
- Find Computer information
- Create the folder if not Exist
- Fit Image or Pictures to Cell
- Find Userform Control Type useful Theme
- Find specific File in all Folder
- Get Sheet Size information
- Find first and the last cell of string in Range
- Find first filtered row
- Find and Replace error in the sheets cell
- VBA for Files
- All In One
- Calculator
- Determine if Excel is already Open
- Extract url from Hyperlink
- Export VBA code Userform from Excel file using VBA
- Export MS Access Report in PDF using VBA
- Export embedded documents from excel
- Set Excel to the expiry date
- Excel Macro to Disable the Save As feature in Excel
- Extract Excel file properties Name, Size, Owner
- Excel Calculation Status
- Example of Multiple IF and Else and End IF
- ESC to stop the maco
- Early Binding and Late Binding
- Get Hard Drive name using VBA
- Download web page as HTML without Internet Explorer
- Download file from the website
- Stop email without a subject in Outlook
- Display FullScreen window in Excel
- Disable ESC button while running the macro
- Disable X (Red close)Button on VBA userform
- Determine total pages to be print
- Find my Desktop Path using VBA
- Delete images and shapes
- Delete Define Name Ranges using VBA
- Delete all files and Folder from Long Path (More than 255 char)
- Get time from the internet using VBA
- Import Export Data from MS Access to Excel (Fastway)