Skip to content
Primary Menu
  • Officetricks.Com
  • Blog
  • App Store
    • International Users
    • Indian Users
  • Subscribe
  • About Us
  • Excel
  • Social Media
File Operations Excel VBA Macro Folder Operations

Excel VBA Rename File – without opening the File

July 20, 2022
Kumarapush
0

Get Excel VBA Rename file – Macro code to change file name. Input existing file name with itspath & new name. This VBA code will rename file to new name..

Please enable JavaScript

Windows search text in files and folders with Notepad++
File Operations Excel

VBA Get File Extension – From Path – using Excel macro

July 20, 2022
Kumarapush

Learn VBA code to get file extension from path or file name using this simple Excel macro code. The code extracts text after the last dot in file name.

File Operations Tricks
  • Excel VBA Rename File – without opening the File
  • Excel VBA – Folder Operation – Exists, Create, Copy, Delete Directory
  • [Python] Check if File Exists
  • How to Convert Docx to PDF – VBA Save Word as PDF
  • VBA to Change File Encoding ANSI to UTF8 – Text to Unicode
  • How to Zip File or Folder using VBA Code – Excel Macro?
  • Excel Vba Save a Copy of Workbook with TimeStamp
  • Removing Empty Folder is Now Easy – Get Folder List with Size
  • Get List of All Subfolders in a Folder – Excel VBA
  • VBA to Delete File in a Folder
  • Excel VBA Delete Folder if Exists
  • VBA Copy File to Folder
  • How to Zip Directory using Python? – Archive folder
  • Excel vba Add Date Time Stamp to File Name
  • Excel VBA List Files in Folder – Dir in Shell
Excel VBA Macro Tricks
  • Making SORT More Simple and Faster in Excel with Advanced Options
  • Convert Excel to HTML Table Tags – VBA Macro Code
  • VBA Code – Create Index of Worksheets – with Links to each Sheet
  • Excel VBA Timer Event – Run Macro at Specific Time – Automatic Schedule
  • Convert a Formatted Cell in Excel into HTML Tag using VBA
Folder Operations Tricks
  • Get List of All Subfolders in a Folder – Excel VBA
  • VBA get Path to Default Temporary folder
  • VBA – Find My Documents, Desktop & System Folder Path
  • How to Zip Directory using Python? – Archive folder
  • Removing Empty Folder is Now Easy – Get Folder List with Size
  • How to Save Web Page as PDF File – No Plugins Required
  • How to Replace #N/A in Excel with 0 or blank – using Formula?
  • Net Run Rate Calculation in IPL, T20 & One day Cricket – Formula
  • Outlook VBA – Sort Emails by Date – in a Folder
  • New Update – Very useful for Whatsapp Web Users
  • Save Web Page to PDF from Chrome, Edge, Firefox
    How to Save Web Page as PDF File – No Plugins Required
    Use this easy trick to save the Web page to PDF file. It is a straight forward method that enables to save whole website page into single PDF file.
  • Replace #NA in Excel with Zero or Empty blank space with Formula
    How to Replace #N/A in Excel with 0 or blank – using Formula?
    How to replace #N/A in Excel with 0 or blank values using formula. Usually a formula like Vlookup returns such errors & this Excel function can handle this.
  • Net Run Rate - Formula to Calculate - IPL Cricket T20 OneDay Points Table
    Net Run Rate Calculation in IPL, T20 & One day Cricket – Formula
    Here is how the Net Run Rate is calcualted in Cricket matches. This run rate calculation formula is applcable to IPL, T20 & Oneday tournaments.
  • Officetricks.Com
  • Blog
  • App Store
    • International Users
    • Indian Users
  • Subscribe
  • About Us
  • Excel
  • Social Media
Copyright All rights reserved