Search results for query: *

I've identified the problem, just need a work around now... The issue is caused because the ActiveX security settings are set to "Disable all controls without notification". This is a really useful feature, which I have no control over changing as the "network security" have disabled all the...

Morning All, After many happy years running office 2000 its been decided that its time to move to office 2007. I now have the enjoyable task of going through all our workbooks ensure everything still work... Some of the Excel 2000 workbooks have sheets that contain VBA Controls. These are...

Good point there, it probably would be useful to share my solution. Its in two parts. fisrt I put combos suggestion into a presentation. its just has suggested, single button and a web browser ' Button named - cmdDisplayFile ' Web Browser named - wbMain ' ' Opens a Dialog box allowing...

Now Then This works in Office 2000. It might need some tweeks to select your charts and display them how you want them, but it its a good starting point Public Sub test() '--------------------------- ' Creates the PowerPoint Object '--------------------------- ' Remember to...

Heres a starter on dynamic style arrays... ' Create the array with an undefined length ' The () indicate its an array dim dblLow() as double for intX = 1 to 10 step 1 ' Resize the array. ' Redim does the resizing. ' Preserve keeps the existing data (if you dont use ' preserve...

Hi Combo, thanks for the response. Thats a very nice trick to display something in powerpoint. I can see that being useful in more than just this situation. I've added the option to select a file to view as multiple files need to be available for viewing. The users can't complain now...

I new there would be a simple solution! Thanks for the tip, it lead to the path of discovery... I never new that shift would add the additional item to the Edit menu. Anyway the combination of CopyPicture with 'As Shown on Screen..' and formatted as 'bitmap' worked as required. The other...

Hello All! I’m after some help in displaying an Excel worksheet in a powerpoint slide. I am using Excel 2000 and Powerpoint 2000. I have used an Excel worksheet to create a large chart that spans about 200 rows and the entire width of the sheet (stops at column IP). The chart uses a mixture...

I was assuming that the users would only be working with finalised documents, but as seen with my sample data this may not be the case. So it does make sense to block all documents with unprocessed tracked changes. I’ve add added the checks to reject documents that contain tracked changes and...

I do agree that it is not really the users fault for not knowing how to use Word. Although training is available within our company for it and all the other office packages I’m fairly sure I’m one of few that have actually completed them. Most people just seem to manage on what they pick up as...

Thanks everyone for their responses. Macropod, I'm sorry if I have offended with the multiple posts. I was just trying to capture as wide an audience as possible. In future I will only be using this site as it’s the only one my works network will allow me to log into. The details you posted...

I think that is what i'm trying to do. As Word only crashes when the contents of the document is pasted into another document the user generally does not know that there is a problem with their document. From investigating the problem it seems to be caused by frequent changes to formatting and...

Thanks for you response. Normally that does work fine. The problem is, while I have the word file open the contents of other word files are copied and pasted into the new document. If one of the source files is corrupted the paste operation (or file insert method) causes word to crash. After...

Hello All I need to stop a Word process using an Excel macro. Excel will create an instance of Word, use it and then close word. This works the majority of the time. When it does not work the Word process is still running in the background and needs to be stopped using task manager. What...