| Thread | Last Post | Replies |
|
| External program call from Excel VBA | 26 Jan 2007 13:34 GMT | 1 |
I am working with large set of data there are extracted and created by SAS. But the final calculations are made in Excel. Is it possible to call and execute the SAS-file by VBA code? If so, a few hints would be appreciated very much.
|
| I want Excel.exe not to start when clicking Linked Excel Object on a Word doc. | 26 Jan 2007 13:34 GMT | 6 |
Any assistance would be appreciated... I have tried to paste an Excel worksheet on Microsoft Word with "paste special". When I double-click the pasted Excel worksheet in MS Word, Excel starts.
|
| Forcing new instance of Word | 26 Jan 2007 05:57 GMT | 2 |
I have a VB 6.0 application that creates an instance of Word, opens a document with a specific template and makes it visible. If the user manually opens Word, a new document is opened in the VB object referencing Normal.dot. How can I force a new instance of Word if the user ...
|
| truly weird Word 2007 vba problem | 26 Jan 2007 05:50 GMT | 1 |
This one's a bit complicated and hard to describe, and a very weird problem. I have a template -- call it MyTemplate -- that, at creation time (AutoNew), allows the user to specify various initial content and
|
| Msg Box to Save Document | 26 Jan 2007 05:43 GMT | 1 |
Trying to find a way to click a command button and have a message box pop up asking for name to sae document thanks
|
| How do I get the total number of graphics/pictures in a word doc? | 26 Jan 2007 05:02 GMT | 3 |
I'm writing a macro that iterates through a word document and operates on each picture it finds. I need to be able to find the total number of pictures in the file to control the for loop. I have successfully done this with tables using ActiveDocument.Tables.Count, but there ...
|
| Modify windows language from VBA Code | 26 Jan 2007 00:48 GMT | 2 |
I have a program that modify the windows language inside Excel. Call ExecCmd("rundll32.exe shell32.dll,Control_RunDLL intl.cpl" + ",,5") When I execute this command, the language inside the control panel is changed but the number displayed in Excel still show the old language. If I ...
|
| Automation add pages from other documents | 26 Jan 2007 00:09 GMT | 1 |
Using VBA I would like to add pages from other documents to a template a quote template. Say I have 10 parts (documents) which I wish to add to another document, docs 1 thru 10, each of these has parts of a quote, terms and equipment.
|
| creating an editable format-locked form | 25 Jan 2007 23:53 GMT | 1 |
I have no idea where to post this as this is my firs time on this site. I am the editor of a journal (www.herpconbio.org). If you look at one of our articles, you will see that we have standardized layouts.
|
| How do I make individualized reports for each row of excel data? | 25 Jan 2007 22:10 GMT | 1 |
I have an excel spreadsheet and I need to make an individual report for each case. I have the text formatted in word, is there an easy way for me to link it so that it will make an individual report for every state or am I doomed to embed each individual field? I thought that ...
|
| Making fileds line up on a Word doc using Visual Basic Editor | 25 Jan 2007 20:50 GMT | 1 |
Hi everyone! I am new so I hope I am posting my question in the right place. I have created a form in Office 2007 using Visual Basic Editor. I am trying to make two lines line up regardless of the number of characters before the fields. Example:
|
| Use Macro(or VBA) to automatically replace m2 into m2(superscript) | 25 Jan 2007 17:24 GMT | 3 |
I have many technical documents and am asked to replace all m2 into m2(superscript). The <Tool> -> <AutoCorrect> method is not applicable since all these documents are existed.
|
| Convert string to date | 25 Jan 2007 15:24 GMT | 5 |
Sorry this is so sad, but it's been awhile: I have a 6-digit string representing a date. That is, "123005" has been input. It means 12/30/05, but it's defined as a string. I want to convert it to the date value for 12/30/05 (not for 10/09/2236).
|
| Word XP Macro Language | 25 Jan 2007 10:52 GMT | 2 |
Is the macro language for Word XP any different than the macro language for Word 2000? If so, then what are the differences? Thanks. --
|
| VBA problem in Word | 25 Jan 2007 08:50 GMT | 2 |
Can someone help me to write a vba script which will print the document using the following logic: For example I have a document which consists of 10 pages. I want to print the pages 10, 8, 6, 4, 2 and the script will wait using an msgbox. After
|