Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Newbie help please
I have downloaded, unzipped, and run, the GetInfo file from Chip Pearson's
page at:- http://www.cpearson.com/excel/download.htm The explanation on the above page states:- "The GetInfo function, written in VBA, allows you to retrieve nearly any property of any object in the Excel object model directly from a worksheet cell. Using this one function, you can eliminate dozens of custom UDFs to get application and object properties." I am a newbie struggling to upskill somewhat in Excel. I am using Excel 2002. Could someone please give me a brief comment on just exactly how I could use the above in practice. I have been doing a lot of background research and printed gazillions of pages of help info, and think that I can flesh out the details once I have a pointer in the right direction. TIA Brian Tozer |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Newbie help please
Brian,
Chip gives you a workbook that gives you all of the information that you ask. What more do you need? -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Brian Tozer" wrote in message ... I have downloaded, unzipped, and run, the GetInfo file from Chip Pearson's page at:- http://www.cpearson.com/excel/download.htm The explanation on the above page states:- "The GetInfo function, written in VBA, allows you to retrieve nearly any property of any object in the Excel object model directly from a worksheet cell. Using this one function, you can eliminate dozens of custom UDFs to get application and object properties." I am a newbie struggling to upskill somewhat in Excel. I am using Excel 2002. Could someone please give me a brief comment on just exactly how I could use the above in practice. I have been doing a lot of background research and printed gazillions of pages of help info, and think that I can flesh out the details once I have a pointer in the right direction. TIA Brian Tozer |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Newbie help please
As I wrote, I have run the file.
I have examined the result. I think you may find it hard to think like a newbie. Presumably it is intended to be used in conjunction with an existing workbook. How exactly? Brian Tozer Bob Phillips wrote: Brian, Chip gives you a workbook that gives you all of the information that you ask. What more do you need? "Brian Tozer" wrote in message ... I have downloaded, unzipped, and run, the GetInfo file from Chip Pearson's page at:- http://www.cpearson.com/excel/download.htm The explanation on the above page states:- "The GetInfo function, written in VBA, allows you to retrieve nearly any property of any object in the Excel object model directly from a worksheet cell. Using this one function, you can eliminate dozens of custom UDFs to get application and object properties." I am a newbie struggling to upskill somewhat in Excel. I am using Excel 2002. Could someone please give me a brief comment on just exactly how I could use the above in practice. I have been doing a lot of background research and printed gazillions of pages of help info, and think that I can flesh out the details once I have a pointer in the right direction. TIA Brian Tozer |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Newbie help please
Brian
just select one of the cells in column B and then cursor down. The formulae are in the cells. These are the examples of using the function. I guess the more VBA you know, the further you can take this. There is more explanation in the VBA code itself. So, if for some reason you want to create a formula that is dependent on the colour of the text in a cell, you could test it using Chip's GetInfo function. For example: =IF(getinfo(A1,"font.bold"),"text is bold","text is NOT bold") Beware though that the value does not seem to be recalculated automatically even though "Application.Volatile True" is included. Regards Trevor "Brian Tozer" wrote in message ... As I wrote, I have run the file. I have examined the result. I think you may find it hard to think like a newbie. Presumably it is intended to be used in conjunction with an existing workbook. How exactly? Brian Tozer Bob Phillips wrote: Brian, Chip gives you a workbook that gives you all of the information that you ask. What more do you need? "Brian Tozer" wrote in message ... I have downloaded, unzipped, and run, the GetInfo file from Chip Pearson's page at:- http://www.cpearson.com/excel/download.htm The explanation on the above page states:- "The GetInfo function, written in VBA, allows you to retrieve nearly any property of any object in the Excel object model directly from a worksheet cell. Using this one function, you can eliminate dozens of custom UDFs to get application and object properties." I am a newbie struggling to upskill somewhat in Excel. I am using Excel 2002. Could someone please give me a brief comment on just exactly how I could use the above in practice. I have been doing a lot of background research and printed gazillions of pages of help info, and think that I can flesh out the details once I have a pointer in the right direction. TIA Brian Tozer |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Newbie help please
Brian
You can export the modGetInfo module from Chip's workbook then import it to your Personal.xls workbook or into a blank workbook which you could then Save AsFile TypeExcel Add-in(*.xla) The GetInfo Function would then be available for any/all open workbooks. Gord Dibben Excel MVP On Sun, 14 Dec 2003 12:31:39 +1300, "Brian Tozer" wrote: As I wrote, I have run the file. I have examined the result. I think you may find it hard to think like a newbie. Presumably it is intended to be used in conjunction with an existing workbook. How exactly? Brian Tozer Bob Phillips wrote: Brian, Chip gives you a workbook that gives you all of the information that you ask. What more do you need? "Brian Tozer" wrote in message ... I have downloaded, unzipped, and run, the GetInfo file from Chip Pearson's page at:- http://www.cpearson.com/excel/download.htm The explanation on the above page states:- "The GetInfo function, written in VBA, allows you to retrieve nearly any property of any object in the Excel object model directly from a worksheet cell. Using this one function, you can eliminate dozens of custom UDFs to get application and object properties." I am a newbie struggling to upskill somewhat in Excel. I am using Excel 2002. Could someone please give me a brief comment on just exactly how I could use the above in practice. I have been doing a lot of background research and printed gazillions of pages of help info, and think that I can flesh out the details once I have a pointer in the right direction. TIA Brian Tozer |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Newbie help please
Thanks very much Trevor.
You have given me the breakthru that I needed. Brian Tozer Trevor Shuttleworth wrote: Brian just select one of the cells in column B and then cursor down. The formulae are in the cells. These are the examples of using the function. I guess the more VBA you know, the further you can take this. There is more explanation in the VBA code itself. So, if for some reason you want to create a formula that is dependent on the colour of the text in a cell, you could test it using Chip's GetInfo function. For example: =IF(getinfo(A1,"font.bold"),"text is bold","text is NOT bold") Beware though that the value does not seem to be recalculated automatically even though "Application.Volatile True" is included. Regards Trevor "Brian Tozer" wrote in message ... As I wrote, I have run the file. I have examined the result. I think you may find it hard to think like a newbie. Presumably it is intended to be used in conjunction with an existing workbook. How exactly? Brian Tozer Bob Phillips wrote: Brian, Chip gives you a workbook that gives you all of the information that you ask. What more do you need? "Brian Tozer" wrote in message ... I have downloaded, unzipped, and run, the GetInfo file from Chip Pearson's page at:- http://www.cpearson.com/excel/download.htm The explanation on the above page states:- "The GetInfo function, written in VBA, allows you to retrieve nearly any property of any object in the Excel object model directly from a worksheet cell. Using this one function, you can eliminate dozens of custom UDFs to get application and object properties." I am a newbie struggling to upskill somewhat in Excel. I am using Excel 2002. Could someone please give me a brief comment on just exactly how I could use the above in practice. I have been doing a lot of background research and printed gazillions of pages of help info, and think that I can flesh out the details once I have a pointer in the right direction. TIA Brian Tozer |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Newbie help please
Thanks Gord.
Very helpful. Brian Tozer Gord Dibben wrote: Brian You can export the modGetInfo module from Chip's workbook then import it to your Personal.xls workbook or into a blank workbook which you could then Save AsFile TypeExcel Add-in(*.xla) The GetInfo Function would then be available for any/all open workbooks. Gord Dibben Excel MVP |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Real Newbie newbie question | New Users to Excel | |||
Help for a newbie... please | Excel Worksheet Functions | |||
Newbie Help. Is this possible? | Excel Discussion (Misc queries) | |||
Very very new newbie | New Users to Excel | |||
ADO newbie help please | Excel Programming |