More Date problems
I have a macro that deletes returned records older than 7 days. It first sorts the data into returned date order then checks to see if the first cell is empty (no records returned) and if so, re-sorts the data into the original order (a different date) and quits. If the first cell contains a date less than 7 days old ie date >today()-7, again it re-sorts and quits, otherwise it deletes the data older than 7 days, re-sorts the remaining data and quits. At least that what is supposed to happen
The line to check the age of the date in the macro below doesn't work. G6 contains a control ...Excel 2003 file freezes laptop
I took a laptop away from the office and tried to open a large spreadsheet
on the local C: drive. Each time I tried the laptop froze and had to be
rebooted. When I connected back to the LAN at work, and opened the same
file on the local C: drive I had no problems.
What could cause this? If there is any corruption is there a way to
decompile or something as you would in Access?
....pst size problem
I know I am an idiot. I didn't archieve my Outlook 2003 .pst files when repeatedly prompted to do so. So I am admitting that right up front, and will understand the shower of abuse. With that understanding, my .pst file somehow reached over 4 gigs, but this was evidently not a problem until yesterday morning when Windows crashed for some unknown reason (black screen after POST).
I decided to take the opportunity to upgrade from XP to 7, and Outlook 2003 to 2007. After installation of Win 7, all my old files were intact under the Windows(old)file, and after I loaded Outlook 2007, I ...Microsoft.Crm.ObjectModel.MultiCurrencyPlugin + The given key was
I am working with MS CRM 4.0. I have made a custom entity which is having
some money fields. Everything was working fine. Suddenly while saving the
entity below message coming from applicaton:
"The given key was not present in the dictionary"
If i click ok then entity is not saving. I go to application server event
viewer log and saw below error details. Do any body face this issue, please
let me know, it is getting me too much trouble. I know it is related with
money field. I have to use money field in my entity. I have added some also.
Web Service Plug-in failed in Organiz...Help! Excel Formula
Below is an example of data in my excel sheet.
A B C D E F
Cell 1 ?
cell 2 Steve 1 to 10 13/2/04 britain
cell 3 Raj 11 to 17 15/2/04 india
cell 4 Ricky 18 to 35 14/2/04 Spain
Now if i enter a numerical value in A1 (where '?' is), i need a formula
which will check the column B and produce a result as desired below
Entery number = 9 then print "Steve 1 to 10 13/2/04 britain"
Entery number = 12 then print "Raj 11 to 17 15/2/04 india"
Ente...Money Updates: "Money encountered an error processing the download file ('SMRTINET.ini').
My M04 has not been doing Money Updates (other parts of update are doing so:
quotes, accounts) for a month now. The Call Summary for Money Updates says
Money encountered an error processing the download file ('SMTINET.INI').
Out of curiosity I looked for such a file name on the computer--none.
We have two accounts on Money. The other account is NOT encountering any
such problem--Money Updates are working fine for it.
No changes for either account of any seeming relevance preceded the loss of
updates on the one account.
(1) Does anyone know how to fix this?
(2) Thes...convert DVD to play on Microsoft iPhone Video player
[quote][/quote]Many friends ask me how to convert DVD to play on Microsoft iPhone Video player. I always recommend them Cucusoft DVD to iPhone Converter. It backup convert almost any type of DVD to play on Microsoft iPhone Video player. Moreover ,It?s a powerful DVD to iPhone converter with very fast conversion speed. The output also supports full screen viewing.I think it is very useful and easy to use too.So , I recommend this useful software to convert DVD to play on Microsoft iPhone Video player. Hope it can help you.I download it here: http://www.92download.com/wiki/Cucusoft_DVD...How do I do dashboard charts in Excel
I have 3 sets (budget, forecast and actual) of sales and profit numbers and
would like to show them like a dashboard ( two small circles for Budget and
Forecast and a bigger one underneath those two for Actual. All 3 circles with
a hand point to the numbers linked to the source data ). Can anyone tell me
how to make a start?
Thanks and regards
Here are some examples of speedo type gauges.
Nick Cheng wrote:
> I have 3 sets (budget, forecast and actual) of sales a...microsoft
...Printing Problem in SQL Reporting Service
Seen a couple of posts about this but no conclusion.
Trying to print a SQL Report from CRM and getting an error 0x80004005. These
reports can be seen on screen and exported but cannot be directly printed to
any printer. Checked all IE settings and put them as low as possible. The
only other thing that might be contributing is Sophos AV.
Any answers anyone ?
...Excel cannot find match
Using Excel 2003. Excel cannot find match for data that exists in
spreadsheet when using the Find command. Any fixes?
Perhaps Excel cannot find a match and doesn't need fixing.
Your data may need fixing.
Do you have extra spaces in the data?
Are you looking for "entire cell contents"
Are you looking for an exact match as in case-sensitive?
Are you looking in formulas when you should be looking in values?
See the available options under Edit>Find "Options>>" button.
Gord Dibben Excel MVP
On Fri, 8 Oct 2004 11:02:08 -0700, "GLH" <glhoo...Is Microsoft Visual studio 2005 upgraded version of Microsoft VC++ 6?
I'm in a confusion that some of my apps.exe wont work with VC++6 but
they do work on VS2005.
Is Microsoft Visual studio 2005 upgraded version of Microsoft VC++ 6?
So to install VS2005, prior to that do i need to uninstall VC++6??
ARe there much changes in .dll of VC++6 & VS2005?
> I'm in a confusion that some of my apps.exe wont work with VC++6 but
> they do work on VS2005.
> Is Microsoft Visual studio 2005 upgraded version of Microsoft VC++ 6?
> So to install VS2005, prior to that do i need to uninstall VC++6??
> AR...Microsoft Outlook to Microsoft Entourage
I just got my Mac and started using Entourage (by Microsoft) and cannot seem
to find how to get my PST to Entourage. There is support for Microsoft
Outlook Express but not Outlook...
Maybe export to OE first?
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Coauthor, OneNote 2003 for Windows (Visual QuickStart Guide)
Author, Google and Other Search Engines (Visual QuickStart Guide)
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com
Join OneNote Ti...Accidently deleted rows in Excel.
I'm not sure how it was done, but I accidently deleted many many rows in my
spreadsheet. I tried undo, but that's not working. How do I get all those
rows back? Thanks for your help!
Close the file without saving.
"Pelochino" <Pelochino@discussions.microsoft.com> wrote in message
> Hi all,
> I'm not sure how it was done, but I accidently deleted many many rows in
> spreadsheet. I tried undo, but that's not working. How do I...Excel not Access
I have designed an Access database that holds records relating to my stores
audit results going back for about 5 years plus a load more information
relating to these stores. This was used to produe a pack once a month,
however a change in senior management means that I have got to shelve this
and prodce a similar pack in Excel.
The idea would be that the user could select a month or a 12 mnth date range
that would produce data that could then be used to populate a number of excel
templates that have been designed. Having not used excel for years I would be
grateful for any suggestion...copy and paste from excel to ppt with VBA
I need to copy a lot of graphs from excel and paste them into a ppt
file using VBA code.
So far, I used this VBA code:
Worksheets("Slide01").Range("BB1:BF1").CopyPicture xlScreen, xlBitmap
and format of the object in the ppt is a bitmap.
Now I would like to copy the object like a "picture".
How must I change the above VBA code in order to do that? (please
consider that the presentation has a lot of slides, so it should remain
Thx a lot for your help
--------------------...Is there an Excel template for a 1-day Tennis American Tournament #2
Am trying to set up one-day American tournament for 28 mixed-doubles' pairs
.. Seven groups each of four ranked pairingson seven courts. Is there an Excel
or an Access template anywhere for the scheduling of games, league tables etc.
It says on the microsoft website that "Super Suite Deal. Buy Office
2004 and get Office 2008 Special Media Edition for FREE". I accessed
it before and it said that even if you buy a student and teacher
edition now, you get an Office 2008 Special Media Edition for free.
But then I clicked on this link from apple:
and it says that when you purchase an office 2004 mac student and
teacher edition you JUST get a office 2008 for Mac Home and Student
What's happening there?
Plus, on the mactopia website, the supe...Excel #26
I started a new job, and am having to build a call list for potential clients. When I find these companies on certain websites or what not, they are listed on a page from top to bottom, sometimes in the many hundreds of companies in one column..
Here is a link , to a sample of what I am working with .
But Imagine Column A cell values go to A4032, Which is how much information I have to enter.
SO I have list with over thousand company?s names and contact info,
But, I am getting company in...Backing up problem
Each time I back up my Money and close out of it, then
when I open it back up all of my accounts and information
are gone, and then I have to restore my accounts from my
backup. Also, when I back up it now takes three disks,
where before, it always only took one. I don't have
anymore information in it than I did before, so why is it
taking 3 now?
In microsoft.public.money, Melody wrote:
>Each time I back up my Money and close out of it, then
>when I open it back up all of my accounts and information
>are gone, and then I have to restore my accounts from my
>backup....Microsoft XML Core Services 4.0 Service Pack 2 (KB973688)
I have windows XP and this update fails to install tried it various
times..Can anyone help.
Microsoft XML Core Services 4.0 Service Pack 2 (KB973688)
Security updates for Microsoft XML Core Services 4.0 Service Pack 2 may
repeatedly appear in the update list on Microsoft Update or on Windows Update
See <http://support.microsoft.com/default.aspx/kb/941729/> for possible help.
If you can not rename msxml4.dll in normal Windows mode, than boot to
Safe Mode <http://support.microsoft.com/kb/315222>...Diff between microsoft.public.outlook and microsoft.public.outlook.general
Unfortunately, I can't download the "descriptions" that goes with each
newsgroup carried by my ISP. The names of the forums described in the
subject line above sound similar, but there must be a difference. Any idea?
J <email@example.com> wrote:
> Unfortunately, I can't download the "descriptions" that goes with each
> newsgroup carried by my ISP. The names of the forums described in
> the subject line above sound similar, but there must be a difference.
At one time there was, but there is no longer. Just choose one.
Brian Ti...microsoft XL
My version of microsoft office XP (microsoft XL) does not
contain the option of showing negative numbers in
brackets. The format/number command only allows a minus
sign or negative numbers in brackets.
Am I missing some other command?
Am I missing something in your post?
First you say
"does not contain the option of showing [negative numbers in brackets]"
then you say
"The format/number command only allows a minus sign or [negative numbers in
regardless the format looks like this
or do you mean
Peo Sjoblo...Problem installation CRM 3.0
While installating CRM 3.0 I get half way through installing and it come up
with this error:
Action Microsoft.CRM.Setup.Server.CreateSetupUserAction failed.
Exception from HRESULT: 0x8004415D
I have looked through other posts on this but none of the 'workarounds' fix
I have had a previous installation of which I would like to keep the data
for but have uninstallated and am now trying to re-install, I have also
removed the license from the dbo.License table. I only had the first
installation for one month, so should still have another 2 months left of the
Please...Excel click through
At work I can double click on a cell that is linked to another
spreadsheet and it opens that spreadsheet. How do u turn this on? Does
it work in office 2000 or do u need Office pro?
keithgg's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=29961
View this thread: http://www.excelforum.com/showthread.php?threadid=496590
uncheck Edit directly in cell
> At work I can double click on a cell that is linked to another