Search results for query: *

thanks, IvanMoala, for both tips. i ought to have got the second one myself though! btw, i notice that the location changes according to the platform. on this (xp) machine (with Office XP), the path is "C:\Program Files\Microsoft Office\Office10". i wonder whether there is a way to...

my add-in sets the application icon to an icon of my choosing when it runs, as per the following standard code. i have two questions: 1. the icon change works for the application in the top-left part of the application window and for the small window which appears when the Excel taskbar button...

KornGeek, just wanted to say that your solution was very elegant and i wish that i had thought of that! best wishes gusset

sorry, you're right - for each obj in collection (not collection.count). i was indeed talking about debugging, but the question is equally applicable for an exiting condition. the answer is the .index property, which i had forgotten about completely. why is it faster? thanks gusset

by the way, i know i could increment a variable. but is there some other way? g

i follow the advice to use the following syntax: for each obj in collection.count ... next obj rather than for i = 0 to collection.count -1 ... next i because it is said to be quicker. but if, with the first syntax, i stop code execution part-way through the loop, how can i examine which...

excellent, thanks v much... ...now how do i remove an add-in programmatically? if this is possible, how do i remove the very add-in containing the code to remove the add-in? what i am trying to do is this: let the user run the code behind the add-in somehow. i don't know the standard way to do...

thanks, PhillipAyres. i'll try that now! gusset

...know, this is a learning curve for me. trouble is, my code, which looks like this Cells(lRow, 5).Formula = "=(C" & lRow & "/10)*D" & lRow doesn't appear to do anything to a worksheet in the open workbook. is it doing something to a hidden worksheet in the .xla file...

i think it will ("Attach Custom Toolbars to Microsoft Excel Workbooks and Templates"). thanks, BenRowe. best wishes gusset

there would be no problem if i wanted it on the sheet! do you say it can't be done? gusset

thanks, but the button stays on the toolbar if i close the workbook or open another! gusset

great faq! i got the same tip from wrox's Excel 2000 VBA - they must have read your faq too! gusset

i have a workbook which some of my team will use. i'd like that workbook to have a button on a toolbar which runs a macro in that workbook. but i don't want the button (or the toolbar) to appear with other workbooks. i'm not familiar enough with the excel interface to know how to achieve...

Correct! thanks very much. i should have thought of that myself gusset

...and also to you, blorf

many thanks, dhookom gusset

yes, common sense leads me to that conclusion. there must be some advantage to using ole objects, though, else MS would not offer it. i forgot about the hyperlink field, by the way.

i am storing some images "in" an Access database. please could you let me know whether it would be better to store them as OLE objects in the database or to store a relative path to a folder? i am vba-proficient so would probably choose the flexibility of the latter unless there is a...

please can someone remind me how to search in a query for records starting with an upper case character? thanks gusset