Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
workbook name
I have a formula to pull the workbook name but is there a way to do i in code -- ceem ----------------------------------------------------------------------- ceemo's Profile: http://www.excelforum.com/member.php...fo&userid=1065 View this thread: http://www.excelforum.com/showthread.php?threadid=54854 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
workbook name
Hi Ceemo,
Try Activeworkbook.Name also if you also need location you could use Activeworkbook.FullName. James ceemo wrote: I have a formula to pull the workbook name but is there a way to do it in code? -- ceemo ------------------------------------------------------------------------ ceemo's Profile: http://www.excelforum.com/member.php...o&userid=10650 View this thread: http://www.excelforum.com/showthread...hreadid=548546 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
workbook name
You can use ActiveWorkbook.Name or .FullName to return the name
or full name of the workbook that is active, regardless of what workbook contains the code. You can use ThisWorkbook.Name or ..FullName to return the name of the workbook which contains the code, regardless of what is active. If you are going to be calling this from a worksheet cell, use Function WorkbookName() As String WorkbookName = Application.Caller.Parent.Parent.Name End Function -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "ceemo" wrote in message ... I have a formula to pull the workbook name but is there a way to do it in code? -- ceemo ------------------------------------------------------------------------ ceemo's Profile: http://www.excelforum.com/member.php...o&userid=10650 View this thread: http://www.excelforum.com/showthread...hreadid=548546 |
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 |