Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Is there any way I can display the name of my Excel
spreadsheet in cell A1 of the spreadsheet? |
#2
![]() |
|||
|
|||
![]()
=CELL("filename",A1)
look in help at =Cell and =Info for other uses HTH RES |
#3
![]() |
|||
|
|||
![]()
....Type it in?
Yes, but afaik it can only be done with some VBA code. 1. Open the VBA editor 2. Along the left margin choose the VBAProject associated with your file 3. Right click "This workbook" and select "View Code". A new VBA editor window opens. Dropdowns along the top should say "This workbook" and "Open". The structure for a new routine is visible: "Private Sub Workbook_Open()" and "End Sub". 4. Use this code: Range("a1").value = activeworkbook.name Each time you open the file this routine will run. If your workbook has multiple tabs you'll need to specify which tab to write in: try this line of code: Sheets("YourSheetName").select Final code looks like: Private Sub Workbook_Open() Sheets("YourSheetName").Select Range("a1").Value = ActiveWorkbook.Name End Sub |
#4
![]() |
|||
|
|||
![]() "bobf" wrote in message ... Is there any way I can display the name of my Excel spreadsheet in cell A1 of the spreadsheet? try: - =MID(CELL("filename",C9538),FIND("[",CELL("filename",C9538))+1,FIND("]",CELL("filename",C9538))-FIND("[",CELL("filename",C9538))-1) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Embedding a file into an Excel spreadsheet? | Excel Worksheet Functions | |||
Can I export a .txf file from an Excel spreadsheet for investment. | Excel Discussion (Misc queries) | |||
How can you print file properties in an Excel spreadsheet? | Excel Discussion (Misc queries) | |||
Read Text File into Excel Using VBA | Excel Discussion (Misc queries) | |||
I need to download an exel spreadsheet file. (file extension :xls) | Excel Discussion (Misc queries) |