Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
ActiveSheet & Apropriate Reference
Hello,
I am trying to use the following bit of code and I am having trouble. I believe I am missing a reference in the tools menu because when I type ActiveSheet. nothing appears afterwards. If I had the right library loaded then it should appear. Does anyone have any ideas of how I can find out which library to use? ActiveSheet.PivotTables("FocusMktList").RefreshTab le These are the libraries that I have loaded - Visual Basic For Applications - Microsoft Excel 9.0 - OLE Automation - Mcirosoft Office 9.0 - Microsoft Forms 2.0 Library |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
ActiveSheet & Apropriate Reference
What you observe is correct. Activesheet is ambiguous - like selection. To
illustrate from the immediate window: ? typename(Activesheet) Worksheet ? typename(Activesheet) Chart The feature you speak of does not try to resolve the object within the current context. -- Regards, Tom Ogilvy "James C." wrote: Hello, I am trying to use the following bit of code and I am having trouble. I believe I am missing a reference in the tools menu because when I type ActiveSheet. nothing appears afterwards. If I had the right library loaded then it should appear. Does anyone have any ideas of how I can find out which library to use? ActiveSheet.PivotTables("FocusMktList").RefreshTab le These are the libraries that I have loaded - Visual Basic For Applications - Microsoft Excel 9.0 - OLE Automation - Mcirosoft Office 9.0 - Microsoft Forms 2.0 Library |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
ActiveSheet & Apropriate Reference
Not sure I understand. I have this type of code throughtout my module. I have
never had any problems running it until just recently. I ran this on a newer version of excel, the module crashed and gives me the following error. "Unable to get the PivotTables property of the Worksheet class" I get this on everysingle one of my ActiveSheet...... lines? Any ideas. "Tom Ogilvy" wrote: What you observe is correct. Activesheet is ambiguous - like selection. To illustrate from the immediate window: ? typename(Activesheet) Worksheet ? typename(Activesheet) Chart The feature you speak of does not try to resolve the object within the current context. -- Regards, Tom Ogilvy "James C." wrote: Hello, I am trying to use the following bit of code and I am having trouble. I believe I am missing a reference in the tools menu because when I type ActiveSheet. nothing appears afterwards. If I had the right library loaded then it should appear. Does anyone have any ideas of how I can find out which library to use? ActiveSheet.PivotTables("FocusMktList").RefreshTab le These are the libraries that I have loaded - Visual Basic For Applications - Microsoft Excel 9.0 - OLE Automation - Mcirosoft Office 9.0 - Microsoft Forms 2.0 Library |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
ActiveSheet & Apropriate Reference
I was talking about your test for the proper library by checking activesheet.
Pivottable objects are in the Excel object library. I suspect you have created a variable or a procedure with the name activesheet. This is masking the true activesheet object. -- Regards, Tom Ogilvy "James C." wrote: Not sure I understand. I have this type of code throughtout my module. I have never had any problems running it until just recently. I ran this on a newer version of excel, the module crashed and gives me the following error. "Unable to get the PivotTables property of the Worksheet class" I get this on everysingle one of my ActiveSheet...... lines? Any ideas. "Tom Ogilvy" wrote: What you observe is correct. Activesheet is ambiguous - like selection. To illustrate from the immediate window: ? typename(Activesheet) Worksheet ? typename(Activesheet) Chart The feature you speak of does not try to resolve the object within the current context. -- Regards, Tom Ogilvy "James C." wrote: Hello, I am trying to use the following bit of code and I am having trouble. I believe I am missing a reference in the tools menu because when I type ActiveSheet. nothing appears afterwards. If I had the right library loaded then it should appear. Does anyone have any ideas of how I can find out which library to use? ActiveSheet.PivotTables("FocusMktList").RefreshTab le These are the libraries that I have loaded - Visual Basic For Applications - Microsoft Excel 9.0 - OLE Automation - Mcirosoft Office 9.0 - Microsoft Forms 2.0 Library |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
ActiveSheet & Apropriate Reference
You don't get Intellisense support because ActiveSheet isn't
always a worksheet. It might be a chart sheet. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "James C." wrote in message ... Hello, I am trying to use the following bit of code and I am having trouble. I believe I am missing a reference in the tools menu because when I type ActiveSheet. nothing appears afterwards. If I had the right library loaded then it should appear. Does anyone have any ideas of how I can find out which library to use? ActiveSheet.PivotTables("FocusMktList").RefreshTab le These are the libraries that I have loaded - Visual Basic For Applications - Microsoft Excel 9.0 - OLE Automation - Mcirosoft Office 9.0 - Microsoft Forms 2.0 Library |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
activesheet | Excel Programming | |||
Get ActiveSheet name in VB | Excel Programming | |||
name of the activesheet | Excel Programming | |||
ActiveSheet.Name? | Excel Programming | |||
ActiveSheet | Excel Programming |