Going between documents using macros
I'm using Word 2004. I have two documents open. Is there a way, using
macros, to go from Document 1 to Document 2, where I'll go to a
certain line and copy it, then go back to Document 1 and save it using
the text I have just copied.
I have the macro down for going to the line, copying, and saving. What
I need is the part where I go from doc to doc without regard to the
document name. So I'll be in "Active Document" first, then I need to
go to "?" (other Document) then back to "Previous Document."
So I just need the navigation part.
Here...Data Transfer Among Dialogs, Views, and Documents
OS: Windows 2000
IDE: MS VS .NET 2002
I'm a novice MFC developer and I have run across a problem I was
hoping someone could assist me with.
I'm developing an SDI application with multiple views. In one of the
views, I have a button that opens a dialog. I would like to have this
dialog dynamically modify several of the controls based on information
from the document class. The controls that need to be modified all
have associated member control variables added to the dialog class. In
my application, the view class processes information and stores
numerical values...remove underline from 2007 document
I am trying to Remove underlining on a word document. I figured out how to un
bold. Please help
Ctrl+A to Select All. Then Ctrl+U twice to remove underlining.
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
"Milew" <Milew@discussions.microsoft.com> wrote in message
>I am trying to Remove underlining on a word document. I figured out how to
> bold. Please help
your suppose to click underline then click undue clear button....Multi page document
I am creating a proceedures manual. I now have 40 pages. Is there any way
to identify pages? Example, can I rename page icons in the page sorter? I
want to be able to go straight to the page that discusses for example,
entering a new customer into the database with out having to hunt for it.
Let the folks know which version of Publisher.
Also, how about creating a PDF file from the Publisher file.
Don - Publisher 2000�
"Marie" <Marie@discussions.microsoft.com> wrote in message
news:AAA880A1-82F0-4D6E-B5DD-7214FFD977FD@microsoft....How do I access a previous version of my Excel document?
I have made changes to my document, but need to be able to retrieve complex
formula's back from a previous version. Is there any way i can get this done?
Unlikely. Excel does not save previous versions.
If you saved it somewhere else, or e-mailed a copy to someone, that might
help. Otherwise, you are out of luck.
"Jo" <Jo@discussions.microsoft.com> wrote in message
>I have made changes to my document, but need to be able to retrieve complex
> formula's back from a previous...Documenting Smartlist Reports beyond report name
Is there a way to document within GP further information about
smartlists. I would like to be able to write a 2 or 3 sentence
explanation of the uses of the report, etc. that would be readily
available such as in a report properties but I don't see any such
...Document Library Metadata
Recently, we had a user report a problem with saving metadata in one of our
document libraries (reported recently, but no telling how long it was going
on without being reported). The library uses a pre-made excel file as the
template, and has two pieces of metadata that it prompts the user for on
save. Uploading a document to the library works just fine, but when saving
directly to the library from Excel, it prompts for the metadata, and then
does not actually save it to the library.
Going back in after the fact and adding the information again also works
fine, but we cannot ...Merging XML documents
I would really appreciate any assistanance with the following situation.
Lets say i have 2+ documents A,B,...n that i need to merge together, such
that the resulting documents contains totals or sum of the common elements.
<emp ID="1" Items="20">emp 1 name</emp>
<emp ID="2" Items="15">emp 2 name</emp>
<emp ID="3" Items="5">emp 3 name</emp>
<emp ID="1" Items="15">emp 1 n...GP 8
We have several old items that currently need to be deleted. We created a
script to delete all but about 200 of the 1600 inventory items that need to
be deleted. Most of them deleted fine (some required adjustment of
quantities), but I'm stuck with the last 200 items.
When I try to delete the problem items, I get the following error message:
"The item exists on a document and cannot be deleted."
The items haven't been used for quite a long time (several years). I've
deleted all of the old orders and quotes from 12-31-04 and before, but this
hasn't fixed the pr...How to extract documents from .msg files
I have a folder where Email Messges are saved (.msg files). Arounf 200 files
all containing 1 attachment (a word document)
What I intended to do is that any programme or process by which the
attachment (word file) can be saved in a folder eigther in the same name of
the email ID or or Name of the file.
If this is not possible then if all the attachment (word files) are
extracted or put in a folder will also help me a lot.
You can write Outlook VBA code to use the Application.CreateItemFromTemplate
to create a new item based on the .msg file. From that item, iterate its
Attachments c...How do I print 100 copies of a document, each copy with a number?
I have a document that staff need to print out daily and fill out. Each new
page needs to be numbered. How do I get Word to print the same page many
times and each with the next number in the header?
On Mon, 14 Dec 2009 20:01:01 -0800, Matt
>I have a document that staff need to print out daily and fill out. Each new
>page needs to be numbered. How do I get Word to print the same page many
>times and each with the next number in the header?
See http://www.word.mvps.org/FAQs/MacrosVB...In-Document Hyperlink Tweaking
In Excel 2002 SP2, I've created various in-document
hyperlinks that link accross different worksheets in the
same file. I have specified which worksheet and which
cell I want the hyperlink to link to.
When clicking on a hyperlink, it brings up the
correct "area", but sometimes the target cell is at the
bottom of the page or in the middle. I want the target
cell to be at the top of the page when I link to it every
time. It's like excel is being lazy and assumes that just
having the target cell somewhere on the page is good
enough... It has...Accessing the root node of an xml document
Hopefully someone can assist me establish how to access the root node
and the first level node of an XmlDocument which I have loaded as per
the code below. So far, all I can achieve the output I need with the
root node hard and the first node coded. In the foreach I retrieve is
next child node ("Customer").
Using ChildNodes fails and no other property or methods of the
object return the data I need.
private XmlDocument myDoc = new XmlDocument ();
txtWriter.WriteStartElement ("CustomersInfo"); // Hard coded
txtWriter.WriteStartElement ...spotlight won't find a document by searching for a word in that doc
Operating System: Mac OS X 10.4 (Tiger)
Spotlight will find a Word document if I type in a word in the title. Usually I do not know the title. <br>
If I type in a word contained within the document, it will not find it. <br>
Spotlight will find a document by a word contained in the document if it is a pdf or rtf file. it will not do it with microsoft products as it won't do it with Word and excel. <br>
I called Mac. They said that my spotlight was funcitoning properly and that microsoft did not design their office products to do this. When I use...table into Word Document
I have data in the cells of an excel spreadsheet so that it looks like a
table. I can print this out and it looks good (margins, font, etc). How can
I get this data/table into a Word document without losing the formatting? I
have tried inserting a page break into Word and then copying/pasting but that
doesn't seem to work. HELP?!!?
Copy the way you were doing it. Then, in Word select: Edit, Paste Special,
> I have data in the cells of an excel spreadsheet so that it looks like a
> table. I can print this out and it...Slow opening of word document with automation
In the following code with wich I open a word document from access with
automation it takes about 20 seconds before the file is opened. What can
cause this? I heb tried to disable the viruscontrol but this won't work. I
have added 2 msgbox commands to count the time between 1 and 2 and this is
about 20 seconds.
Sub OpenWordDocument(Documentnaam As String)
On Error GoTo HandleErr
Dim Teller, AantalWoorden, WordApp As Word.Application
On Error Resume Next
Set WordApp = GetObject(, "Word.Application")
If err.Number <> 0 Then
Set WordApp = Cre...Smartlist Builder Documentation
It would be very helpful to have documentation on what tables are used
to generate the standard smartlists. For example, I want to expand upon
the sales transactions smartlist using smartlist builder. So a
screenshot of the tables and how they are linked in a builder window
would save some effort.
Isn't there something like this available somewhere?
...Linking to a Document or Presentation
I have been having some difficulty establishing a hyperlink to a document or presentation. When in hte design mode i hit CTRL and the hyperlink and the Document opens fine. When i preview the web page i hit the link and nothing happens. I should note that when i link to a web site it works fine. It is just when trying to launch an applicaiton like word. Finally, i noticed in the source that the link address is preceeded by "File:\\\
...set up a macro that prints the document when opened
How do we set up a macro in Word(2003) such that when the document is opened,
a print request is sent automatically.
Create a macro named autoopen() that contains the code
Hope this helps,
Doug Robbins - Word MVP
Please reply only to the newsgroups unless you wish to obtain my services on
a paid professional basis.
"stud91" <email@example.com> wrote in message
> How do we set up a macro in Word(2003) such that when the document is
>...regarding master doc/ sub documents
I'm new to using master document/ sub documents function in MS word.
I have a question regarding that. I've created a master document with
several subdocuments. Several times, when I open the master doc, some of the
subdocuments are not there. Yes, I think I've made some changes to those sub
documents but never changed either the names nor the locations of those
subdocuments. It feels like I'm using a feature that is not stable enough
which makes me quite nervous about using this. Does any of you know what's
going on or any suggestion regarding how to use this...Bizarre Excel/Word Document Opening Problem
Whenever I open a document in MS Excel 97 or in MS Word 97, I get this
"A document with the name [insert name here] is already open. You cannot
open two documents with the same name, even if the documents are in
To open the second document, either close the document that's currently
open, or rename one of the documents."
But I don't have two documents open. all of my documents have a unique name.
This happens all the time, even after restarting. I use Windows XP Home and
this has always been the case since I bought the computer.
The on...XML document and XML schema
We have a requirement to utilize some sort of data storage, and XML
strikes as being as viable a technology as the next one.
I have started by using the XMLSchema designer to cook up a minimal
schema to get us started.
Now I'd like to take that schema and start a new XML document based
upon the schema.
I'm somewhat of a newbie to XML when it comes to this, so I may not
even be utilizing it correctly, so please bear with me.
Is this a valid operation to do in the .NET framework? If not, how
might we generate an XML document based upon the XML schema we cooked
Thanks...Recent Documents Disappear (Excel / Office 2000)
I am currently experiencing a problem with Excel 200, whereby the recent
documents list is not working properly.
I can open a document, save it and close it and it will appear in the
recent documents list (within Excel), but if I close Excel and re-open
Excel, it is no longer there.
The keep recent documents option is ticked and set to 9 documents (I have
also tried with 8 documents ;) )
It does seem to keep some documents sometimes, but I cannot see any
pattern as to what is remembered or why.
Are you running TweakUI?
If so, you may have disabled the M...mdi app with controls dialog use whithout document/view modele..
i just come back to mfc with visual c++ for 1 month..
with mdi model, each document can have multiple view of them.ok
how can i do to have only one view at a time for each document.??
i want to present differents forms and differents objets in my app, but
don't want multiple view of one or more document..
how to do to declare them in the app.??
i want to use cformview or other class for displaying my objects.
please, help or examples will be grantly appreciated.;
Not sure if I understand you correctly, but you might consider looking
at an SDI application instead of MDI?
Chaudebert wro...Excel Recent File menu listing
In ExcelXP or 2003, is there a way to list the files that
you want to open in the File menu? So, no matter what
other excel files that you opened. The files that you want
is always listed in the File Menu.
Any help would be appreciated.
> In ExcelXP or 2003, is there a way to list the files that
> you want to open in the File menu?
Not AFAIK. What I tend to do is record macros in personal.xls to open the
Workbooks.Open Filename:= _
"C:\Documents and Settings\Andy\My Documents\home.xls"
, then assign the macros to a custom me...