Please help..with a formula. I don't know code.
I have a long list of numbers - values in a file X, and I want to fin
and replace those values in a even larger list in a file Z an
highlight those values in Z
Message posted from http://www.ExcelForum.com
not really sure what you're trying to achieve. What do you
want to replace, etc. You may give an example (plain text -
no attachment please)
>I have a long list of numbers - values in a file X, and I
want to find
>and replace those values in a even larger list in a file
>highlight those values in Z.
>Message...Publisher file made in Publisher 2007 won't open in 2007
I produced an 8.5 x 11 brochure two days ago in Publisher 2007. I was able
to save, resave and reopen the file many times during the day. When I tried
to open the file today, I get the "Publisher cannot open the file" error
message. I've tried to open the file on two different machines with
Publisher 2007 and get the error message both time. One has XP Pro, the
other has Visa Home Basic. It's a 1.6 meg file. I have a smaller publisher
file of a bumper sticker (40 kb) which was made a couple of weeks ago which
opens with no problem.
This is the second time I ha...Microsoft Money 2007 Deluxe Canadian version?
I have been looking for Microsoft Money 2007 Deluxe Canadian version and I
cannot find it. Where can I get one?
There isn't one. See http://money.mvps.org/faq/article/422.aspx
Microsoft MVP - Money
For UK tips & fixes see
I do not respond to any emails that I have not specifically asked for.
"masai" <email@example.com> wrote in message
>I have been looking for Microsoft Money 2007 Deluxe Canadian version and I
>ca...does vista installed on virtual machine 2007 get wsus updates ?
It is searching for updates but it is not finding anything and saying
that Windows is up to date. I have set the updates to install from the
wsus server and assigned the updates to the same Vista virtual machine
aconti's Profile: http://forums.techarena.in/members/73272.htm
View this thread: http://forums.techarena.in/active-directory/1290161.htm
If the machine is getting the correct GPO for the WSUS settings, check with
rsop...Office 2007 trial is very slow. Is this because it's a trial
I just started using the trial version of Office 2007. It takes forever for
it to open on my computer but Office 2003 opens just fine. Is this just
because it's a trial or is it naturally slow because of the additional
It's likely due to the expanded feature set and increased hardware
requirement over Office 2003.
> I just started using the trial version of Office 2007. It takes forever for
> it to open on my computer but Office 2003 opens just fine. Is this just
> because it's a trial or is it naturally slow because of the ad...Can't edit print styles in Outlook 2007
Weekly calendar view to print - Define print Styles - Edit "CANNOT DISPLAY
THE DIALOG BOX"
I'm using trial version - shouldn't be the case????
I'm having the same problem where I cant edit the print syles ... please let me know what ou find out.
I think being able adjust the format and print the calendar is important, as I usually print my calendar.
EggHeadCafe.com - .NET Developer Portal of Choice
This is an Excel newsgroup. I would suggest posting this to an Outlook one
Microsoft MVP - Excel
Southampton...preview text disappears when email is opened
When someone responds to an my email, I can see what they have typed - until
I open the message - then only my original message is viewable. The preview
pane shows new message text when email arrives, hoever when the email is
opened the preview text disappears - and I just see the earlier part of the
message which I had sent.
If I mark it as unread it does not return to the previous state.
This seems to happen on email responses that people have received and
answered from a webmail service not that they downloaded and opened in
outlook on their PC
OL'03 XP pro sp2
Respectfully,...How can I wrap text across merged cells?
I'm using Excel 2000. I have a set of merged cells A5-
E5. I have several lines
of text in the cells and I want them to wrap across the
merged cells and it is not working. All I get is the
first line of text showing and the rest is cut off. It
works if the cells are not merged, but I really need to do
it in my merged cells. Is there a way to this other than
manually resizing the height of the row?
Instead of merging cells, have you tried the "Center Across Selection"
The appearence is just about identical to what you would get using merged
cells, although I d...Office 2007 SP2
Has anyone else lost the little check box which is usually found next to
each task in the task list in Outlook today? I'm assuming it's a bug?
"Carmen Gauvin-O'Donnell" <firstname.lastname@example.org> wrote in message
> Has anyone else lost the little check box which is usually found next to
> each task in the task list in Outlook today? I'm assuming it's a bug?
Nope - still there...
Asking a question?
Please tell us the version of the application you are asking about,
your OS, Service Pack level...Multiple Bar Codes Per Item
I'm looking to use Microsoft RMS for a medium sized game store with
one terminal. One critical feature is the ability to have multiple bar
codes assigned to the same item. Can RMS do this?
If you are talking about multiple part numbers, yes, use the alias function.
Remember what a barcode is. Its a graphical representation of a partnumber
that is machine readable. It doesn't describe the item, it is only a number
to reference that item. Just like your phone number, it means nothing, but
everytime someone dials that number, it gets to you.
"gareman" ...z-order of various lines and bars in an Excel 2007 chart
What is the procedure for changing the z-order of various lines and
bars in an Excel 2007 chart, such as drop lines, high-low lines, up/
down bars, and error bars?
I observed that when I add drop lines to an Excel 2007 chart, they
appear in front of the underlying data -- in my case, the underlying
data is displayed as a plotted area. I want the plotted area to be
fully visible with no lines over it.
I would like to send the drop lines to the back and keep the plotted
area in the front, but there is no option to do this.
So, is there a procedure for adjusting the z-order of drop...Contact looses Post Office Box field when synchronized to Outlook
When I sync contacts from CRM 4.0 to Outlook, the Post Office Box field from
the contact gets empty.
Anyone has the same issue?
...Error Code 80070424 12-21-09
I keep getting this Windows update error every time I boot my PC. In the
window, it says Windows can't check for updates. Does anyone have any ideas?
Recently I installed BitTorrent so could that be my problem?
"Norm" <Norm@discussions.microsoft.com> wrote in message
> I keep getting this Windows update error every time I boot my PC. In the
> window, it says Windows can't check for updates. Does anyone have any
> Recently I installed BitTorrent so could that be my proble...VS 2005 beta question
I need to complie some code. I am going from 16bit to 64 bit. The job do
not want to spend the money on VS 2005.net. If I compile the code with the
beta version or trial version of VS 2005.NET will it time bomb on me?
Thanks in advance
The code won't, but eventually the compiler will stop working. Don't know
if the trial will support 64 bit though.
I guess you get what you pay for.
"karibbean" <sharp_mind@REMOVE.this.email.msn.dotcom> wrote in message
> I need to complie some cod...vba code to enable macros
Can we write a vba code to enable macros. In most of the sites it says
we cant do that . The only thing we can do is change the macro setting or
work around is hide the sheet which has macros. But none of them will work in
my case. Can we change an excel security setting to from macro on open so
that macros are enabled.
No. If we can do that with code, then so could a hacker with bad intentions.
"varsha12" <email@example.com> wrote in message
> Can we w...Outlook xp Offline folders vs O2k3 Cached Exchange mode
I recently upgraded a group of executives from Outlook XP
to Outlook 2003. I used the "upgrade" option. I also
installed O2K3 SP1. They all have laptops and use offline
folders. Several have had various offline folder issues
since the upgrade. Is there something I need to configure
in order for them to continue to use their offline
folders? or Does Cached Exchange mode replace Offline
folders? Are there known issues with the upgrade and
offline folders? I'm not sure what to look for.
Thanks in advance for your time!
techguyasap <firstname.lastname@example.org&g...Outlook 2007: is there a way to use it as a Diary
I'd like to keep a daily journal of important notes, etc. In other
words , I would like to keep a Diary. Does Outlook 2007 have this
Sure - Ctrl+8 to view the journal or you can create a Mail and Post folder
type and post to it.
Diane Poremsky [MVP - Outlook]
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com/
Outlook Tips by email:
EMO - a weekly newsletter about Outlook and Exchange:
mailto:EMO-NEWSLETTER-SUBSCRIBE-REQUEST@PEACH...Upgrade Path from DPM 2007 to DPM 2010
Is there going to be an upgrade path from DPM 2007 to 2010?
Yes. Look at the following DPM 2010 documentation:
"DPM supports upgrading from DPM 2007 SP1 on a Windows Server 2008 x64-bit
operating system to DPM 2010. If DPM 2007 SP1 is installed on a Windows
Server 2003 x64-bit operating system, you must upgrade to Windows Server
2008 before upgrading to DPM 2010".
Also, here are my notes on DPM 2007 to DPM 2010 upgrade:
http://santhoshsivarajan.blogspot.com/2009/09/dpm-2007-t...Errors found Code 80070490
This appears to be one of those problems that no one seems to have a working
solution. Reinstalling an operating system is not a solution it’s a reason to
change operating systems. This type of problem was not supposed to happen
with Vista. Let’s see some big guns on this one!
Some Updates not installed:
2 Failed updates (KB967723, KB972145)
Errors found Code 80070490 (Unknown Error)
Problem Event Name: WindowsUpdateFailure
UpdateId: AE2C61ED-AC12-4369-BED6-4375CD79CA...Unread mail not showing up in Inbox
My Unread folder in located the "Favorite Folders" section in Outlook
shows that I have more unread mail than I can see in my Inbox. My
Inbox is normally sorted by "Received" so I can see the most recent
emails as then arrive. If I change it so that it is sorted by the
"From" column, I can see all the emails in the Inbox that are
appearing in the Unread folder. It is strange that they don't appear
using "Received" though. Emails that fall under any rules are not
affected by this so rules are irrelevant in this case I suppose.
Also, some additio...Error in Code
Following is some VBS code I have in my Custom Form developed in Outlook
2003. Line 61 is giving me an error stating:
Object doesn't support this property or method:
Line No: 61
If you look Line 51 is the same method and it works fine. The funny thing is
when I run the code, I get the error, I continue on to the Form, and the
code after it works. The code that follows line 61 is dependent on line 61
as evident by if I ' comment it out, I get a separate error asking for
objPage2. The code also works if I change the value of one of...sent and received fields
I've just switched from Outlook Express to Outlook 2000. In one of my
folders, I have sent and received emails that I want to sort together based
on the sent or received date, but all my sent emails sort together because
the received field has no value. And the same for the received emails. Is
there a way to combine these fields or tell Outlook to sort based on both of
them? Do I need to write a VBA macro to accomplish this?
...Exchange 2007 Mailbox Folder information not updating
Operating System: Mac OS X 10.6 (Snow Leopard)
Email Client: Exchange
I am using Entourage 2008 Web Services Edition in an Exchange 2007 SP1 UR4 environment. I have only been using the Web Services Edition for about a week and prior to that I was using the regular Entourage 2008 client for four months. In any case, the problem I am about to describe occurs in both versions of Entourage 2008. <br><br>Recently my employer's executive group decided to implement Managed Folder Policies to assist in controlling mailbox size. I was the first to...Option for fields to show up in datasheet view
Since most people are more familiar with excel then access, my users prefer
to see it in datasheet view. However, since it could be too long, anyone can
help me how to make an option to show up only field that we can chose in the
I remember there is a sample of database that has that one, but I do not
know where is it now. Please help.
Thanks in advance,
Simplest solution might be to set the Visible property of the controls on
the form, based on the fields the user wants to see.
Allen Browne - Microsoft MVP. Perth, West...Provide space in text
Where text and numbers are at different locations in different cells what
formula could be used to suit this type of information. I want to be able to
put a space between the main body of text on the left and give a space
between the text and the start of any numbers are in the cell.
A1 = Abelia Edward Goucher2 litre
Abelia Edward Goucher 2 litre
A2 = Acer campestre Nanum180stem 6-8
Acer campestre Nanum 180stem 6-8
Thankyou if can be of help.
If you double clcik in the cell with the data then you can move th
blink line to were you wan...