Recent content by mmtraining

Accessibility of Word, Excel, PowerPoint etc. files for people with disabilities is now a big thing in Germany. Does anyone out there know of information, books, web sites, etc. about how to create Word documents, Excel spreadsheets and PowerPoint presentations so that they can be correctly...

I take it you are saving the toolbars globally, so that the Word toolbars are saved into normal.dot, the Excel ones into personl.xls. These two files then get shot down by whatever happens on your network. (Is it a person who keeps causing this problem? If so have a nice quiet talk to him or...

I have got an Access 97 database with a lot of macros, some of which are left over from an older version of Access and also a hell of a lot of VBA modules in the background. Does anyone have a list of the changes in VBA commands, macros, changes in forms, reports etc that need to be done when...

Hey, Loomah, that's cheating, using a built-in function that I had forgotten about. A star is yours. All the best from Berlin Carol :-)

Brilliant, just what I wanted. Thanx a million. I had to translate it into German and am now grinning like mad at the result. All the best, Carol, Berlin :-)

Let's say you want to always have the three figures after a decimal point without having it rounded up or down, then you need to do three things: multiply by 1000, create the integer of the figure and divide by 1000. Eg. 123.4567 x 1000 = 123456.7. The integer of that is 123456. Divide that by...

I have a list of buildings and room numbers and wish to extract the building from the cells. In column A I have Bu 1123 Qul 1123 etc. The room number always consists of four figures, preceded by a space, the building might have one, two, three or more characters/figures. I want to have Bu or...

1. Don't regard training as something anyone who has the knowledge can do. That is the quickest way to lose customers and go through hell whilst doing so. 2. Do at least three months of taking and six months of giving courses at your local tec before you have your own classes or students. 3...

Word or Excel is still running in the background as a process. This is why it thinks that someone is still using the file. You can shut down processes with NT/2000/XP using the Task Manager and the file card Processes. For older versions of Windows research in that direction. Carol, Berlin :-)

Hi, Laura, to get a macro to run when the document is opened, call the macro autoopen: Sub autoopen() MyNiceForm.show End Sub Should the macro need to run when you create a new document using a template, call the macro autonew. The line of code in there will show the form. Then you can...

Looking at your name and where you are, you seem to be using a foreign language version of Word. What are you replacing no text with in the 4th line? Try recording that step in Word 2000, as the short names in the find and replace window are now in English. If this works, change the replace...

Generally in the file normal.dot, although AutoTexts can also be saved into other document templates, so back all the *.dot s you can find up and keep them close to hand in case users squeak. Carol, Berlin :-)

Try using the Word VBA help. Use the word UserForm to search, you get a lot of step-by-step results. Carol, Berlin :-)

Passwords are normally saved in a template called normal.dot. If you are working in a company that has got a central normal.dot that is write protected, then you can't save your own macros into it. The solution is to start an empty file and save it as a template and then store your macros in...

Put the code into another procedure and stick an if/then/else into the autorun procedure. That should test whether a variable has got a certain value, for example. All the best, Carol, Berlin :-)