Search results for query: *

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...

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...

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...