| Thread | Last Post | Replies |
|
| Possible to Clear Locked XLS? | 30 Jan 2007 04:19 GMT | 2 |
I have a workbook which Excel thinks is "opened by another user" -- that is, in the prior use, it did not close properly, with the result that I can only open it "read only". (In MyComputer Explore / Properties "read-only" is not checked, however).
|
| determining whether a folder is open | 29 Jan 2007 18:55 GMT | 2 |
The Dir function can be used to determine whether a certain folder exists. How would we determine whether a certain folder is currently open?
|
| Extracting Headers and Body text from MS Word to use in Excel | 29 Jan 2007 18:47 GMT | 1 |
Does anyone know of any code examples of Excel extracting Headers and Body text from MS Word which can be used and manipulated by excel? So say if I had header 1,2,3,4 in the MS Word document, and I want to have the header and body text from header 2 & 4 say to be
|
| Excel link to Word | 29 Jan 2007 18:42 GMT | 1 |
2. The Principal is the organiser for the trade show JAMESON to take place in MOSCOW, RUSSIA from 4th to 8th December 2006 This is from a standard contract, the words which vary are those in caps and the dates, ideally I would like these to be captured from Excel.
|
| Strikethrough every nth word | 29 Jan 2007 16:43 GMT | 10 |
This code toggles strikethrough for selected text. Sub StrikeIt() Selection.Font.StrikeThrough = wdToggle End Sub
|
| Macro to set Scheduled Reminder in Outlook from Date in Work | 29 Jan 2007 02:52 GMT | 3 |
I have a little experience with Excel VB, but none with Word. Want i have is a Date in a (Cell) in a Word Document. I want to upon Closing the Word Document (In the Document Close), have that Date create a New Scheduled Reminder On that Day with
|
| Error printing from VB.NET in Word 2002 | 28 Jan 2007 22:48 GMT | 2 |
I have a problem when I try to print a Word Document from VB.NET in Word 2002. The instruction that I execute is the next: ........ActiveDocument.PrintOut(Background:=True, Copies:=1) When I execute the same instruction in Word 2003 it doesn't fail. Can
|
| Error printing a Word document | 28 Jan 2007 22:36 GMT | 1 |
I have a problem when I try to print a Word Document from VB.NET in Word 2002. The instruction that I execute is the next: ........ActiveDocument.PrintOut(Background:=True, Copies:=1) When I execute the same instruction in Word 2003 it doesn't fail. Can
|
| Compile Error in Hidden Module: Main Module | 28 Jan 2007 22:16 GMT | 7 |
I'm trying to edit an Excel 95 macro in 2000 and it seems to have now locked a module with a complile error in hidden module: main module, which I'm presuming is because it doesn't like some of the old code in one of the modules that no longer exists in 2000. Does anyone know any ...
|
| In preparation to create document | 28 Jan 2007 21:45 GMT | 2 |
Being an old Excel VBA'er, and new to Word VBA, I would like to ask some of the old Word VBA'ers a question in preparation of creating a new document. My company has several types of equipment that is sold to create systems. Not all systems are the same, so not all equipment types ...
|
| how to return the folder for Application.FileSearch.FoundFiles | 28 Jan 2007 20:43 GMT | 1 |
I need to return the folder in which I find a file with folder for Application.FileSearch.FoundFiles. It is found in subfolders and from there I need to know how to find the folder based on the file. Everything I've seen here does pretty much the reverse. I found something in MS ...
|
| FileSearch only returns Word docs | 28 Jan 2007 19:22 GMT | 2 |
When I use Application.FileSearch, it only returns Word documents: With Application.FileSearch .FileName = strNewFile '6386_P05*.* .LookIn = strGradingDocPath 'C:\6386
|
| Drop down field no longer active after I unprotect document. | 28 Jan 2007 19:20 GMT | 2 |
I have a form document previously created by Macro where threre are drop down options when you come a cross a active area. Once I unprotect the document to modify, I can't seem to turn back the macro back on to get back where drop down options become active. Instead, drop down ...
|
| Command bar ComboBox - multi column? | 28 Jan 2007 16:04 GMT | 1 |
Can anyone tell me if it is possible to create a multi-column combo box on a command bar. (I can create a single column one). Thanks Archie Dog
|
| Passing credentials from Word to a secure site? | 28 Jan 2007 15:58 GMT | 1 |
I'm building an application that uses Word. One of the first things it does is create a new document based on a template that is stored on a secure site (SharePoint, in this case). The problem I'm running into is passing credentials on to the site.
|