Search results for query: *

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

...work on a new file, choose File/New and choose your template out of the list of templates. To do this in Excel, open personl.xls and save it as an *.xlt file (choose this whilst saving out of the dropdown list of file types). From now on, when starting to work on a new file, choose File/New...

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 :-)

...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 1000, you get 123,456. To do that to a figure in A3, type the following into B3 =int(A3*1000)/1000 All the best Carol...

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 :-)

Can anyone help? We have just got Word XP at work and I am trying to find out all of the weird little traps and problems that MS has built into this version. One of the things I have noticed is that Word XP adds the formatting I have done to existing styles to the list on the lefthand side of...

We have changed from Office 97 to Office XP and have got a couple of problems, which are driving me mad, as they affect the acceptance of "my" users to use the templates I have developed: When a file is created, using one of my templates, the table of contents looks beautiful. When...

I wasn't being specific either: CustName = IstCustNames.result (instead of all the lines of code) Does that help? Carol, Berlin :-)

Try .result, not .value Carol, Berlin :-)

Thanx a lot, Tony, Although I had a mistake in my programming, I got it to work, having used your ideas and corrected my bits and pieces. All the best Carol, Berlin :-)