count the number of new lows within a range of cells
Is there a formula or method to count the number of new lows within a
range of cells? For example, the following are in col A rows 5 to 14.
Within this set a new low has been reached 3 times- (96,95,94). What I
would like is a formula or macro that that would produce the results -
3. There are about 9000 rows of data and I am looking for "count of
new lows within the preceding 10 rows" on a rolling basis.
Use this if the 9000 or so rows don't have blanks in them.
In this version you just need to select the first cel...Running out of memory?
How do I increase the file size allocated to my Outlook
2002 emails? If I download, say, 5000 emails I will
quickly run out of room in the Outlook file. How do I
increase the Outlook file size?
...Outlook 97 won't run on my Windows xp
Hi I recently installed office xp on my system every program works
except for Outlook , which starts and says building outlook bar then
please help, or is there another contact program that I can use with
active sync so I can get data onto my pocket pc ,
email@example.com <firstname.lastname@example.org> wrote:
> Hi I recently installed office xp on my system every program works
> except for Outlook , which starts and says building outlook bar then
> just quits
In the subject you say "Outlook 97" and in the body you say "Office XP",
whi...Macro to run when opening doc
Is there any way to make a macro run when opening a specific document??
Tks in advance
Yes, you can name the macro 'AutoOpen' or call it from a macro so-named in a normal code module.
Alternatively, you can use a 'Document_Open' macro in the document's 'ThisDocument' module, instead of the 'AutoOpen' macro.
[Microsoft MVP - Word]
"Antonio" <Antonio@discussions.microsoft.com> wrote in message news:965EBAAC-A781-4163-9530-8454EDE1832B@microsoft.com...
> Hi all
&g...Run Code in General Module Upon Activation of Other Sheets
I have VBA code residing in a general module of a workbook. The outpu
from the code updates several sheets in the workbook. I would like t
automatically Run the code in the general module if any of thes
several sheets are activated (by clicking on the sheet�s tab). How ca
I do this?
Message posted from http://www.ExcelForum.com
You can use the folowwing events in the sheet module(not a normal module)
Right click on a sheet tab and choose view code.
Paste the events in there and press Alt-Q to go back to Excel.
You can copy the code in the event or type the macro name ...Copying pst file while Outlook running
Is it possible to copy my local pst file to backup while my Outlook is
Any program I try to touch it (including DOS bat files with the copy
command) result in an error message that another program is using it.
"Hall" <email@example.com> wrote in message
> Is it possible to copy my local pst file to backup while my Outlook is
> Any program I try to touch it (including DOS bat files with the copy
> command) result in an error message that another program is usi...space #4
i am downloading data from a program and pasting it to
EXCEL. there are times when in certain cells a small box
appears which I believe represents a space or who is ever
entering the data hitting ENTER. Is there a way to
remove this from all the cells?
Select the import, do edit>replace, put the cursor in the find what box, hold
down alt key while typing 010 on the numeric keypad, release alt key; Leave
replace with blank or put a space there, click replace all.
> i am downloading data from a program and pasting it to
> EXCE...Running on low free space
That little monster alert keeps popping up every two minutes when I am
on the console. I have gotten it so that I have 161 MB of free space,
but when I start to do a virus pattern update with Trend Micro it drops
down to about 45 mbytes, and the update craps out with a statement that
the update is 80 per cent and the action is uncompleted. What can I do
to get more free disk space from this hog. There is 18 Gigs in the
system partition and I am at SP1, and not going any further.
Can I get rid of all the uninstall points related to KB?
There are three log files that are rea...Run Excel file on a Server
I have an 8 meg excel file that needs to be shared with a whole team who
connects to our web site with a very slow connection. Is there a way to
"run" an Excel file on a server, so that the user is actually only loading
the "tab" that they are using vs. loading the entire file everytime they want
to look one thing up.
This Excel file is updated regularily. Sadly, it won't work to just
distribute it on CDs.
Thanks in advance!
...Routine to run/export queries
Looking for some links to examples that do the following (or something
1. user would create a whole bunch of queries themselves (using Access)
2. form that lets the user runs these queries to display results and/or
3. Would be good if user could select multiple queries and get multiple
resultsets to display or be exported to
an excel file with multiple worksheets. Example: user selects 5 queries and
wants an excel file made with 5 tabs with the 5 different outputs of the
queries, or the outputs of the 5 queries show in a form with multiple tabs
in Access (hide...Running total field
I have built an education assistance database for tuition reimburstments. The
running total field I have on the data entry form needs to reflect how much
each employee has received in the current calendar year.
The school information, semester and dollars are in a sub-form of the data
entry form for employee information. I have a running total control on the
employee form that pulls from the subform school, however I can not get it to
calculate only between dates of 1.1.2008 and 12.31.2008.
Any help will be appricated.
On Wed, 26 Dec 2007 06:48:01 -0800, Michael ...Still unable to run successful query
I've used the IFF suggestions given but it returns only Not Active results.
I'm working on a case problem that reads:
Create a query to display all matching records from the tblProgram and
tblMember tables, selecting the ProgramType and MonthlyFee fields from the
tblProgram table, and the FirstName and LastName fields from the tblMember
Add a calculated field named MonthlyFeeStatus as the last column that equals
Active if the MembershipStatus field is equal to Active and equals Not Active
Assuming MembershipStatus is a string (varchar) data field,...Data Migration Framework for MS CRM 3.0 doesn't run
I've downloaded and installed the Microsoft Dynamics CRM 3.0 Data
Migration Pack, which contains the Data Migration Framework for CRM
But, when I launch the DMF by going to:
Microsoft Dynamics CRM Data Migration Pack->
Data Migration Framework
I get a busy mouse cursor that changes back to a regular arrow pointer
and nothing happens.
When I try to launch DMF again, I get a windows error saying that a
copy of the DMF framework is alread...How do I set a macro to run at specific times?
I have recorded a macro which I want to run automatically every hour. Could
someone tell me how I do this
You can read about the scheduling procedures at Chip Pearson's site:
> I have recorded a macro which I want to run automatically every hour. Could
> someone tell me how I do this
...Can not run money2004, Need Help!
I installed money2004 standard in my laptop with windows
xp OS (SP1) successfully. But when I can not run it. The
money report "Microsoft Money has encountered a problem
and needs to close. We are sorry for the inconvenience.".
And the error detail is "AppName: msmoney.exe AppVer:
184.108.40.2063 ModName: ofdutil.dll
ModVer: 220.127.116.113 Offset: 0000ce2d". I try every
thing I can,"restart windows","uninstall it and installed
it again","uninstall it and install money deluxe demo
(download from microsoft website). But it is still not
reporting th...DataSet.ReadXml Method does not read/load space
There is a space(as a data) in one of the columns. And i save my DataTable
as a xml file using DataSet. I used DataSet.WriteXml method to save as a xml
file. Now if I read that .xml file using DataSet.ReadXml method,it removes
space in that DataTable. Any idea...?
This does not work in Visual Studio .NET 2003. If I execute this in VS .Net
2005, it works. I must make it work in VS 2003.
Here there is a sample that does not work in VS NET 2003:
DataTable dbTable = new DataTable();
...Unable to set up on-line account
Missage I get when I try to connect to an on-line bank.
I checked my internet connection and it's working. I'm
able to open IE browser within Money 2005. Please help.
Money cannot complete a required online call at this
time. Please check your Internet connection settings and
Another reference to M05, what's going on?
> Missage I get when I try to connect to an on-line bank.
> I checked my internet connection and it's working. I'...Outlook: "Can not save free/busy information"
When I create any new tasks, reminders and events in outlook I get a little
flash window in the bottom corner of my screen saying "Can not save free/busy
information". So every time I restart outlook it loses my newly added items.
I have tried closing outlook and opening the mail option in control panel and
deleting the outlook .pst file and reading it but that did not seem to
resolve the issue. Any help or ideas would be appreciated.
Outlook version please? Have you tried running Detect and Repair?
Milly Staples [MVP - Outlook]
Post all replies to the gro...230,000 Members Pay You Money, Join for FREE today!
Come Join the 230,000 Member Team !!!
You simply CANNOT LOSE with 230,000 people HELPING and BUILDING YOUR
Click the link below to find out how you can benefit from all those
230,000 people right now !
...Run a macro based on the value of a cell
I have what seems to be a simple task but can't seem to figure it out. I
have a excel file that has the tabs "Current User List" & "Prev User List"
On these sheets the first row is called "status" which is either "curr" or
"prev" to indicate employee status. I copied and modified the macro posted
on this site for copying an entire row to another worsheet and it works fine
but I'd like to go one step further. If I change the status of an employee
on the "Current User List" to "Prev" I want ...ScanPst have run time attributes?
Does ScanPST have attributes you can put after scanpst.exe. Such as file to
scan and to run repair automatically after detection finishes, without
having to hit enter. My PST is large and would like to have it run during
Nope. The program takes no command line parameters or switches and requires
the user to enter the name of the .pst file that requires "fixing". There
is at least one commercial alternative, "Advanced Outlook Repair" by
DataNumen, Inc. I have no experience with this product but it advertises
that it supports command line parameter...outlook won't start
Still having trouble - have string of emails from 1/31 but no solution -
outlook says run scanpst.exe; tried, it says pst file is open - I have
nothing running that I am aware of that would tie to the pst file.
Rebooting, safe mode, last good configuration, none of those things help.
Is Outlook closed when you run the repair tool? Check your task manager >
processes to make sure outlook.exe isn't running.
"GretaJo" <GretaJo@discussions.microsoft.com> wrote in message
> Still having tro...Is there anyway that I can download free MS-office software from
Is there anyway that I can download free MS-office software from
internet?...My system crashed recently and I can not afford buying it
Since you said system crashed, assume you mean the Office products
themselves as opposed to templates, etc.
If your machine had the software preinstalled by the OEM (original equipment
manufacturer), such as DELL you should either have software CDs or the
software is in on some hidden area of the harddrive. Contact your OEM.
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcrit...Can CRM be installed on a Windows 2003 Server running Sharepoint Services and Sharepoint Protal Server V2.0?
Will the standard install for CRM work on a Windows 2003 Server?
Would there be any conflicts if the Windows 2003 server is already running
Microsoft Project Server?
Would there be any conflicts with Sharepoint Services V 2.0 or Sharepoint
Portal Server V2.0?
I attempted to run the CRM on 2003 Server, but quickly ran into issues
accessing the workspace once installed. CRM 1.0 is not yet compatible
with the .Net Framework 1.1 that's on 2003 Server
"Bill Walter" <firstname.lastname@example.org> wrote in message news:<Os304M1RDHA.email@example.com>...
&g...Scroll bar space
I have several tabs each with one subform displayed. I have coded the
current event of each form to only display the vertical scroll bar if the
record count > 19. This works as desired, except it leaves space for the
scroll bar when one isn't displayed, making the right hand side of the form
look slightly untidy. Is there any way to get round this please?
Thanks in advance for any help.
You could resize the subform control (decrease or increase its width) when you
hide or show the scroll bar.
Access MVP 2002-2005, 2007-2009
The Hilltop Ins...