Replies

A good article, for those who are still using the start menu ;-).

Since I discovered http://www.launchy.net/ I’ve had very little use for the start menu. I’m not sure if you’ve already covered Launchy in one of your articles. If not, it may be worth considering.

I’ve not used either of these image editors, but do use paint.net:

http://en.wikipedia.org/wiki/Paint.NET

It is not Photoshop or Gimp, but does everything I need to do and is free and easy to use.

How does it compare to the programs you have reviewed?

I also use Paint.NET for almost all work I do with images. It’s an excellent and completely free application. I have GIMP as wel for more advanced needs but I rarely ever need to use it. Paint.NET fulfills almost all my needs. The big advantage of Paint.NET is that it is so lightweight. It is fast to start up and is very responsive.

Add a third column with the formula =A2&”|”&B2 and then search for “0500|puglia”.

The macros security warning dialog can be omitted by signing the workbook with a certificate created using selfcert.exe and then telling Excel to trust that certificate. That way you can still keep security set at medium or high.

Good to see that you’re looking at Windows Scripting Host though, it would be a far neater solution than scheduling workbooks.

What exactly are you trying to acheieve? You say you want to ‘get an access database running on Terminal Services’. If the Windows Server in question has Access installed then you can just do exactly what you would do on your local machine. Once logged into Terminal Services, just act exactly as if the desktop shown is the desktop of your local machine. Open the Access database and do your work.

Terminal Services allows users to concurrently log into a windows machine from remote machines with the resultant user interfaces being displayed on the remote machines, nothing else.

Application like Access are designed for user interaction and I fail to see the benefit of having it installed on a Windows Server rather than a local machine. A server is supposed to be used for running services and not user applications.

Ah, I see… it’s shame that you’re forced to do it this way… .

Is something like Windows Scripting Host not even an option?

I doubt you will be able to read the command line passed to excel.exe from the code within your excel workbook. Any command line switches (listed here) are for the consumption of excel.exe and I’d be suprised if Excel publicised them after the event.

If the above is tue, I would advocate using the first method, i.e. a second workbook which calls the workbook which does your work. You say this is messy, but the action of scheduling the opening of a Workbook to run code is, in itself, rather messy. I would always avoid this if it could be replaced by, say, an executable that could do the same work. Office apps are designed for user interation rather than performing services.

(Edited by HansV to make URL clickable – see Help 19)

You should not be deriving the path of the My Documents folder using the username. There are other methods which return the My Documents path, e.g. http://www.thescarms.com/vbasic/specialfolders.asp%5B/url%5D – see the CSIDL_PERSONAL folder.

(Edited by HansV to make URL clickable – see Help 19)

You should not be deriving the path of the My Documents folder using the username. There are other methods which return the My Documents path, e.g. http://www.thescarms.com/vbasic/specialfolders.asp%5B/url%5D – see the CSIDL_PERSONAL folder.

OK, I can understand why it makes things more convenient.

I previously thought that the main purpose was to list all the numeric values and I couldn’t see a reason for that, but point 3 shows why that may be useful.

I was under the impression that Intellisense never suggests the enumerators for right hand side of a property assignment. Do you have an example of it doing so?

The reason that it sometimes suggests them for method arguments and sometimes doesn’t is that sometimes arguments are declared as variants even though a particular enumerator member is expected. In these instances there is no way for Intellisense to know which enumerator to suggest.

OK, I can understand why it makes things more convenient.

I previously thought that the main purpose was to list all the numeric values and I couldn’t see a reason for that, but point 3 shows why that may be useful.

I was under the impression that Intellisense never suggests the enumerators for right hand side of a property assignment. Do you have an example of it doing so?

The reason that it sometimes suggests them for method arguments and sometimes doesn’t is that sometimes arguments are declared as variants even though a particular enumerator member is expected. In these instances there is no way for Intellisense to know which enumerator to suggest.

Can I ask what the purpose of having this list is?

The whole point of having constants and enumerators is that you can reference them by name and not have to worry about the underlying value they represent.

In any case, if you really want to know the value just hit F2 and find the constant/enumerator in the object browser, but I still can’t see what the benefit is of knowing.

Can I ask what the purpose of having this list is?

The whole point of having constants and enumerators is that you can reference them by name and not have to worry about the underlying value they represent.

In any case, if you really want to know the value just hit F2 and find the constant/enumerator in the object browser, but I still can’t see what the benefit is of knowing.

Add a UserForm to you project and MSForms will appear in the library dropdown in the object browser. UserForm is a class in that library.

Add a UserForm to you project and MSForms will appear in the library dropdown in the object browser. UserForm is a class in that library.