Repeating data on matching cells
When the data column C matches the data in column A, I need the data
in columns C and D to be repeated for all matching rows.
This is my data:
a b c d
009701449-2 071712 009701449-2 071712
009701449-2 071712 009701452-4 008710
009701449-2 071712 009701455-7 008710
009701449-2 071712 009701460-1 008710
009701449-2 071712 009701465-6 058617
009701449-2 071712 009701467-8 059602
009701452-4 008710 009701468-9 059602
0097...Printing WORD docs from a form
I have a button on a form and I want it to print a Word mail merge document
that contains data from the database that is linked to my application.
I'm using the following code but always get a 5922 error - Word can't
open the source... All variable names contain valid data, so that's NOT
.Visible = True
.MainDocumentType = wdFormLetters
strConnection = "DSN=MS Access Databases;" _
& "DB...where is that save data feature for backup?
On sql 2005, where is that console that allows me to save my data
to a directory for easy backup? If I remember correctly, I can set this
on a schedule too? I was shown this a few years back, and for
my life I can not remember where it was. :'[
ToddAndMargo (ToddAndMargo@invalid.com) writes:
> On sql 2005, where is that console that allows me to save my data
> to a directory for easy backup? If I remember correctly, I can set this
> on a schedule too? I was shown this a few years back, and for
> my life I can not remember where it ...problem with BOLD. ITALIC...using Word as editor
I compose a msg using Outlook. Word is the editor. I set a word in bold
ot italic. I send msg to myselg, reading in Outlook. The bold or italic
is gone. What to do?
Are you sending the message as text only? If so all formatting will
disappear. If you want to retain your formatting you'll need to send your
messages as HTML. You can check this in your Outlook options.
Martin Sketchley | www.msketchley.pwp.blueyonder.co.uk
(remove EGGBEANSANDSPAM to reply by e-mail)
...Delete all rows except...
I receive a weekly report & have been asked to delete all rows except
for two particular rows. Here are the two criteria which are in column
AWH98228 and AWL99467
Can anyone offer help?
.ScreenUpdating = False
.Calculation = xlCalculationManual
LastRow = Range("A" & Rows.Count).End(xlUp).Row
For r = LastRow To 2 Step -1 'Headings in row 1
If Range("A" & r).Value <> "AWH98228" _
And Range("A" & r).Value <> &quo...Windows XP: Open file in read-only: Word, Excel, Visio
I'm often sharing files on a network drive with someone. Often, one
of us knows that we don't need to open a file for modification, and we
only need read-access. Is there a way to open a file in read-only
mode so that when someone does need to open it for modification, the
read-only user is not blocking that?
If there is not a way to do this native to Windows XP, is there a way
to do it from the three applications that we use most, namely Word,
Excel, Visio? All are 2003 versions.
I used to save files like this in "read only recommended" mode.
File|SaveAs|Tools|Ge...Copy and paste to the last row
Dear ALL, pls help me for macro.
I want copy the last row of column A, B and C.
and Paste the row down.
Example, my last row of A is A120, copy cell A120:C120.
then Past to A121
Thanks so much
if i understand correctly, this should work for you....
Dim r As Range
Set r = Range("A65000").End(xlUp)
r.Resize(1, 3).Copy Destination:= _
> Dear ALL, pls help me for macro.
> I want copy the last row of column A, B and C.
> and Paste the row down.
> Exam...Not enough memory error trying to open a Word X file
Operating System: Mac OS X 10.6 (Snow Leopard)
Error message: "There is not enough memory or disk space available to complete the operation" when trying to open a Word X file in Office 2008 in Leopard or Snow Leopard on iMac that works fine in Word X despite resaving a new version. Any tips?
Not enough information to answer.
Check that OS X and Office 2008 have the latest updates applied.
Use Disk Utility to Repair Permissions.
Check the access your user ID has to the system Temporary folder (don't
worry about this if you ar...hiding cells with a certian type of formatting
How do I get excel to hide cells that has not been formatted in a row or
colum that I applied a format condition to.?
just for clarification...do you want the entire cell row or column to b
hidden, or do you want the text color of the contents of just that cel
to be changed to WHITE or whatever color would hide it given its fil
Excel_Geek's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2642
View this thread: http://www.excelforum.com/showthread.php?threadid=39828
...Cannot upgrade to Word 2007 from Word 2002 as word crashes when tr
We have a word add in that programatically inserts an auto text table then
adds rows to it. This works ok in Word 2002 but occasionally crashes in Word
2007 - this is not a consistent crash when we carry out the same operation it
happens in no specific sequence. The only place we are able to track it down
to is the auto text table inserting rows. Word itself is crashing.
We are using COM AddIn written in VB6.
Does anyone know of any key differences/issues between Word 2002 and Word
2007 that could cause such an error.
Or is there a better way to attach a debugger/word debugg...Can't apply a background
I'm using the Microsoft Step by step Visio book and I'm on page 96 trying to
apply a background to a practice file from the CD supplied with the book.
I'm using a trial copy of Visio 2007. I can't apply a background. Is this a
known bug or an undocumented feature?
"Roger" <Roger@discussions.microsoft.com> wrote in message
> I'm using the Microsoft Step by step Visio book and I'm on page 96 trying
> apply a background to a practice file from the CD sup...Word 2007 TOC Not saving settings...
When I use Word 2007 TOC, and I want to edit an existing TOC layout, etc. It
wont remember my settings.
I go to
Table of Contents
Insert Table of Contents
Then I make my chnages here, such as changing the levels of the various
styles and how they show up
Then I select OK, the TOC is created..
I then decide I don't like the changes I made, or I need to include another
So I go to
Table of Contents
Insert Table of Contents
The changes I made are no where to be seen. I have to start over from
What am I doing wrong,...Macro to split the contents in a single cell separated by "," into next cell in that column
I have sheet 1:
column A column B columnC
WR# Phase SP#
Row2 60625 1-0110 60625RB1,60625NS1,60625GW1,60625BB1
Expected Output on clicking a button:
column A column B columnC
WR# Phase SP#
Row2 60625 1-0110 60625RB1
Is there a way to split the contents in cell C2 separated by comma (,)
and place it on next cell in column C itself?
Ple...Encoded Word Documents
We have recently purchased a new pc with windows 7 and have installed the
Microsoft Office software however when I got to open a PDF or word document
from a webpage a file conversion pop up box comes up and asks for me to
select the encoding that makes the document readable but none of them do.
even the windows default doesn't work......
You cannot open a pdf in Word. You need Adobe Reader.
What you're downloading from a web page probably isn't a Word
On May 27, 4:25=A0pm, Newuser <Newu...@discussions.microsoft.com> wrote:
> We have rece...Where can I get a copy of the Microsoft calendar control?
In Excel 97 I have a calendar control. Those files with the calendar control
do not work in Excel 2003, because I don'd have the calendar control in Excel
2003. Is there some type of calendar control for Excel 2003?
I think there's a link to a free calendar control at the bottom of Ron de
> In Excel 97 I have a calendar control. Those files with the calendar control
> do not work in Excel 2003, because I don'd have the calendar control in Excel
> 2003. Is there some ty...Filling in Cell above with Data from below
Have data where I need to fill in A1 with A2 Data, A3 with A4 and so on:
Need it to end up like:
How can I do this?
visit www.ExcelGoodies.com If A1 and A3 are blank:
Select A1:A4. Press Ctrl+G. Click special, blank.
Start typing a formula:
Then press the down arrow key. This should finish the formula and create:
Press Ctrl+Enter to apply formula to all currently selected cells.
If needed, you could then do a copy, paste special - values only.
If A1 and A3 are not blank, but you want every other line copie...message disappears too fast; how can I see it?
Outlook 2002, SP3. I've noticed when I exit the program, as it is closing,
it puts up a rectangular message box (after the main window has closed),
then closes it immediately. It takes just a fraction of a second, just long
enough for me to see there's something there, but not long enough to see
what! If you have any idea what this could be, or how I could slow it down
so I could see it, let me know. The program seems to operate correctly in
every other respect, I just don't know what that blazing fast message box is
trying to say.
Randy Nevin wrote:
> Out...Bulk E-mail with Non-Word Attachment
I need to be able to send a bulk e-mail (not from a template) with
attachments of a number of different document types to a group of contacts
(could be from a Saved View or Marketing List). Direct E-mail, Quick
Campaigns and Mail Merge do not seem to be able to do this. Is there another
Take a look at this blog
On May 16, 11:57 pm, DStella <DSte...@discussions.microsoft.com>
> I need to be able to send a bulk e-mail (not from a tem...auto rcvd email retrieval
3 mos. new to this world, after a ten-year hiatus, this AM, for, starters, I'm adding a disconnected table to a burgeoning contractor's .mdb.
tblMyControlNumbers shall be keyed with a string I can find in the Author property of some .docs and maybe .xls's and it looks like this: "Jim Shores_1040000, Jim Shores_1040001, _1040003, and so forth and so on.
Well, yesterday, there was a online order-form field at some mail-order house that called for a .Purchase Order Number'. Which means I have recieved a email with "Jim Shores_1040029" in its body.
How ...Word Wrap: Where is it in Word 2007?
I have Googled and Googled and cannot find any page that tells me where
Word Wrap is. For such a basic feature you'd think it would be under
On Mon, 18 Jan 2010 18:55:28 -0600, "Gary Gary" <email@example.com>
>I have Googled and Googled and cannot find any page that tells me where
>Word Wrap is. For such a basic feature you'd think it would be under
The reason you aren't finding anything is that word wrap is automatic
in Word unless you turn it off, or possibly if something is broken.
Wha...Where are my saved word?
I open the attachment directly, it is .doc and edit it in a loong time, what
I ask is when I press save button and it show nothing so I think it succes.
And I close it!! I can't find it now, could you help me ????? Thanks!
It is gone. When editing an attachment, you /must/ save it to your HDD
first, edit it and then reattach it.
Imperial Beach, CA
"smezsc" <firstname.lastname@example.org> wrote in message
>I open the attachment dire...Does Office 2003 Pro Excel have auto-save?
I am trying to set up Auto save in Excel 2003 Pro. I found auto recovery but
that is not what I am looking for. I think it may be an add-in.
ehop, From a previous post by Dave Peterson:
If you're running xl2k or earlier, install the autosave addin via
windows|Start button|settings|control panel|Add or remove programs
If you're running xl2002+, then if you can find a copy of the autosave addin
from an earlier version, it should work ok.
But xl2002+ has something called autorecovery. It's not the same as
but will allow you to recover files if excel/windows c...Data, Group got error message Cannot shift object off sheet
I created a command grouping several columns together by going to Data, Group.
When I go to click on the "-" sign to group. It gives me an error
message;"Cannot shift object off sheet". Why? and how can I fix it.
Maybe you have some objects that get rearranged when you hide the columns using
your grouping symbols.
This may have some suggestions that work for you. It's kind of a similar
XL: "Cannot Shift Objects Off Sheet" Error Hiding Columns
Remember to look for comments and merged ...maximum rows limitation in an access 97 table
we have an access97 db which has 32405 rows, is there such
a limit of 32700 rows in access 97 and if there is, can
this be rosolved by upgrading to Access 2000 or higher.
> is there such
> a limit of 32700 rows in access 97
No, the limit is that the database cannot be larger than 1GB. Check out
other specifications in Access Help, using "specifications" as a search
criterin in the Search Wizard.
"GM" <email@example.com> wrote in message
>...word 2002 compatibility with Windows 7
My niece is handicapped and her new computer has Office 2007 on it. She
would like me to install word 2002 on her Inspiron 546. Is this possible?
Yes, if it is licensed for another computer. If it is an OEM version, it
cannot be installed on any but the system with which it was sold.
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
"Sharon F" <SharonF@discussions.microsoft.com> wrote in message
> My niece is handicapped and her new computer ...