| Thread | Last Post | Replies |
|
| VBA code disappearing from Project | 04 Jun 2007 22:14 GMT | 2 |
VBA code entered in a module (new macros) disappears or is stripped out when emailing between users. The code is there before being emailed and is there upon first opening (user gets Security warning to either disable or enable) macros. User Enables Macros allowing them to run ...
|
| Password Protected VBA Project | 04 Jun 2007 18:13 GMT | 1 |
I've inherited a VBA 6 Project that was originally written by a colleague, it relates to an Excel workbook and simply changes data received from an external source (received via a ".dat" file) into a format that can be read by another external system.
|
| Macro on exiting text box | 04 Jun 2007 15:18 GMT | 7 |
Can someone look at this code and tell me why it won't work? What I want to do is create a dropdown list in the Form Field called "Deduction1" if anything is typed into the Form Field called "CLS1". Sub CascadeList()
|
| Typographic Symbols translates and Converting and Macro | 04 Jun 2007 15:10 GMT | 1 |
User must download a document from a web source that is updated often. I cannot control the source that may be using WP. When I download to my machine or others with Word 2003 a certain type of Typograhical symbol font shows up. "G"s for boxes and "!" for bullet points. The ...
|
| RibbonX - macro won't run | 04 Jun 2007 15:07 GMT | 1 |
Hope that someone can point me in the right direction here: using... Win Vista-Enterprise Office 2007 enterprise
|
| Select Case won't read variable | 04 Jun 2007 14:51 GMT | 4 |
The following strScrap variable shows what I want in Intellisense (picks up the value from a table cell, each column being incremented on each pass of a while statement) but the Select Case statement doesn't work with the variable. Anyone see what I'm doing wrong?
|
| How to coding this problem! | 04 Jun 2007 14:05 GMT | 1 |
I created a form in MS Word and now I want to use it just by press "Show" button. The value of "text form fields" changed but it didn't show on the screen. I must double click on "text form fields" which I want it show after that I
|
| Mail Merge split | 04 Jun 2007 13:46 GMT | 1 |
Is it possible to run a macro which splits a word merge every 12 pages and save each page by a merge field and date. For example 120 page merge word be saved into 10 seperate documents. I am running a automatic mail merge for contracts and need to save each contract
|
| Adding Text Form Fields to a Document Header | 04 Jun 2007 07:25 GMT | 5 |
I'm trying to add a text form field in a docuements header and it appears that it cannot be done. True? If yes is there a useful alternative? I tried using a textbox, but, it really dose not render correctly. Any ideas? Thanks in advance for the help!
|
| No value given for one or more parameters | 04 Jun 2007 03:16 GMT | 1 |
Upon trying to do an "Insert into" statement into Access 2003, I receive the error: Run-time error '-2147217904(80040e10)': No value given for one or more parameters
|
| BuiltInDocumentProperties automation error | 03 Jun 2007 19:02 GMT | 1 |
the following line of macro code gives me an automation error when I open a new document. I know its probably because the newfile is not saved yet. But I have used condition such as, if 'saved' is not true not to run it. But doesnt seem to work.
|
| Trim leading/ending spaces from selection in vba | 03 Jun 2007 04:21 GMT | 3 |
I have a macro that selects the next/current sentence as a whole. I found it on a post around here. The problem is it often selects a space or two before or after the actual sentence, including often selecting the blank line above or below the
|
| Get document statistics - file info | 02 Jun 2007 21:48 GMT | 2 |
How do I access a file and get document stats such as FileName, Directory, Template, Title, Created, LastSaved, LastSavedBy via a macro. the files I want to excess are on a server. Any help will be appreciated.
|
| Collate all footer info into one page like a TOC | 02 Jun 2007 20:28 GMT | 1 |
my document is divided into sections Each section has about three pieces of information(wordcount, lengthin_h:M:s, sometext) in footers. How could I get them all into one page like a TOC
|
| creating array of checkboxes on useform | 02 Jun 2007 17:50 GMT | 1 |
I use the following code to create an array of checkboxes on a userform: Dim xArray() Dim xCount As Integer Dim xControl As Control
|