Skip to content
Primary Menu
  • Officetricks.Com
  • Blog
  • App Store
    • International Users
    • Indian Users
  • Subscribe
  • About Us
  • Excel
  • Social Media
Web Scraping Excel VBA Macro Windows API

VBA Download File from URL – using Excel Macro

August 01, 2025
Kumarapush
0

Using VBA download file from URL – Website link using Excel Macro. Get fully functional VBA code to download file from website.

Excel Excel VBA Macro System Control Windows API

Excel VBA – FTP Transfer – Files Download Upload

August 01, 2025
Kumarapush
10

Secure FTP: Excel VBA FTP Upload / Download from web server using a Login 7 Password. Use this method to automate file transfer between FTP or a Webserver to Backup or uploading web server.

Excel VBA Macro System Control VBA Beginners Windows API

Excel VBA Text To Speech – Voice Application Activation

August 01, 2025
Kumarapush
0

Install Excel VBA Text to Speech & make Excel VBA Speak, Voice messages. Activate Text to Speech(TTS – SAPI Win32 Speech API or Microsoft Speech SDK)

Login Accounts/Username Excel VBA Macro MS Word System Control Windows Windows API

Excel VBA Get Username – in 6 Easy ways – using Macro

August 01, 2025
Kumarapush
0

Get Excel VBA Get Username code for Windows current user name or file author. Different Excel macro codes to get User Id, Network User & Computer Name.

Excel Excel VBA Macro Security

Safe Password Manager – Secure All Your Passwords

August 01, 2025
Kumarapush
0

Trouble Remembering Too Many Login Credentials – Password Management with Encryption This article explains some techniques on how to make your own password manager and convert it into a more secured application with some techniques. Most of us have 5 to 10 Login IDs and Passwords to be maintained including […]

Excel Excel VBA Macro MS Powerpoint MS Word Security

Password Protect Excel 2010 & 2007

August 01, 2025
Kumarapush
0

Easy method to Password Protect Excel 2010, 2007 and also Word documents in just few clicks with built in option. Also Learn different possible methods to Protect Office Documents using Inbuilt Options and VBA. Applicable To: MS Excel, Word or PowerPoint of MS Office 2007 and above.

MS Word VBA Beginners

Find Synonym for Selected Text using MS Word VBA

August 01, 2025
Kumarapush
0

How do we refer Synonym for a word usually? To view synonym of a text in MS Word, We have to place the cursor on the word, then Right click to get the popup menu and Select option “Synonym”. Wouldn’t it be nice if we have a keyboard shortcut, to […]

Excel VBA Macro System Control Windows API

Excel VBA – Shutdown Computer – Logoff User – Visual Basic Code

August 01, 2025
Kumarapush
1

With this Excel VBA Shutdown Computer or Log off User in Windows PC. It uses Windows API call to initiate system shutdown from Excel VBA itself.

Excel VBA Macro System Control

Lock System at Scheduled Time with Excel

August 01, 2025
Kumarapush
2

Work Life Balance and Time Management This article explains how to Automate Locking a Windows Workstation and schedule your Tea breaks between hectic work, through Excel VBA Macro. Also, you can find a Excel App Download available at end of this page to schedule time and lock the system. Excel […]

Excel VBA Macro Excel Excel Formula Tricks Productivity VBA Beginners

Excel VBA – Import Data from another Workbook – 4 Easy Ways

August 01, 2025
Kumarapush
10

Excel Import Data From Another Workbook – VBA Codes To pull data from an external Excel file, use on of these scenarios. Closed Excel file: Using VBA Import data with Workbook object Opened Workbook: Using VBA Read Excel file. External Reference within Worksheets. ODBC Data Import from another workbook. Excel […]

Posts pagination

Previous 1 … 13 14 15 … 17 Next
Excel VBA Macro Tricks
  • Convert Excel to Jpg Image – VBA Code
  • Pick Multiple Columns using Random Numbers in Excel
  • Add Excel VBA Drop Down Data Validation List
  • Safe Password Manager – Secure All Your Passwords
  • Universal VCF to Excel and Excel to Vcard Converter
  • Excel VBA – Get RGB Color of Cell – Change Background
  • Remove Drop Down data validation list from Excel & VBA
  • VBA Hello World – Excel Macro – For Beginners
  • VBA XML Parser – Read XML Nodes & Import To Excel
  • Excel Convert – Number To Date – VBA Date Format
  • Create ListView in VBA at Runtime
  • Compare Two Columns Excel – Highlight Match – Bulk Data Duplicates
  • Convert Excel To PDF – VBA Code Print Selected Area
  • How to find your VBA Version – V6 or V7?
  • VBA Code – Create Index of Worksheets – with Links to each Sheet
Web Scraping Tricks
  • VBA Get My Public IP Address
  • VBScript Extract Data – Xmlhttp Web Scrape – Parse HTML
  • Auto Click FB Like Button – No Coding Knowledge Required
  • Email Extractor from Website or URL using Excel App
  • Excel VBA Selenium Chrome – Easy Sample Code
Windows API Tricks
  • Vba Get Computer Name using environment variable
  • Application Monitor – Manage & Terminate – Tasks Manager
  • Excel VBA Clear Cache – IE browser and xmlhttp requests
  • Find My PC Screen Resolution in Excel using VBA & Javascript
  • Excel VBA – Shutdown Computer – Logoff User – Visual Basic Code
  • Creating Folders Using Python: A Simple Guide
  • A Simple Guide to Copying Excel Sheets
  • Retrieve All Files in a Directory using Python
  • Creating Folders in Outlook: A Guide
  • Chandrayaan 3 Live Stream Today – Vikram Lander
  • Creating Folders Using Python: A Simple Guide
    As the world of technology continues to advance, it becomes evident that the ability to manipulate, create, and manage digital spaces is of utmost importance. Python programming language is among the most powerful tools capable of such feats. This exciting exploration commences with an introduction to Python, providing essential knowledge […]
  • A Simple Guide to Copying Excel Sheets
    Navigating the intricate landscape of Microsoft Excel can often seem like a daunting task. This software, with its abundance of features, functions, and commands, requires a keen understanding to fully utilize its potential. Whether you’re an industry expert or a novice user, mastering the art of manipulating Excel sheets is […]
  • Retrieve All Files in a Directory using Python
    In our digitally driven world, where data processing and management are integral to many industries, the ability to work with Python has become an invaluable skill. This language, particularly in relation to file and directory manipulation, grapples with the rapid growth of data and its intricate handling. With its intuitive […]
  • Officetricks.Com
  • Blog
  • App Store
    • International Users
    • Indian Users
  • Subscribe
  • About Us
  • Excel
  • Social Media
Copyright All rights reserved