User Posts: Junaed-Ar-Rahman
0
Excel VBA Offset Column (5 Suitable Cases)
0

Often we need to move the active cell to the next cell without explicitly specifying its row and column coordinates. The Offset function provides a very ...

0
How to Make a Roster in Excel (with Detailed Steps)
0

A roster usually indicates a schedule that divides the turn of duties (or even leave) in an organization for an individual or a group. From attendance tracking ...

0
How to Create Clustered Scatter Plot in Excel (with Easy Steps)
0

A clustered scatter plot is a type of chart in Excel that displays data points as individual dots on a graph. Unlike a regular scatter plot where all data ...

0
Excel MATCH Function Match Type (Greater/Less Than & Exact Match)
0

The MATCH function in Excel is a very useful function to find out exact or approximate data matches in Excel. However, you may have trouble choosing the match ...

0
How to Calculate Sales Conversion Rate Using Formula in Excel
0

In this article, we will demonstrate how to calculate the sales conversion rate formula in Excel. We may need to calculate various types of calculations for ...

0
How to Create Excel Checkbook Register with Reconciliation
0

In this article, we will demonstrate how to create an Excel checkbook register with Reconciliation. Bankers typically employ reconciliation in their daily ...

0
How to Reduce Excel File Size by Deleting Blank Rows
0

In this article, we will demonstrate how to reduce Excel file size by deleting blank rows. Often a file in Excel becomes very large and takes a huge space in ...

0
How to Use Cost Benefit Analysis Calculator in Excel
0

In this article, we will demonstrate how to use the cost-benefit analysis calculator in Excel. Cost-benefit analysis is a very important term in the business ...

0
How to Merge Vertical Cells in Excel (6 Easy Ways)
0

The Merging operation helps us combine more than one cell in Excel. Often, we find a data sheet that contains a lot of columns and rows, and this is very ...

0
How to Use ISBLANK Function in Excel for Multiple Cells
0

ISBLANK is the function that we use to check whether a cell in Excel is empty or has value. We may use this for a cell or in a range of cells. In this ...

0
How to Use ISNA and MATCH Functions in Excel (2 Examples)
0

We often have to compare two rows or two columns in an Excel workbook. But if we do it without applying direct formulas, it becomes very tiresome. Excel helps ...

Browsing All Comments By: Junaed-Ar-Rahman
  1. Reply Avatar photo
    Junaed-Ar-Rahman Mar 9, 2023 at 1:00 PM

    Dear HARIRI,

    When you use the following command in your code, the prompt will not appear.
    Application.DisplayAlerts = False
    However, if you want to open a new file in the same name in the same folder, there may be two scenarios. You might be able to do that without any obstacles because you have a file with .xlsm extension only with that name and no .xlsx file with that name. But if you have two files with same name in same folder, one with .xlsm extension and another with .xlsx extension, then you cannot open a new Excel file in that folder. Prompt will appear to warn you that there is a folder with the same name and you will have to discard that action or have to modify the file name.

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo