Existing word documents made on PC
Operating System: Mac OS X 10.5 (Leopard)
I have a number of documents made on a PC that include images - scanned, from the internet, etc. They look fine when opened by Word for PC, but when the same file is opened by me using Office 08 for Mac, some (not all) of the pictures appear absolutely minute, in the top left of the image box. The image box is still there, so the text alignment is not affected, but the rest of the text box is blank. I have even had a colleague open the file on her PC to show me the image is fine, then email me the same image - with the s...Workbook cells won't hold formatting in Office 2007
I have Office 2007 running in Vista Home Premium. My system got FUBARed and
had to be reloaded. Now my Excel workbooks won't keep the proper formatting
in cells. I have them formatted as general so that I can type in something
like 4 - 1. As soon as I do that it converts the formatting to Custom and
puts it in as a 1-Apr. If I try to reformat the cell as general I then get
39904. If I enter it as space 4 - 1 then it enters correctly.
How can I make the cell give me the correct information without putting a
space in front of it?
One way in to format the cell as Text B...Find Duplicate names and delate
I have a small doubt could you clarify that???
That is I find duplicate name but I want to delete one name only, if I
filter DUPLICATE….. both names are showing…
1. Select the range of data including the header. You need to have headers
for these columns
2. From menu Data>Filter>Advanced Filter>Copy to another location
3. In 'copy to' specify the target cell and check 'Unique records only'
4. Click OK will give you the unique list
"Find Duplicate names and delate" wrote:
> Dear experts,
> I have a small ...I need to compare 3 numbers and find the one in the middle
I have three numbers in a single row and would like to identify the middle
number enter that number in another cell.
1st # 2nd # 3rd # result
628 678 720 678
655 625 700 655
748 720 725 725
is there a function in excel that can do this?
VBA Noob's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=3383
View this thread: http://www.excelforum.com/showthread.php?threadid=56811
fasteddie wrote.....Find a Value the first Time It Occurs
I have a row of values that shows the total cumulative number of sales of
items by month. Occasionally, there may be no sales in a month for an item
so the cumulative value would stay the same for more than one month. I want
to select a number in the row the first time it occurs and not select it if
What are you wanting to do with the info?
To return position (column number) of number 1234 within row 2:
A formula that signals it's the first occurence:
This could be used in a helper row, or as a conditional format f...Finding a Median
I'm trying to write a query that will return a median for various
values taken from a previous query. I've seen some suggestions in my
searching, but I haven't been able to get them working. They are also
all from before 2003 and refer to Access 97 and 2000.
Has any functionality been added to 2003 for this? Or is there a non-
code-based way to do it? I've seen it suggested to write a code to
open the query, sort it, find the total number of records, divide it
in half, then seek out the middle record using that value. I'm still
very green when it comes to code, though...Find/Replace in RichEdit 2.0
I'm using Windows ME and I've switched from RichEdit 1.0 to 2.0 for my
CRichEditDoc/View application so that I can use the ITextDocument
interface and can do things such as suspend/resume the Redo buffer.
Problem is, now the Find/Replace dialogs don't seem to do anything. If
I revert back to RichEdit 1.0 they do!
What's going on?
firstname.lastname@example.org (Adrian Gibbons) wrote in message news:<email@example.com>...
> I'm using Windows ME and I've switched from RichEdit 1.0 to 2.0 for my
> CRichEditDoc/View application...Outlook 2003 freeze when opening new message/replying/forwarding
This is a multi-part message in MIME format.
I am using Office 2003 on Vista Home Premium platform and MS Word as =
editor. Have been doing this for years, and I have the same setup in =
multiple computers (other computers with XP Pro).
Lately, the one in the Vista machine developed a pause when click on a =
New Mail, Replying or Forwarding, for about 5 seconds. Everything else =
works normal and I didn't have this problem in the begin...Office 2004/Leopard
Word version 11.5.5 (090513)
Excel version 11.5.5 (090512)
Powerpoint version 11.5.5 (090514)
Mac OS 10.5.8
Recently Word, Powerpoint and Excel have been crashing pretty regularly.
Seems to mainly be at Quit or when closing a file.
I have tried FontNuke, repair permissions and a few other troubleshooting
steps, but to no avail.
Any ideas to help stablize things? Thanks.
Additonal System tidbits:
Model Name: MacBook Pro
Model Identifier: MacBookPro4,1
Processor Name: Intel Core 2 Duo
Processor Speed: 2.4 GHz
Number Of Processors: 1
Total Number Of Cores: 2
...I have Korean Office...I need English (US) Office
LIPs don't seem to provide me with a solution...apparently there is no
English LIP!?!?!?!?!? Seriously? That's crazy!
LIP = Language Instruction Pack?? Why NO English? Where is Windows /
Office developed? America, right?
I'm in Korea. I bought a Korean computer. It came with Korean Windows. I
need English menus and whatnot on my MS Office applications.
abundantmind <firstname.lastname@example.org> typed:
> LIPs don't seem to provide me with a solution...apparently
> there is...Find (but not find)
My program takes a name from sheet3 goes to sheet1 to Find the name.
If it cannot find name, how do you do an If/End to Exit Do while or
find out if name has been founf? I have "On Error Resume Next" in
Thanks again for all your help
As ALWAYS, post your code for comments & suggestions.
Microsoft MVP Excel
"Gordon" <email@example.com> wrote in message
> My program takes a name from sheet3 goes to sheet1 to Find the na...Outlook 2003 HTML Reply Selection Spell Check Bug
I received an email in Outlook. The email was in HTML format. I
started a reply to the message. I then selected only part of the
reply text and hit F7 to check the spelling of the selection (selected
text only). A message box pops up stating "Finished checking the
selection. Do you want to check the rest of the item?" There were
obvious misspelled words that simply were not checked. If I say Yes
to "check the rest of the item" the misspelled words are found as
would be expected. If the reply is only one word (not likely
normally) and you select it and check spelling...Office 2008 components deleted from mac library. How to get them b
I'm using a Macbook running Leopard.
I recently attempted to delete my browsing history on my Macbook (I went to
Finder, clicked on Search For in the sidebar, clicked All Documents, and
dragged them all to the trash). Obviously my intention was only to delete the
history but in fact I ended up deleting every document I ever opened on the
There was no option to undo, or to restore the files (approximately 9000) to
their original location, so I had to just drag them out of the trash to the
desktop and manually sort them back to their original location.
That worked for mos...Find value in a column and insert rows above
The set up looks like this:
ColU ColV ColW ColX
Y N N N
Y N N N
N Y N N
N N Y N
N N Y N
N N Y N
N N Y N
N N Y Y
Columns will always be U through X and will always be sorted in this order.
I need to find the first Y in each column and insert 2 rows above that row.
On the blank row above the first Y, I need to highlight in yellow and put
title in the first cell, such as New, Old, Existing, Deleted.
Any help would be greatly appreciated.
Thanks for your time,
If desired, send your file to my address below. I will only look if:
1. You send a copy of this ...Limiting Out of Office Assistant responses.
We've had a request from the US District Court to filter
out Out of Office Assistant replies to their mailbox. I
have a specific address that I don't want OOA to reply
to. Any ideas, on the client or server side, how I'd go
about this? Thanks for your help. Randy.
What about just setting up a rule to delete?
"Randy Cushman" <firstname.lastname@example.org> wrote in message
> We've had a request from the US District Court to filter
> out Out of Office Assistant replies to their mailbox. I
> have...OutLook in XP Office Pro producing this error:
After upgrading from Office 2k to Office XP Pro, I am
getting the following error message. I imported my "old"
archive and it had/has a folder called "BladePro". Each
time my archive runs, I get this message. I have searched
my entire hard drive and there are no other archive
folders so where is it finding a second "BladePro"
folder? This is irritating, to say the least.
Error while archiving folder "BladePro" in store "Archive
Folders". A folder by this name already exists.
If possible, please send your suggestions to:
rweeks@cableon...Finding an event
I am developing an app that uses a single worksheet to enter data. When user double clicks a button, a new window (in same workbook)
opens with a new sheet. My problem is that excel does not seem to have any events for close of window if there are multiple windows
in a workbook.
Can someone help
That triggers the Workbook_WindowActivate event, you can use that.
"Peter Ostermann" wrote in message
I am developing an app that uses a single worksheet to enter data. When user
double clicks a button...Auto signature is adding spaces and enlarging font on replys?
Auto signature is adding a few space inbetween lines and enlarging font on
'some' reply, not all.
"kcshelley" <email@example.com> wrote in message
> Auto signature is adding a few space inbetween lines and enlarging font on
> 'some' reply, not all.
That's because Outlook replies using the formatting information in the
Brian Tillman [MVP-Outlook]
...Out of Office
Currently I have Exchange 2007 and all clients are OL 2003. When a out of
office is received by the client it is duplicated.
In my remote domains section config:
* - Allow external out-of-office messages and out-of-office messages set by
Outlook 2003 or earlier clients or sent by Exchange Server 2003 or earlier
mydomain.com - Allow external out-of-office messages only
I am 90% sure this is causing my issue, but unsure how to fix it.
Has anyone come across this??
...Outlook 2002 closes sporadically when send reply
I have Outlook 2002 SP2 connected to an Exchange 2000
server mailbox. The mailbox size is approximately
240MB. There are about 22,000 items in the Inbox and
about 30,000 items total in all folders.
My issue is that sometimes Outlook will close when I send
a reply. I am unable to determine a trend as to why this
happens since it happens sporadically with no regard to
recipient, time of day, other programs running, etc. I
completely removed Office and re-installed it on the
Windows XP Home Edition SP1 computer. The problem
persists. Any suggestions would be much appreciated.
...cannot find database
I have an excel spreadsheet that is supposed to update a access db.
Whenever I try to save the .xls I get an error stating cannot find db.
Even when I open the db with access, I get the error and the db opens
anyway?????? This only happens on 2 out of 20 pc's and I cannot figure
...Sum if Condition is Equal in Range Date and find column
I want to make a sum if Range is a week number and if style is Equal to
CONC-92 or CONC-45
Week# 49 Week# 50
CONC-92= 27 CONC-92= 30
CONC-45= 27 CONC-45= 30
Datas are in a pivot table and...
Pivot table looks like this:
Date CONC-92 CONC-45 CONC-92 CONC-45
12/7 5 5 10 10
12/8 2 2 10 10
12/9 5 5 10 10
12/10 5 5 10 10
...Office product key incorrect after reformat of computer
After reformatting my laptop which is running on the Vista OS, I reinstalled
microsoft office 2007 standard using the CD provided when I bought my laptop.
I could reinstall office 2007 however I am facing problems with activating
the product. Each time i keyed in the product key provided on the CD sleeve
of the office 2007 CD, i was notified that the product key is incorrect and i
have to key in the correct product key. I've tried several times and also
rebooted my laptop but to no avail. I have also made sure that I've read all
the digits and letters correctly. Is it pos...Office wouldnt open
Operating System: Mac OS X 10.4 (Tiger)
Processor: Power PC
When trying to start up office i got a error report so tried uninstalling and reinstall, now when i try to install office 2004 i get a error message and says that it needs to close when using the office setup assistant any ideas on how i can install office cheers
> When trying to start up office i got a error report so tried uninstalling and
> reinstall, now when i try to install office 2004 i get a error message and
> says that it needs to close when using the of...Trapping a NO FIND after a find
I use the code below to store a row number to a variable after a find.
I would like to trap a NO FIND if the find is unsuccessfull
Any ideas. FSt1 provided the code below
dim rn as string
dim rng as range
dim therow as long
rn = inputbox("enter something to find")
if rn <> "" then
Set rng = nothing
Set rng = range("A1:IV65536").Find(what:=rn, _