Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
My workbook filename
I'd appreciate any tips as to a better way to deal with the following:
I am dealing with unprotecting and protecting some data in order to do some updates to a worksheet. I want to find a way that VBA knows my current filename so that I can avoid using the following: Workbooks("Data_Apr2005.xls"). _ Worksheets("Cash Flow").Protect DrawingObjects:=False Is there a way to specify the path the user opened the file from and the filename without hardcoding the information? Thanks! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
My workbook filename
The ThisWorkbook object will always refer to the workbook that
contains the code. So, you can use code like ThisWorkbook.Worksheets("Cash Flow").Protect DrawingObjects:=False The ActiveWorkbook object will refer to the workbook that is currently active. ThisWorkbook and ActiveWorkbook are often the same, but not always. ActiveWorkbook.Worksheets("Cash Flow").Protect DrawingObjects:=False -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com wrote in message oups.com... I'd appreciate any tips as to a better way to deal with the following: I am dealing with unprotecting and protecting some data in order to do some updates to a worksheet. I want to find a way that VBA knows my current filename so that I can avoid using the following: Workbooks("Data_Apr2005.xls"). _ Worksheets("Cash Flow").Protect DrawingObjects:=False Is there a way to specify the path the user opened the file from and the filename without hardcoding the information? Thanks! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
My workbook filename
Julia, how about ,ActiveSheet.Unprotect
-- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 wrote in message oups.com... I'd appreciate any tips as to a better way to deal with the following: I am dealing with unprotecting and protecting some data in order to do some updates to a worksheet. I want to find a way that VBA knows my current filename so that I can avoid using the following: Workbooks("Data_Apr2005.xls"). _ Worksheets("Cash Flow").Protect DrawingObjects:=False Is there a way to specify the path the user opened the file from and the filename without hardcoding the information? Thanks! |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
My workbook filename
ThisWorkbook refers to the workbook containing the code
ActiveWorkbook refers to the workbook that has the focus <workbook ref.Path - gives the path of the referenced workbook <workbook ref.Fullname - gives the path and name of the referenced workbook <workbook ref.Name - give the name of the referenced workbook -- Regards, Tom Ogilvy wrote in message oups.com... I'd appreciate any tips as to a better way to deal with the following: I am dealing with unprotecting and protecting some data in order to do some updates to a worksheet. I want to find a way that VBA knows my current filename so that I can avoid using the following: Workbooks("Data_Apr2005.xls"). _ Worksheets("Cash Flow").Protect DrawingObjects:=False Is there a way to specify the path the user opened the file from and the filename without hardcoding the information? Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
vba, get filename of this workbook | Excel Discussion (Misc queries) | |||
Workbook name in VBA doesn't match filename.xls | Excel Discussion (Misc queries) | |||
Saving XLS workbook with set filename | Excel Discussion (Misc queries) | |||
Filename in footer automatically in new workbook. | Excel Discussion (Misc queries) | |||
Variable Filename/Worksheet/Workbook | Excel Programming |