Use `Application.ActiveWorkbook.Path` for just the path itself (without the workbook name) or `Application.ActiveWorkbook.FullName` for the path *with* the workbook name.

Always nice to have: 

    Dim myPath As String     
    Dim folderPath As String 
    
    folderPath = Application.ActiveWorkbook.Path    
    myPath = Application.ActiveWorkbook.FullName





If you want to get the path of the workbook from where the macro is being executed - use 
```
Application.ThisWorkbook.Path
```  

`Application.ActiveWorkbook.Path` can sometimes produce unexpected results (e.g. if your macro switches between multiple workbooks).

The quickest way

    path = ThisWorkbook.Path &amp; &quot;\&quot;

How can I check if an anonymous object that was created as such:

    var myObj = { 
        prop1: &#39;no&#39;,
        prop2: function () { return false; }
    }

does indeed have a prop2 defined?

`prop2` will always be defined as a function, but for some objects it is not required and will not be defined.

I tried what was suggested here: https://stackoverflow.com/questions/595766/how-to-determine-if-native-javascript-object-has-a-property-method but I don&#39;t think it works for anonymous objects .

How to check if anonymous object has a method?

I&#39;ve seen lots of code with declarations like `Class clazz`. Where does this originate from? Is this some kind of convention? I think ‘clazz’ is not even an English word, has no meaning at all, how can so many programmers name a wrong name coincidentally?



Why do Java programmers like to name a variable &quot;clazz&quot;?

I wrote a macro as an add-in, and I need to get the path of the current worksheet on which it is being executed. How do I do this? How do I get the file path (just the directory)?

How to get the path of current worksheet in VBA?

<p>I wrote a macro as an add-in, and I need to get the path of the current worksheet on which it is being executed. How do I do this? How do I get the file path (just the directory)?</p>


I want excel files on a website to open in Excel when clicked, not get saved on desktop, or get opened embedded in a browser etc. Now obviously it all depends on how everything is configured for each user, but what&#39;s the best Content-Type and other settings to achieve just that most of the time?

What is correct content-type for excel files?

Is there any built-in functionality in [tag:VBA] to get unique values from a one-dimensional array? What about just getting rid of duplicates?

If not, then how would I get the unique values from an array?

vba: get unique values from array

I have an array like this:

    Dim aFirstArray() As Variant

How do I clear the entire array?
What about a collection?

How to clear the entire array?

I am trying to display milliseconds in an Excel macro.  I have a column of integers which are timestamps in milliseconds (e.g. 28095200 is 7:48:15.200 am), and I want to make a new column next to it which keeps a running average and displays the time in a &lt;code&gt;hh:mm:ss.000&lt;/code&gt; format.  

     Dim Cel As Range
     Set Cel = Range(&quot;B1&quot;)
     temp = Application.Average(Range(&quot;A1:A2&quot;)) / 1000
     ms = Round(temp - Int(temp), 2) * 1000
     Cel.Value = Strings.Format((temp / 60 / 60 / 24), &quot;hh:mm:ss&quot;) _
                    &amp; &quot;.&quot; &amp; Strings.Format(ms, &quot;#000&quot;)

This only displays &quot;mm:ss.0&quot; in the cell.  Yet when I click on the cell, it shows &quot;hh:mm:ss&quot; in the formula bar.  Why are the hours missing? How can I show the hours, minutes, seconds, and milliseconds?

Display milliseconds in Excel

I&#39;m using Apache POI 3.6, I want to read an excel file which has a date like this `8/23/1991`.


     switch (cell.getCellType()) {
    
       ...
       ...
    
       case HSSFCell.CELL_TYPE_NUMERIC:
         value = &quot;NUMERIC value=&quot; + cell.getNumericCellValue();
         break;
    
       ...
    
     }

But it takes the numeric value type and returns the value like this `33473.0`.

I&#39;ve tried to use Numeric Cell Type although with no luck.

     
    dbltemp=row.getCell(c, Row.CREATE_NULL_AS_BLANK).getNumericCellValue();

    if (c == 6 || c == 9) {
        strTemp= new String(dbltemp.toString().trim());
    
        long tempDate = Long.parseLong(strTemp);
        Date date = new Date(tempDate);
    
        strVal = date.toString();
    }
    

How can I fix my problem? 



How to read Excel cell having Date with Apache POI?

Where does `Debug.Print` output messages?

Where does VBA Debug.Print log to?

So I know how to name a textbox, or a like object in PowerPoint with VB, but I was wondering if there was a way to name objects through the Ribbon (PowerPoint 2007). For instance, if I add a text box onto a slide, is there a way to assign it a name (sort of like the properties window in access, or the textbox in Excel 2003 at the top left side where you can enter the name)?

Basically so I can reference it in code later; without having to use code to name each and every object i add after the fact. Perhaps an easier way through the Ribbon?

Content Type	Original Author	Original Content on Stackoverflow
Question	Alex Gordon	View Question on Stackoverflow
Solution 1 - Excel	BradC	View Answer on Stackoverflow
Solution 2 - Excel	Alex22	View Answer on Stackoverflow
Solution 3 - Excel	avalanche1	View Answer on Stackoverflow
Solution 4 - Excel	Pablo Vilas	View Answer on Stackoverflow

How to get the path of current worksheet in VBA?

Excel Problem Overview

Excel Solutions

Solution 1 - Excel

Solution 2 - Excel

Solution 3 - Excel

Solution 4 - Excel

Why do Java programmers like to name a variable "clazz"?

How to check if anonymous object has a method?

Attributions