Convert 2D array to 1D or Read Array elements in a 2D array by Row or Columns using the Excel VBA macro code in this page. Quickest way to convert 2D to 1D.
Excel VBA – Convert Range To Array – 2 Dimentional
November 24, 2024
Get Excel VBA Convert a Range to Array code in a Excel Workbook. And also write the array value to a worksheet range. Learn how to use of Resize & Transpose functions.
Excel VBA – Get Extended File Property – Author Modified Date Time
Get code to read Excel File property like Author, Last modified date, File size etc., Also has code for reading file of any type from your computer folder.
Open Text File – Read Write File Operations – VBA, Python, VBS, C, C++, DOS
Open Text File – VBA, VBS, Python, C, C++ Code snippets to Open ,Read, Write to text file. Import data from text file into any programming language.
Excel VBA Clear Cache – IE browser and xmlhttp requests
Clear Cookies, Cache, Browsing History From Excel VBA delete cache, cookies, browsing history, temporary internet files used by IE or MSHML2 xmlhttp requests. This method is applicable to IE browser only. To delete browser cache, cookies, temporary files of other browser like Chrome or Firefox, use the manual methods discussed […]
VBA XML Parser – Read XML Nodes & Import To Excel
Get VBA XML Parser to Import xml file into Excel worksheet. Using the Excel VBA code to read data from each XML node & import them into Excel sheet in proper format.
Copy Excel Chart in Powerpoint – Macro VBA pastespecial
How to Copy Excel Chart in PowerPoint Slides using VBA Macro – Step by Step Tutorial Requirement: We need to copy several charts from Excel in Powerpoint slides. And you want to skip the manual part ? Yes, you are in right place and this simple vba macro automation will do the task […]
Add Insert Controls – To Excel Quick Access Toolbar – Activex & Form
Add Activex or Form Controls – Insert Controls option in Excel Quick Access Toolbar. Step-By-Step explanation on adding options to Quick Access Toolbar
Pivot Chart In Excel – How To Create A Pivot Table?
Learn how to create Pivot Table in Excel & how to convert it into a Pivot Chart. This way summary report of data can be created as Pivot Table for easy ref.
Excel VBA Create New Workbook – With Name – Copy Save Close
Excel VBA create new workbook code is used to create, copy data & save with a name. Access newly created workbook with object. workbook.add new Excel file.