| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Workbook Name
How do I automate the Master Workbook Name being added to a cell in m worksheet. Right now I manually type it. The ActiveWorkbook.FullNam does not work as it is the full file path. Dim masterWB As String ' Master Workbook Name masterWB = Range("C138") ' C138 is the Workbook Nam -- bobwilso ----------------------------------------------------------------------- bobwilson's Profile: http://www.excelforum.com/member.php...fo&userid=3304 View this thread: http://www.excelforum.com/showthread.php?threadid=52959 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Workbook Name
You just need the Name property:
ActiveWorkbook.Name which will give you "AWorkbook.xls" Best regards John "bobwilson" wrote in message ... How do I automate the Master Workbook Name being added to a cell in my worksheet. Right now I manually type it. The ActiveWorkbook.FullName does not work as it is the full file path. Dim masterWB As String ' Master Workbook Name masterWB = Range("C138") ' C138 is the Workbook Name -- bobwilson ------------------------------------------------------------------------ bobwilson's Profile: http://www.excelforum.com/member.php...o&userid=33046 View this thread: http://www.excelforum.com/showthread...hreadid=529596 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Workbook Name
masterWB = ActiveWorkbook.Name
"bobwilson" wrote: How do I automate the Master Workbook Name being added to a cell in my worksheet. Right now I manually type it. The ActiveWorkbook.FullName does not work as it is the full file path. Dim masterWB As String ' Master Workbook Name masterWB = Range("C138") ' C138 is the Workbook Name -- bobwilson ------------------------------------------------------------------------ bobwilson's Profile: http://www.excelforum.com/member.php...o&userid=33046 View this thread: http://www.excelforum.com/showthread...hreadid=529596 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Workbook Name
See http://www.xldynamic.com/source/xld.xlFAQ0002.html
-- HTH Bob Phillips (remove nothere from email address if mailing direct) "bobwilson" wrote in message ... How do I automate the Master Workbook Name being added to a cell in my worksheet. Right now I manually type it. The ActiveWorkbook.FullName does not work as it is the full file path. Dim masterWB As String ' Master Workbook Name masterWB = Range("C138") ' C138 is the Workbook Name -- bobwilson ------------------------------------------------------------------------ bobwilson's Profile: http://www.excelforum.com/member.php...o&userid=33046 View this thread: http://www.excelforum.com/showthread...hreadid=529596 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Workbook Name
Enter this formula in cell C138
=LEFT(MID(CELL("filename",A1),FIND("[",CELL("filename",A1))+1,255),FIND("]",MID(CELL("filename",A1),FIND("[",CELL("filename",A1))+1,255))-1) Regards, Stefi €˛bobwilson€¯ ezt Ć*rta: How do I automate the Master Workbook Name being added to a cell in my worksheet. Right now I manually type it. The ActiveWorkbook.FullName does not work as it is the full file path. Dim masterWB As String ' Master Workbook Name masterWB = Range("C138") ' C138 is the Workbook Name -- bobwilson ------------------------------------------------------------------------ bobwilson's Profile: http://www.excelforum.com/member.php...o&userid=33046 View this thread: http://www.excelforum.com/showthread...hreadid=529596 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Workbook Name
Thanks Works Great -- bobwilso ----------------------------------------------------------------------- bobwilson's Profile: http://www.excelforum.com/member.php...fo&userid=3304 View this thread: http://www.excelforum.com/showthread.php?threadid=52959 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| loop through a column on a workbook copying data on each row to another workbook, then copy data back to the original workbook | Excel Programming | |||
| Select sheet tabs in workbook & save to separate workbook files | Excel Worksheet Functions | |||
| Running a macro to protect a workbook on a already protected workbook UNprotects the workbook ?? | Excel Programming | |||
| Copy a range of cells in an unopened workbook and paste it to the current workbook | Excel Programming | |||
| What commands do you use to name a workbook, save a workbook,open a workbook | Excel Programming | |||
![bobwilson[_17_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
