Access Excel VBA rename workbook or file

Access Excel VBA rename workbook or file
Posted on
This Access Excel VBA tutorial explains how to rename workbook or file in VBA using Name As. Access Excel VBA rename workbook or file It is very easy to rename a workbook or file in VBA using the below syntax. Name and As are the keywords. Name currentFilePath As newFilePath For example, suppose we have a file called test.xlsx in Desktop, and we want to rename it as test2.xlsx, run the below P...
More

Excel Security Warning – Macros have been disabled

Excel Security Warning – Macros have been disabled
Posted on
This Excel tutorial explains how to solve the problem of Excel Security Warning - Macros have been disabled. Excel Security Warning - Macros have been disabled This Excel Security Warning is one of the most annoying warnings in Excel. If you click on the Options button, you will see the below message. In fact, this message does say something about the reason for this alert, it explain...
More

Access Excel VBA copy workbook or file

Access Excel VBA copy workbook or file
Posted on
This Access Excel VBA tutorial explains how to copy workbook or file. You may also want to read: FSO File Methods Worksheets.Copy Method to copy worksheet Access Excel VBA copy workbook or file There are two common ways to copy workbook or file FSO.CopyFile Method FileCopy Function I have explained how to use different FSO Methods in my previous post, click to see more details....
More

Excel VBA combine rows into cell

Excel VBA combine rows into cell
Posted on
This Excel VBA tutorial explains how to combine rows into Cell. You may also want to read: Separate line break data into different rows Delimit Cell value into rows Excel VBA combine rows into cell In my previous post, I demonstrated how to delimit a Cell into separate rows,  one example is that you copy a email list and you want to put each email address into different rows. From: ...
More

Excel create Pivot Table using PowerPivot

Excel create Pivot Table using PowerPivot
This Excel tutorial explains how to create Relationship and create Pivot Table using PowerPivot. You may also want to read: Create Relationship in Microsoft Access PowerPivot in Excel In Excel version 2016, PowerPivot is pre-installed and you can see the option in the ribbon tab. For previous versions of Excel, some versions cannot support PowerPivot. If you are not using Excel 20...
More

Excel VBA find all Cells contain Named Range

Excel VBA find all Cells contain Named Range
This Excel VBA tutorial explains how to find all Cells contain Named Range using Macro. You may also want to read: Find all external links and broken links in workbook Replace Named Range with formula Find all Cells contain Named Range In Excel spreadsheet, we can define Named Range under Name Manager (Formulas > Name Manager) We can refer to Name Manager to see the formula th...
More

Excel VBA Named Range Properties

Excel VBA Named Range Properties
Posted on
This Excel VBA tutorial explains some common Properties of Name Object (Named Range), and demonstrate how to replace named Range with formula. You may also want to read: Excel find all external links and broken links in workbook Excel VBA Named Range Properties In Excel spreadsheet, we can define Named Range under Name Manager (Formulas > Name Manager) In the below screenshot, I have...
More

Excel extract text in brackets

Excel extract text in brackets
This Excel tutorial explains how to extract text in brackets or in defined text in Excel spreadsheet and VBA. Extract text in brackets in Excel spreadsheet In the previous post, I demonstrated how to remove text in brackets or in any defined text, in this post I will explain how to extract the text in brackets or in any defined text. In Excel spreadsheet, you can extract any substring using...
More

Excel VBA select multiple files in dialog

Excel VBA select multiple files in dialog
Posted on
This Excel VBA tutorial explains how to select multiple files in dialog using Application.GetOpenFileName. Excel VBA select file in dialog In many applications, you would see a "browse" button where you can select files for the application to process. In Excel VBA, you can create a Macro to open the browse dialog. After you select the target file, the file path is stored in a VBA Array, t...
More

Access Excel capitalize first letter in a sentence

Access Excel capitalize first letter in a sentence
This Access Excel tutorial explains how to capitalize first letter in a sentence using VBA custom Function. Capitalize first letter in a sentence In Excel spreadsheet, there is a Function called Proper, which converts all the first letter of each word to capital letter. Example  Using Proper Function he is a boy. she is a girl. He Is A Boy. She Is A Girl. he is a boy. his name...
More