| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Workbook Name as Variable
I need to get the name of the active workbook assigned to a variable in the
Macro that I am trying to write. Is this possible? Thanks, |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Workbook Name as Variable
Dim wbname as String
wbname = ActiveWorkbook.Name |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Workbook Name as Variable
Sub Workbookname()
Dim strActivebook As String strActivebook = ActiveWorkbook.Name End Sub -- HTH... Jim Thomlinson "Herd" wrote: I need to get the name of the active workbook assigned to a variable in the Macro that I am trying to write. Is this possible? Thanks, |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Workbook Name as Variable
"Mark Lincoln" wrote: Dim wbname as String wbname = ActiveWorkbook.Name Thank You for the fast reponse. It was very helpful |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Workbook Name as Variable
"Jim Thomlinson" wrote: Sub Workbookname() Dim strActivebook As String strActivebook = ActiveWorkbook.Name End Sub Thank You for the fast response. It was very helpful. -- HTH... Jim Thomlinson "Herd" wrote: I need to get the name of the active workbook assigned to a variable in the Macro that I am trying to write. Is this possible? Thanks, |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can a workbook variable be set by clicking the workbook? | Excel Programming | |||
| Can a workbook variable be set by clicking the workbook? | Excel Programming | |||
| Can a workbook variable be set by clicking the workbook? | Excel Programming | |||
| Can a workbook variable be set by clicking the workbook? | Excel Programming | |||
| Can a workbook variable be set by clicking the workbook? | Excel Programming | |||
Linear Mode
