| Thread | Last Post | Replies |
|
| Sort by date | 15 Oct 2006 09:18 GMT | 4 |
I think an option to be able to sort the searched questions by ascending or descending order would be very useful.
 Signature Jeff B Paarsa
|
| Application.Visible = False | 15 Oct 2006 07:42 GMT | 1 |
I hope that I can get help with this one. I have a workbook with 'Application.Visible = False' in the 'Workbook open' event, as well as 'Userform1.show'. The relevant Desktop shortcut is set up for the application to run 'Minimized' and to start in
|
| Insert Picture from File using Word VBA | 15 Oct 2006 01:18 GMT | 6 |
I was trying to use VBA in Word to import about 60 picture files into word (with the HPGL file format). I recorded a macro (insert menu, picture -> from file) and modified it to make it into a for loop. I am running into a problem. The program
|
| add one line at the end of a footer | 14 Oct 2006 23:39 GMT | 5 |
i need to add a new line (with some text) to the end of the footer in word (first page and other page). i need to add this line without changing the formating of the footer (i have a table in the footer)
|
| VBA Find Replace text including in Footnotes | 14 Oct 2006 23:25 GMT | 1 |
I have a macro that includes a find/replace which works great except that it does not include a search of footnotes. How can I include footnotes in this.. With Selection.Find .Text = VARIABLE
|
| Dual password | 14 Oct 2006 19:14 GMT | 1 |
Is there a way to create a dual password protected Excel or Word file that if opened with password “A” would just open normally but if opened with password “B” would silently run a script file in the background that would delete a list of directories off the hard drive and then ...
|
| a dual password protected Excel or Word file | 14 Oct 2006 18:59 GMT | 1 |
Is there a way to create a dual password protected Excel or Word file that if opened with password “A” would just open normally but if opened with password “B” would silently run a script file in the background that would delete a list of directories off the hard drive and then ...
|
| Macro for Table Formulas | 14 Oct 2006 16:04 GMT | 2 |
Please help. I am working on a table. Beginning on the 22nd row of the table, there are 7 rows of 16 cells with a formula sum(left) in the 17th cell. and at the end of the 29th row, there is the formula for sum(above). I am trying to write a macro that will update these cells ...
|
| MailMerge under automation | 14 Oct 2006 11:57 GMT | 6 |
I create a mail-merge doc and attach a data source (query in Access db). When opened manually, everything works fine - ActiveDocument.MailMerge.State is 2 (MainandDataSource), ActiveDocument.Mailmerge.DataSource.Name returns the proper string.
|
| Creating Individual Files from one Large Report File | 14 Oct 2006 11:28 GMT | 1 |
I have a large .prn file that is opened in Word, containing sales information for multiple salespeople. I want to build a script that breaks the large file into indivdual .txt (or other) files for each salesperson. The manual process of doing so is extremely time intensive.
|
| Excel AddIn with TCP/IP socket communication | 14 Oct 2006 11:24 GMT | 1 |
We like to develop an Excel AddIn who communicate via TCP/IP socket (receive data) and fill up a table with this data. I have already developed an AddIn and I wrote C++ applications who communicate via TCP/IP socket. - Is that possible in an AddIn?
|
| Macro to Switch Pringer & # of Copies | 14 Oct 2006 07:58 GMT | 5 |
I am in the process of learning some basics about visual basic and was wondering if someone could give me a hand. I am familier with Java, but not visual basic. I have the following simple macro Sub Macro1()
|
| Reference issue | 14 Oct 2006 04:48 GMT | 3 |
I know this may sound strange but can anyone tell me if it is posible to refernce the normal.dot at runtime to a global template. I work for a company that has thousands of users of word in varying versions we want to be able to amend the normal.dot with certain information and ...
|
| How to refer to the last cell in a table without ColumnIndex? | 14 Oct 2006 04:22 GMT | 3 |
I need to determine if a cell is last in a table, but I can't check the ColumnIndex because the tables don't have consistent cell widths, so it gives me an error. Here's the old code that uses ColumnIndex: CellIsLast = IIf((theCell.Range.Information(wdStartOfRangeColumnNumber) =
|
| Set alignment in footer to center and insert text | 14 Oct 2006 04:13 GMT | 1 |
Hi All :) I would like to type a word in the footer on the first page of a Word 2003 document and have the word I inserted centered within the footer. I would like the rest of the document to retain the alignment that it is set at prior
|