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

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

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

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

Hi, All, I need to search through a document including the headers for fields whose names have been changed for some reason (up until the changeover fom Office 97 to Office XP the fields were called Titel1, Titel2 and Titel3 and are now Title1, Title2 and Title3) I have got this far: Sub...

Does anyone know where I can find examples of code, training manuals etc. for Visio-VBA? I train people to use VBA in other applications (Word, Excel, Access), so I don't need the basics. What I'm after is any further help with the objects etc. in Visio. Also any web sites would be helpful...

I am using VBA in Visio 97. I have worked out how to insert a new page, works wonderfully. Now I want to zoom the page, so it shows 75 %. HOWWWWW??? This is what I've got so far. All very nice, but the new page insists on coming up at 32% which is a bit small for my lot. Sub Neue_Seite()...

Up until now (Word 97) I have used the Word function =rand(number of paragraphs) to create a given number of paragraphs when teaching people how to use Word, etc. We are now changing over to Office XP, which doesn't have =rand() any more. Has anyone got an idea if there is a replacement and...

I need to sort a table in Excel. No great problem, but... I have to sort by column A then within that by B then within that by C and so on to column I. Is this physically possible? I have never tried it. Do I just record the steps to sort using three columns and then copy the code until I have...

In a table people fill in information about costs. If they are not sure, they either leave the cell free or write some text or put in a question mark. I want to find out if the cell next door contains information. If yes, check this cell to see if the contents is numeric and larger than 0, if...

In order to consolidate two tables, I need to swap the columns in one of them so that the information is in the right order. How do I do this? As an example: I want to move column c to be before column b. Thanx for any ideas :-) Carol Berlin, Germany

Does anyone know if there is a document which goes through the differences between the two versions of VBA? We have got a number of hundred document templates, some of which still have WordBasic commands, dialog boxes, etc. They are quite complex, so we need to have a bit of help, so we know...

I have got an array called Daten(400). In this array the data ist read in and looks like this: Daten(1) contains se1_1 Daten(2) contains se2_1 Daten(3) contains se3_1 Daten(4) contains se1_2 Daten(5) contains se2_2 Daten(6) contains se3_2 How can I sort the contents of the array? Thanx for...

I have got a form field in Word called se2_2a. If I set it to 0 using the line ActiveDocument.FormFields("se2_2a").Result = 0 then I have no problems whatsoever. If I build the name using a series of loops to get the numbers right and then test to see if the bookmark exists (it...

Hello World, I am back, was off sick and am full of energy and want to get a file finished. I have got a table with two columns in one Word file. The first column contains abbreviations, the second one is empty. In another Word file I have got a table with two columns, abbreviations and...

Hello everyone, I have got a Word 97 file with lots of nice form fields in it. I got help here to read the value of a checkbox, thanx a lot. Now I need to read the information out of a dropdown field. I don't mean in a userform in VBA (that's easy) but really in a Word file. Basically, there...

Hello People, I have got a bit confused. I want to freeze the screen whilst VBA is doing a lot of hopping round in the background. The problem is that I get a "ghost" of the headers and footers, which doesn't look very professional. Dim temp As String Application.ScreenUpdating =...

I have a long table in Word 97, filled with various project activities, which are to be carried out or not, as decided by the project manager. The table is protected and allows FormFields to be used. In each row that can be chosen, I have got a checkbox which I put in there using the Forms icon...

Please help with the problem posted here: thread9-313714 Thanx a lot in advance Carol Berlin, Germany