Search results for query: *

Skip, Thanks so much. the function returns just what i want.

excel vb application

i want to get file's access path as string, not open the file. the code should be like: Dim msg As String Application.FileDialog(msoFileDialogFolderPicker).Show msg = Application.FileDialog(msoFileDialogFilePicker).SelectedItems(1) by using this filedialog, i can only have folder's...

i have a dictionary which contains user-defined class items. i need to change the value of these items. each time i change value, the item value in original dictionary will also be changed, and i lost my orignial data. how to solve it? code like this: dim olddict as new scripting.dictionary...

(I don't believe you can do it with a Collection - it is sometimes a useful tool, but pretty basic.) Tony, do you know any other one similar to Collection, which can hold a group of user defined class? i do not like collection either. there are too few methods in this class. but this is the...

hi mrmovie, i believe col.item(akey) will return an object instead of the key of the object. and it can not be debug.print. thanks. (TechnicalUser) 30 Jan 07 10:59 'i think For Each aKey In Col Debug.Print aKey & "=" & Col.Item(aKey) Next

How can I get the key of each item in collection? here is a sample code. dim col as new collection col.add item1, keyitem1 col.add item2, keyitem2 for n = 1 to col.count item = col.item(n) ? key = col.keys(n) next n i can get item by n, but how to get key of item by n? i tried to use a...

Thanks for all you guys. i used Roy's way to do, and it works perfect!

Here is a sample code. when i passed the "firstdict" to my second sub, and added another element to "mydict". i want the element to be added in the second sub only to "mydict" not "firstdict". but the element is actually added to both of them. how to fix it? thanks Sub dict() Dim firstdict As...