Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. mmtraining

    Accessibility and MS-Office products - Any ideas???

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

    Save Access, Excel, and other Office Custom Toolbars

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

    Comparison of Access 97 (VBA) and Access XP (VBA)

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

    Excel: Significant Figures/Digits

    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 :-)
  5. mmtraining

    Excel function: Picking data out of a cell

    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 :-)
  6. mmtraining

    Excel: Significant Figures/Digits

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

    Excel function: Picking data out of a cell

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

    Any MS Office Instructors able to lend a little career advise?

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

    Read-only Office Files; Why?

    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 :-)
  10. mmtraining

    MS Word & Insert Date (Help!!!)

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

    Problem with macro from word97 to word2000

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

    Word Auto-text

    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 :-)
  13. mmtraining

    Word Form using VBA

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

    Macro Password in Word

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

    Load a form without running form initialize event??

    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 :-)
  16. mmtraining

    Word XP: My list of styles is getting verrry long

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

    Word XP: Problem with styles

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

    Value from a listbox

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

    Value from a listbox

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

    Highlighting fields in Word headers

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

Part and Inventory Search

Back
Top