| Thread | Last Post | Replies |
|
| Using regular expression "\s+" in VBA | 13 Sep 2006 23:26 GMT | 2 |
I am having trouble using the RegEx "\s+" in VBA. I am using it to split a string that contains characters and spaces such as " 1 3 12 1 2 3 4 5 "
|
| Global Macros Template | 13 Sep 2006 22:47 GMT | 1 |
I apologise if this is not the correct forum for this question but I am not sure where else it would go. I have created several macros for office wide use and have placed them in a template that all users have access to on the network. Each
|
| UserForms +Error | 13 Sep 2006 20:04 GMT | 4 |
I've created a test document with a UserForm as detailed in the CreateAUserFormContent.htm document (http://www.word.mvps.org/FAQs/Userforms/CreateAUserForm.htm). I have followed the instructions, however, when I open my new template I get
|
| sort certificates in select certificate window | 13 Sep 2006 19:54 GMT | 3 |
I am using this code in a macro to sign a word document Set sig = ActiveDocument.Signatures.Add ActiveDocument.Signatures.Commit The code word fine, when word shows the "select certificate dialog" I need
|
| prompt user for information every time document is opened | 13 Sep 2006 19:11 GMT | 1 |
How do I prompt a user for information every time the document is opened?
|
| get UserForm1 value | 13 Sep 2006 19:09 GMT | 1 |
I have a module and userform1 in the doc. My module has six main functions that will be run once user click a custom toolbar that's connected for each function. The userform purpose is simply to let user input the value and then call a function that will process the value further ...
|
| Documents are being erased by 2's when opened | 13 Sep 2006 18:32 GMT | 4 |
When I open a word document up, the entire document is over written by 2's. What is the deal and how do I stop it?
|
| Getting the value from the useform into my document | 13 Sep 2006 15:24 GMT | 2 |
I am familiar with VBA in Excel but would like some help getting started in VBA for Word I created a for with the DT Picker control on it but would like to know how to go about coding it to put the value from this form after picking
|
| Getting value from userform into document | 13 Sep 2006 15:23 GMT | 2 |
I am familiar with VBA in Excel but would like some help getting started in VBA for Word I created a for with the DT Picker control on it but would like to know how to go about coding it to put the value from this form after picking
|
| Repeat code on each page | 13 Sep 2006 15:10 GMT | 6 |
I am new to VB and still getting a handle on things. How do I repeat the below code for each new odd numbered page. If this requires the use of line numbers instead of paragraph numbers to set the range, see the remark in code. Josha
|
| Cursor movement in excel from word (sendkeys?) | 13 Sep 2006 12:41 GMT | 2 |
How can I order the cursor within excel to move one cell to the right or to copy cells? After the copy command I would lijke to return to word and paste the cell value.
|
| Macro To Set Image Links | 13 Sep 2006 12:07 GMT | 10 |
I import documents from my Genealogy program that require the image links be reset (Edit>Links dialog). I have tried various ways of recording this dialog to a macro but nothing is recorded. I appears that the dialog window for resetting links may not support macro recording??? ...
|
| How to copy a worksheet from one workbook to another in vb6 | 13 Sep 2006 07:14 GMT | 3 |
I have 2 workbook(i.e. 1.xls & 2.xls) at 2 different location, I want to copy all the worksheets present in 2.xls to 1.xls file using vb6. I am trying to open both the files and then trying with this code... Workbooks("2.xls").Worksheets("sheet2").Copy _
|
| Combobox Rowsource | 13 Sep 2006 05:13 GMT | 2 |
I write vba code for combo box. formCombo.CmbDate.RowSource = "SELECT DISTINCT pp FROM SS ORDER BY pp;" but it doesn't work!
|
| Word VBA | 13 Sep 2006 01:14 GMT | 1 |
I am working on a Word document that has a built in userform. The userform prompts the user to input some data, the data is then written to various other Word documents. What I want to do is open an Excel and write the same data to a specific cell in the doument. Here is the ...
|