Search results for query: *

Yeah, the problem was permissions. I gave the users Read&Execute permission and now everything functions as it should. Thanks! But, at the risk of hijacking my own thread, I'm having a similar problem with Excel. I put a macro-laden .xlt file in the C:\Program Files\Microsoft...

I learned from some earlier threads a simple and elegant way of sharing custom toolbars and macros with other users of Word on the same machine: Simply save the word document containing this modifications as a template (.dot) and copy that template into the STARTUP folder (C:\Program...

Thanks fumei, genomon and PH. With your help, my goals are achieved. Here's what I put together: Private Sub ShowFiles_Click() Dim fso As New Scripting.FileSystemObject Dim fld As Scripting.Folder Dim fil As Scripting.File Dim var Set fld = fso.GetFolder("P:\yaddayadda\blahblahblah") For Each...

Okay, I have made reference now to the Scripting Runtime library. I'll just fix a couple of other bugs and post the resulting code . . .

Thanks, Gerry. I think FSO is just the tool I needed, but your code is a little over my head. I'll spend some time studying it. I'm getting a compile error on this line: Dim fso As New Scripting.FileSystemObject It says "User defined type not defined" Thanks for helping me get on track! -cb

How can I make a UserForm display all the files within a given directory and allow the user to choose one of them? I have a piece of code which makes Excel open a CSV text file. It works flawlessly but it requires the user to type into a textbox the exact name of the file she wants to open. I'd...

Thanks, PHV. That's just the bit of code I needed! Sorry for posting in the wrong forum, but thanks for the tip, Remou. Newbie error.

I'm trying to come up with a macro to evaluate an entire column of cells, then copy the text in the string if the conditions are met. I have some code which does something similar. It cycles through some cells, compares each to one in a relative position, and clears the contents of other cells...