q: vba extensibility 2007

[orbii]

hi, i recently just got back into vba programming... thanks to my boss. i
haven't touch excel or access since v97, i was wondering if those stuff that
shows up in vba like typing cells(1,1). once you hit the dot, a menu should
show up w/ all the methods etc etc. is that called Extensibility?

if is so, i remember almost everything i typed back in v97 had that popped
up... but oddly in 2007, not very often will it pop up. anyone here knows
what else add-ins or references do i need to turn on in order to get it
going? i'm not an advance vba coder, but i learn from the UI quite fast,
and w/o that it really makes me run around looking at other's code before i
can figure out how to do my own.

also, which add-in or reference do i need in order to cycle through an html
file and pull out attribs? for example, i want to pull out values from all
href= and src=

thanks so much in advance... already scanned through 5 books in borders, and
having bad speed cus of taiwan arn't helping me at all

aloha, orbii

 

[zz]

it's called intellisense and it doesn't show when you haven't explicitily
declared the type of the object you're working on or certain situations.


eg.

if i declare this

dim s as worksheet

when i call s.<< here appears intellisense invoking all methods/properties
concerning to 'worksheet' object

also when you declare a function in a module or a class
you can invoke them by declaring myclass.___________
|the
function |
|the
method |
|the
property |
___________

but if you say

dim s

set s= sheets("the sheet")

when you type s., there's no intellisense, since the 's' contains no methods
or properties until you run your code.

also, sometimes, intellisense doesn't "Know" or senses the methods beyond
certain point of the object's sub classes, because they where no ment to be
invoked trough execution but in-design mode, and sometimes when a certain
property of the object is declared under the private clausule, it cannot be
shown in the intellisense's menu.

hope i have explained myself.

 

[orbii]

ic, but still sometimes things like typing a simple
Range(cells(1,1),cells(2,2)). doesn't call up the intellisense. i guess
that's the problem i'm facing.

aloha, orbii

it's called intellisense and it doesn't show when you haven't explicitily
declared the type of the object you're working on or certain situations.


eg.

if i declare this

dim s as worksheet

when i call s.<< here appears intellisense invoking all methods/properties
concerning to 'worksheet' object

also when you declare a function in a module or a class
you can invoke them by declaring myclass.___________
|the
function |
|the
method |
|the
property |

___________

but if you say

dim s

set s= sheets("the sheet")

when you type s., there's no intellisense, since the 's' contains no
methods or properties until you run your code.

also, sometimes, intellisense doesn't "Know" or senses the methods beyond
certain point of the object's sub classes, because they where no ment to
be invoked trough execution but in-design mode, and sometimes when a
certain property of the object is declared under the private clausule, it
cannot be shown in the intellisense's menu.

hope i have explained myself.


--
---
zz [MX]
cuasi-musico,semi-poeta y loco

hi, i recently just got back into vba programming... thanks to my boss.
i haven't touch excel or access since v97, i was wondering if those stuff
that shows up in vba like typing cells(1,1). once you hit the dot, a
menu should show up w/ all the methods etc etc. is that called
Extensibility?

if is so, i remember almost everything i typed back in v97 had that
popped up... but oddly in 2007, not very often will it pop up. anyone
here knows what else add-ins or references do i need to turn on in order
to get it going? i'm not an advance vba coder, but i learn from the UI
quite fast, and w/o that it really makes me run around looking at other's
code before i can figure out how to do my own.

also, which add-in or reference do i need in order to cycle through an
html file and pull out attribs? for example, i want to pull out values
from all href= and src=

thanks so much in advance... already scanned through 5 books in borders,
and having bad speed cus of taiwan arn't helping me at all

aloha, orbii

 

[zz]

it may be caused by the fact that you're asigning the address property of
the range ,in runtime
but in this particular case it does show the intellisense menu, why don't
you try deleting/rewriting the dot.

--
---
zz [MX]
cuasi-musico,semi-poeta y loco

ic, but still sometimes things like typing a simple
Range(cells(1,1),cells(2,2)). doesn't call up the intellisense. i guess
that's the problem i'm facing.

aloha, orbii

it's called intellisense and it doesn't show when you haven't explicitily
declared the type of the object you're working on or certain situations.


eg.

if i declare this

dim s as worksheet

when i call s.<< here appears intellisense invoking all
methods/properties concerning to 'worksheet' object

also when you declare a function in a module or a class
you can invoke them by declaring myclass.___________

|the function |

|the method |

|the property |

___________

but if you say

dim s

set s= sheets("the sheet")

when you type s., there's no intellisense, since the 's' contains no
methods or properties until you run your code.

also, sometimes, intellisense doesn't "Know" or senses the methods
beyond certain point of the object's sub classes, because they where no
ment to be invoked trough execution but in-design mode, and sometimes
when a certain property of the object is declared under the private
clausule, it cannot be shown in the intellisense's menu.

hope i have explained myself.


--
---
zz [MX]
cuasi-musico,semi-poeta y loco

hi, i recently just got back into vba programming... thanks to my boss.
i haven't touch excel or access since v97, i was wondering if those
stuff that shows up in vba like typing cells(1,1). once you hit the
dot, a menu should show up w/ all the methods etc etc. is that called
Extensibility?

if is so, i remember almost everything i typed back in v97 had that
popped up... but oddly in 2007, not very often will it pop up. anyone
here knows what else add-ins or references do i need to turn on in order
to get it going? i'm not an advance vba coder, but i learn from the UI
quite fast, and w/o that it really makes me run around looking at
other's code before i can figure out how to do my own.

also, which add-in or reference do i need in order to cycle through an
html file and pull out attribs? for example, i want to pull out values
from all href= and src=

thanks so much in advance... already scanned through 5 books in borders,
and having bad speed cus of taiwan arn't helping me at all

aloha, orbii

 

[orbii]

hmm, funny been spending the last 20 mins trying it... it works sometimes in
some sense times doesnt... gonna keep searching.

but thank you so much for giving me the info, now i understand what i need
to search for.

aloha, orbii

it may be caused by the fact that you're asigning the address property of
the range ,in runtime
but in this particular case it does show the intellisense menu, why don't
you try deleting/rewriting the dot.

--
---
zz [MX]
cuasi-musico,semi-poeta y loco

ic, but still sometimes things like typing a simple
Range(cells(1,1),cells(2,2)). doesn't call up the intellisense. i guess
that's the problem i'm facing.

aloha, orbii

it's called intellisense and it doesn't show when you haven't
explicitily declared the type of the object you're working on or certain
situations.


eg.

if i declare this

dim s as worksheet

when i call s.<< here appears intellisense invoking all
methods/properties concerning to 'worksheet' object

also when you declare a function in a module or a class
you can invoke them by declaring myclass.___________

|the function |

|the method |

|the property |

___________

but if you say

dim s

set s= sheets("the sheet")

when you type s., there's no intellisense, since the 's' contains no
methods or properties until you run your code.

also, sometimes, intellisense doesn't "Know" or senses the methods
beyond certain point of the object's sub classes, because they where no
ment to be invoked trough execution but in-design mode, and sometimes
when a certain property of the object is declared under the private
clausule, it cannot be shown in the intellisense's menu.

hope i have explained myself.


--
---
zz [MX]
cuasi-musico,semi-poeta y loco



hi, i recently just got back into vba programming... thanks to my boss.
i haven't touch excel or access since v97, i was wondering if those
stuff that shows up in vba like typing cells(1,1). once you hit the
dot, a menu should show up w/ all the methods etc etc. is that called
Extensibility?

if is so, i remember almost everything i typed back in v97 had that
popped up... but oddly in 2007, not very often will it pop up. anyone
here knows what else add-ins or references do i need to turn on in
order to get it going? i'm not an advance vba coder, but i learn from
the UI quite fast, and w/o that it really makes me run around looking
at other's code before i can figure out how to do my own.

also, which add-in or reference do i need in order to cycle through an
html file and pull out attribs? for example, i want to pull out values
from all href= and src=

thanks so much in advance... already scanned through 5 books in
borders, and having bad speed cus of taiwan arn't helping me at all

aloha, orbii

 

[zz]

well, you have to keep in mind the response time of the IDE, it may take a
while in a slower machine also...

good to know it helped..

hmm, funny been spending the last 20 mins trying it... it works sometimes
in some sense times doesnt... gonna keep searching.

but thank you so much for giving me the info, now i understand what i need
to search for.

aloha, orbii

it may be caused by the fact that you're asigning the address property of
the range ,in runtime
but in this particular case it does show the intellisense menu, why don't
you try deleting/rewriting the dot.

--
---
zz [MX]
cuasi-musico,semi-poeta y loco

ic, but still sometimes things like typing a simple
Range(cells(1,1),cells(2,2)). doesn't call up the intellisense. i guess
that's the problem i'm facing.

aloha, orbii

it's called intellisense and it doesn't show when you haven't
explicitily declared the type of the object you're working on or
certain situations.


eg.

if i declare this

dim s as worksheet

when i call s.<< here appears intellisense invoking all
methods/properties concerning to 'worksheet' object

also when you declare a function in a module or a class
you can invoke them by declaring myclass.___________

|the function |

|the method |

|the property |

___________

but if you say

dim s

set s= sheets("the sheet")

when you type s., there's no intellisense, since the 's' contains no
methods or properties until you run your code.

also, sometimes, intellisense doesn't "Know" or senses the methods
beyond certain point of the object's sub classes, because they where no
ment to be invoked trough execution but in-design mode, and sometimes
when a certain property of the object is declared under the private
clausule, it cannot be shown in the intellisense's menu.

hope i have explained myself.


--
---
zz [MX]
cuasi-musico,semi-poeta y loco



hi, i recently just got back into vba programming... thanks to my
boss. i haven't touch excel or access since v97, i was wondering if
those stuff that shows up in vba like typing cells(1,1). once you hit
the dot, a menu should show up w/ all the methods etc etc. is that
called Extensibility?

if is so, i remember almost everything i typed back in v97 had that
popped up... but oddly in 2007, not very often will it pop up. anyone
here knows what else add-ins or references do i need to turn on in
order to get it going? i'm not an advance vba coder, but i learn from
the UI quite fast, and w/o that it really makes me run around looking
at other's code before i can figure out how to do my own.

also, which add-in or reference do i need in order to cycle through an
html file and pull out attribs? for example, i want to pull out
values from all href= and src=

thanks so much in advance... already scanned through 5 books in
borders, and having bad speed cus of taiwan arn't helping me at all

aloha, orbii