Styjun

Can the additional attack from a Samurai's Rapid Strike have advantage?

How to prevent a single-element caster from being useless against immune foes?

How can a class have multiple methods without breaking the single responsibility principle

"Will flex for food". What does this phrase mean?

Oath of redemption: Does Emmissary of Peace reflect damage taken from Aura of the Guardian?

How to structure presentation to avoid getting questions that will be answered later in the presentation?

Has the US government provided details on plans to deal with AIDS and childhood cancer?

Could flaps be raised upward to serve as spoilers / lift dumpers?

Why do MS SQL Server SEQUENCEs not have an ORDER parameter like Oracle?

Are some indefinite integrals impossible to compute or just don't exist?

If the Moon were impacted by a suitably sized meteor, how long would it take to impact the Earth?

Can birds evolve without trees?

How did Biff return to 2015 from 1955 without a lightning strike?

Is this mechanically safe?

How can flights operated by the same company have such different prices when marketed by another?

How to let cacti grow even if no player is near?

Disease transmitted by postage stamps

IBM mainframe classic executable file formats

Conflict between senior and junior members

Return last number in sub-sequences in a list of integers

A game of red and black

How to get values on a rastar layer to provide me with values

How do I respond appropriately to an overseas company that obtained a visa for me without hiring me?

Delete the following space

Dispolay workbook properties

Partially Solved : Excel Simple Edits to PathExcel multiple files macro - write file name to cell A1Open a workbook from Saved locationHow to retain number formats when inserting data into an xlsx workbook via openxlsx writeData()Excel VBA - Is Workbook OpenHaving a user choose where to save an Excel workbookGetting formatting information of a cell in an Excel workbook in RUnlock multiple workbooks and each workbook has their own password (VBA)Create a new workbook from an Excel template located in a different folderCopy-save a sheet in a new workbook named after contents of some specific cells from that same sheet

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;

0

I am trying to build a document template that always display the workbook properties, certain ones at that, in a cell.

For Example: I may want to see the file path complete with filename and file extension (.xls, .xlsx, or .xlsm), or I may simply wish to display the workbook title, with NO FILE PATH and NO FILE EXTENSION.

=MID(CELL("filename",A1),FIND("[",CELL("filename",A1))+1,FIND("]",CELL("filename",A1))-FIND("[",CELL("filename",A1))-1)

but this brings the extension with it. I do not want that.

Function Name()
Name = ActiveWorkbook.BuiltinDocumentProperties.("Title")
End Function

Then I type =Name() into the cell I want the file name displayed. But all I get is a big fat "0".

Similar code works when inserting "Last Author" for "Title".

See above

excel properties-file

share|improve this question

edited Mar 27 at 0:10

Roshith

1,6691111 silver badges2121 bronze badges

asked Mar 26 at 22:52

Glen SaegerGlen Saeger

1

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Your formula is pretty close. Instead of searching for the "]" search for the "." as the second FIND
  
  – datatoo
  Mar 26 at 23:10
  

  
  
  
  

add a comment | 

0

I am trying to build a document template that always display the workbook properties, certain ones at that, in a cell.

For Example: I may want to see the file path complete with filename and file extension (.xls, .xlsx, or .xlsm), or I may simply wish to display the workbook title, with NO FILE PATH and NO FILE EXTENSION.

=MID(CELL("filename",A1),FIND("[",CELL("filename",A1))+1,FIND("]",CELL("filename",A1))-FIND("[",CELL("filename",A1))-1)

but this brings the extension with it. I do not want that.

Function Name()
Name = ActiveWorkbook.BuiltinDocumentProperties.("Title")
End Function

Then I type =Name() into the cell I want the file name displayed. But all I get is a big fat "0".

Similar code works when inserting "Last Author" for "Title".

See above

excel properties-file

share|improve this question

edited Mar 27 at 0:10

Roshith

1,6691111 silver badges2121 bronze badges

asked Mar 26 at 22:52

Glen SaegerGlen Saeger

1

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Your formula is pretty close. Instead of searching for the "]" search for the "." as the second FIND
  
  – datatoo
  Mar 26 at 23:10
  

  
  
  
  

add a comment | 

I am trying to build a document template that always display the workbook properties, certain ones at that, in a cell.

For Example: I may want to see the file path complete with filename and file extension (.xls, .xlsx, or .xlsm), or I may simply wish to display the workbook title, with NO FILE PATH and NO FILE EXTENSION.

=MID(CELL("filename",A1),FIND("[",CELL("filename",A1))+1,FIND("]",CELL("filename",A1))-FIND("[",CELL("filename",A1))-1)

but this brings the extension with it. I do not want that.

Function Name()
Name = ActiveWorkbook.BuiltinDocumentProperties.("Title")
End Function

Then I type =Name() into the cell I want the file name displayed. But all I get is a big fat "0".

Similar code works when inserting "Last Author" for "Title".

See above

excel properties-file

share|improve this question

edited Mar 27 at 0:10

Roshith

1,6691111 silver badges2121 bronze badges

asked Mar 26 at 22:52

Glen SaegerGlen Saeger

1

=MID(CELL("filename",A1),FIND("[",CELL("filename",A1))+1,FIND("]",CELL("filename",A1))-FIND("[",CELL("filename",A1))-1)

Function Name()
Name = ActiveWorkbook.BuiltinDocumentProperties.("Title")
End Function

share|improve this question

edited Mar 27 at 0:10

Roshith

1,6691111 silver badges2121 bronze badges

asked Mar 26 at 22:52

Glen SaegerGlen Saeger

1

share|improve this question

edited Mar 27 at 0:10

Roshith

1,6691111 silver badges2121 bronze badges

asked Mar 26 at 22:52

Glen SaegerGlen Saeger

1

edited Mar 27 at 0:10

Roshith

1,6691111 silver badges2121 bronze badges

edited Mar 27 at 0:10

Roshith

1,6691111 silver badges2121 bronze badges

asked Mar 26 at 22:52

Glen SaegerGlen Saeger

1

asked Mar 26 at 22:52

Glen SaegerGlen Saeger

1