Reply:

Existing word documents made on PC
Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Processor: Intel 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
Dear experts, 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 -- Jacob "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. Example: 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? Thanks, Eddie Try =LARGE(A1:C1,2) VBA Noo -- VBA Noo ----------------------------------------------------------------------- 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 it repeats. What are you wanting to do with the info? To return position (column number) of number 1234 within row 2: =MATCH(1234,2:2,0) A formula that signals it's the first occurence: =COUNTIF($A2:A2,A2)=1 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? BUMP! adriangibbons@yahoo.co.uk (Adrian Gibbons) wrote in message news:<34a2acd5.0404130713.123dbaab@posting.google.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. ------=_NextPart_000_001E_01C9EB9B.D3E3CDF0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hello, 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. In news:7430603D-8534-4235-A16D-D073B471EF85@microsoft.com, abundantmind <abundantmind@discussions.microsoft.com> 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 program. Thanks again for all your help Gordon As ALWAYS, post your code for comments & suggestions. -- Don Guillett Microsoft MVP Excel SalesAid Software dguillett1@austin.rr.com "Gordon" <gwelch1938@yahoo.com> wrote in message news:1184612089.486737.144020@n60g2000hse.googlegroups.com... > 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 computer. 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, Dee 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? -Hal "Randy Cushman" <rcushman@wolfgreenfield.com> wrote in message news:369401c3dc3f$564db750$3101280a@phx.gbl... > 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
Hello, 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 Peter Peter, That triggers the Workbook_WindowActivate event, you can use that. HTH Bob "Peter Ostermann" wrote in message news:i9m5v8$7bv$02$1@news.t-online.com... Hello, 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" <kcshelley@discussions.microsoft.com> wrote in message news:8B67765F-4CEF-438D-A74E-143C600B7813@microsoft.com... > 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 original message. -- 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 servers 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 out why???????? Thanks ...

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 please help -- Lorenzo Díaz Cad Technician ...

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
Version: 2004 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 "shipton80@officeformac.com" wrote: > 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 Sub macfindrow() 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, _ After:=Range("A1"), _ Lookin:=xlformulas, _ Lookat:=xlpart, _ ...