Search results for query: *

Thanks, Mike. I'll try that.

Hi, Is there an easy way to have VBA code create a list of all the modules you have in your project and put that list onto a worksheet? Same question with putting a list of all the macros easily into a worksheet. Thanks!

Thanks, dinger2121. I actually wasn't quite sure about what the CommonDialog option was, but in researching I came across this code: Application.FileDialog(msoFileDialogFolderPicker).Show MyPath = CurDir I think it may do what I need. Thanks again for the reply!

Hi, I'd like to use VBA to allow a user to choose a folder to set as the new current directory. Is there a way to pop open a dialog box like the GetOpenFilename does, but choose a folder rather than a file? Here's my start: Dim Response As VbMsgBoxResult Response = MsgBox("Your current...

Yes, if you treat each person's work desktop PC like a computer at home, they would go to Start->All Programs-->Accessories-->Communications-->Remote Desktop Connection Everyone has the same location/"remote computer" to log in to (for example call it "AcmePC"). There is only one server...

Skip, I agree it is a strange setup. I am doing some consulting here at a small company, and I had never previously seen this kind of setup. Each user has Windows XP installed on their own machine, but the procedure is to turn on and log onto the local PC and immediately log in thru the...

Pardon the double-speak, I'm partially bilingual. :) I won't say that I may be misunderstanding something about how Remote Desktop works, but let me explain further When I use the term "server" in this statement: "C:\foldername1\foldername2\filename.xls is the local path on the server." I am...

Thanks for replying. C:\foldername1\foldername2\filename.xls is the local path on the server. From what I understand, since everyone remotely logs into the same server, this path is everyone's "local path" when using Remote Desktop. Even when I use...

The setup for this company has everyone using remote desktop to log in and work on a central server. As a result the Excel workbooks on the server can be accessed as: c:\foldername1\foldername2\filename.xls \\servername\foldername1\foldername2\filename.xls H:\foldername2\filename.xls (mapped...