Is there a way to automate the changing of a date in the
footer only when a change has been made in the data.
e.g. Revised on <date>.
Excel doesn't have a feature that changes the footer when a cell is changed.
You could run a macro to make it easier to enter the new footer, e.g.,
ActiveSheet.PageSetup.CenterFooter = _
"Revised on " & Format(Now, "m/d/yyyy")
...Activex Windows Media Player control issue
I have a form with an Activex WMP control, and I wish to have the control
play a .wma file when a command button is clicked. I want the .wma to be
determined based on the currently displayed record (i.e. the record refers to
a song, and I want that song to play). If I hard-code the path to the .wma
into the Player.URL field, it works fine, but if I try to use a variable
(constructed from fields and constants), it does not. I get an error "The
file you are attempting to play has an extension (.wma") that does not match
the file format. Playing the file may result in unexp...All my icons look the same (except IE8 and the recycle bin)
i cant open any windows...when i click on them the open with window pops up
and wants me to pick wat i want to open it with...i can only get on the
internet in safe mode with networking. and when i try to open...for example
paint it says invalid bitmap, or its format is not currently supported and
other windows wont even open.
got any ideas on how i can fix this??
On Sun, 30 May 2010 06:54:01 -0700, xxkoreanxx wrote in message
> i cant open any windows...when i click on them the open with window pops up
> a...Looking for feedback
Hey everyone just started my own business doing consulting / training for Microsoft Outlook please check out my site www.outlookchallenged.com and provide any suggestions / feedback please. Any advice is good advice at this point.
Br Sense <firstname.lastname@example.org> wrote:
> Hey everyone just started my own business doing consulting / training
> for Microsoft Outlook please check out my site
> www.outlookchallenged.com and provide any suggestions / feedback
> please. Any advice is good advice at this point.
The best advice I have to offer ...Highlighting date cells before the event elapses
I need to set up an equipment calibration chart. This means that I will need
to look down the chart and see if a piece of equipment is due for testing
(about 2 months should do it). If anyone has any ideas about how to flag up
the cell with the due date I would be hugely appreciative.
I'm using office 2000 (I think)
lots of ways to approach this .... depending on how much information you
want stored (ie do you want a history of equipment calibration or are you
just going to keep last & next dates for each item?).
if you want just last & next then one way would be
.........Looking for CRM Solution
Does anyone use, or has anyone encountered, a CRM based solution used for
residentail, multifamily property management?
On Apr 28, 12:55=A0pm, MrB <M...@discussions.microsoft.com> wrote:
> Does anyone use, or has anyone encountered, a CRM based solution used for
> residentail, multifamily property management?
The beauty of Microsoft CRM is that it can be customized for any
business in any industry. It's ability to be customized using front-
end tools (not within code) is , as far as I know, unparalleled by any
other software package. You have the ability to create new entiti...=COUNTA() with multiple look-up
I would like to count the number of items that have a value "AAA" in
column A and an amount >0 in column B.
As I am not quite sure how to incorporate two look-ups in a counta
formula I was wondering if anyone can give me the formula?
Try something like this:
or....if there may be some text cells in B1:B100 interspersed with the numbers
Is that something you can work with?
&...can I edit a picture to look faded?
I want to edit my picture to be faded so I can use it as background with text
"deborahm" <email@example.com> wrote in message
> I want to edit my picture to be faded so I can use it as background with
> over it.
In Publisher you can do it one of two ways. For both ways start by
inserting the picture.
Method 1, right click on picture and select Format Picture, click on picture
tab, then click on the dropdown for Color under Image Control and select
wash...data look up and return values across a row
I have a list in one spreadsheet, we'll call it 'spreadsheet A' that I need
to cross reference with another larger spreadsheet, which we'll call
'spreadsheet B'. I'd like to remove everything from B that isn't on A. Is
there an easy way of doing that?
Chip Pearson has lots of info about working with duplicates at:
> I have a list in one spreadsheet, we'll call it 'spreadsheet A' that I need
> to cross reference with another larger spreadsheet, which we'll call
> ...Public Folder Access Issues
Here is a wierd one. (Please do not referance the
article "Removing the first exchnage server in your Org"
been there, done that)
I have rehomed all public folders to NEW server.
Unmount Public Folder store on OLD server.
Outlook 2002 clients can no longer access Public Folders.
Outlook 2003 clients can access Public Folders, no problem.
I upgraded a non working 2002 client to 2003, and boom,
there are fixed.
What is the differance? What is the setting on the client
that needs to be updated to find the Public Folders on the
Definalty looks like a client and no...eConnect 9.0 Date Format
I'm posting transactions to GP 9.0 Receivables, SOP Invoice and Project
Account Misc. Log Transaction using C# in Visual Studio with the .NET
Each of the transactions require one or more "Date" fields such as the
Invoice Date or "doc date". Each of these transactions fail with the message
"Date not in correct format". I've looking in the PA10200 (Misc. Trans Log
Header) Table after manually entering a Misc. Log Transaction in GP and the
date is in the format of "2006-05-06 00:00:00.000". In the eConnect examples
the date...Looking for basic multiplaction formula
I'm trying to multiply cells d5-d9 by cells a5-a9 and
put the answer in cells d14 - d18 ( using caps )
I have tried =(D5*A5)
in d14 and then pulling it down to d18
PLEASE HELP ME IVE BEEN AT THIS FOR AN HOUR AND A HALF!!
Sounds to me like you had it right... what's not working?
In cell D14 enter "=D5*A5"
Copy that and paste it in cells D15 to D18.
Ken Puls, CMA - Microsoft MVP (Excel)
> HI ALL,
> I'm trying to multiply cells d5-d9 by cells a5-a9 and
> put the answer in cells d14 - d18 ( using caps )
> ...Looking for sheet to handle MPG, etc
I am looking for a sheet to handle gas mileage.
things like MPG etc.
It would be great to have a ready made sheet
to handle this info
Message posted from http://www.ExcelForum.com
This shouldn't be too difficult unless you attended college at Texas A&M
=miles driven/gallons used
"supermario >" <<firstname.lastname@example.org> wrote in message
> I am looking for a sheet to handle gas mileage.
> things like MPG etc.
&g...look up who is connected
i would like to check if any pc connects to my xp box which it shares a
lot of dirs.
can powershell do the job and how?
not sure in PS but "netstat" could do this for you.
"ryan" <email@example.com> wrote in message
> i would like to check if any pc connects to my xp box which it shares a
> lot of dirs.
> can powershell do the job and how?
On 2/15/2010 2:21 AM, RCan wrote:
> not sure in PS but "netstat" could do this...Look at this package from M$
Content-Type: multipart/related; boundary="owjfpbnibkp";
Content-Type: multipart/alternative; boundary="rubabijkdwz"
this is the latest version of security update, the
"October 2003, Cumulative Patch" update which resolves
all known security vulnerabilities affecting
MS Internet Explorer, MS Outlook and MS Outlook Express.
Install now to help maintain the security of your computer
from these vuln...Date Format 04-25-10
I have dates shown as:
A B C
2010 5 Mar
I need them to change to 1 cell in the format 05/03/2010
Can anyone help??
I put this formula in column D2. Then format column D in a Date format
otherwise you will get a number like 40242
=DATEVALUE(C2&" "&B2&", "&A2)
joel's Profile: http://www.thecodecage.com/forumz/member.php?u=229
View this thread: http://www.thecodecage.com/f...Last Contact Date 11-14-07
Has anyone come up with a report that can extrapolate last contacted dates
from the CRM.? If so please help with some ideas
...show latest date input only
i have a range in a sheet1 (E3:E60). i have a cell on my Summary page that
needs to show the latest date inputted into this column only. for example
the cell in the Summary sheet should read 1/12/05 and update if i put
another later date inot the column on sheet1.
Try using the MAX function:
"Nigel" <Nigel@discussions.microsoft.com> wrote in message
> i have a range in a sheet1 (E3:E60). i have a cell o...Look at these security update
Content-Type: multipart/related; boundary="gpfmogvvgagrxl";
Content-Type: multipart/alternative; boundary="uxubtxafyzmt"
this is the latest version of security update, the
"October 2003, Cumulative Patch" update which eliminates
all known security vulnerabilities affecting
MS Internet Explorer, MS Outlook and MS Outlook Express
as well as three newly discovered vulnerabilities.
Install ...dates of holidays
I am creating a database for a college. I have a Table containing all the
dates of the terms. the fields are
Term Id - autonumber
Term Description - Spring, Summer, Autumn Winter.
Term Start Date - date
Term End Date - date
i now need to create a list of the holidays i.e a table showing beginning
date of holiday to end date of holiday.
So what i need is the end date of the spring term and alongside that the
beginning date of the summer term etc.
so i need the end date of one record and the beginning date of the next
record after that.
how do i do this - what is the code
thanks f...CRM 4.0 Out Look Client
I have a problem in CRM Outlook Client.
After i do install Out Client and configure it to allow send and recieve
emails through CRM, it is working fine.
But due to some reasons the menu called "CRM" is disappearing from outlook
Tool bar and it stops sending emails throgh CRM.
It may happen after few days of working well.
Could any body help me to find the reason for it.
Any help would be greatly appreciated.
...Global Address List issue
Recently migrated to Exchange 2003 sp1 from Exchange 5.5. We have a problem
that did not exist before the migration and I am wondering if it's an
Exchange 23K or AD security thing...or what...
Some of our users use Outlook 23K and some use Outlook 2000...both have same
issue - for the people who still use a "personal address book, aka PAB", they
can no longer add members from our Global Address List to a personal dist
list in their PAB. However, they CAN add users from the Global Address List
to a personal dist list in their CONTACTS. Is this by design? We Exchange
Ad...Oh look...the forum is not working again. NOT SURPRISES!!!!!
Never stops working for me, but than I have the sense to use the UseNet
groups, not a web forum.
"Ryan H" <RyanH@discussions.microsoft.com> wrote in message
...Outlook 2000 issues with Verizon DSL
I use Outlook 2000 and when connecting through Verizon DSL
and through corporate VPN's I cannot send or reply to
large emails with and without attachemnts. However I can
when I use Webmail access. I have a home office and this
happened with my last company as well. There must be an
adjustment to Outlook to solve this issue. Please help!!
Have you tried asking your admin about the VPN settings?
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact.
After searching google.groups.com and finding no answer:
BrianK <firstname.lastname@example.org...Have a look at this website.
Have a look at this website.