interesting question can anyone help
this may not be the right place to ask this but
i have an xda 2s pda from O2, is it possible to make it send and
automated text message to my contacts at 12pm the day before they are
due to meet me for an appointment
client joe bloggs (contact details are in contacts in the pda synced
with outlook) appointment tomorrow at 4 pm
automated text reads "joe bloggs your appointment tomorrow is at 4 pm
and so on for all other appointments that day?
as i say it may not be the best place to ask the question and i dont
even know if its possible any help would be apporechiat...Need help with macros and protections
I want to protect a sertain range of titles and leave the remainin
worksheet open for data entry. Everytime I try to do this protection i
requires the entire sheet to be protected and a password to b
activated for the effected range. I want the unprotected range withou
a password entry.
Secondly I have created two buttons to list data in assending an
decending order. I got them working but now they give me erro
messages. Also the assending macro places all 0 enteries on the top
need the macro to read greater that 0
Any suggestions would be appreciated.
' Macr...Using Time in formulas #2
I don't want the user to enter them by hand. I want to use a formul
to calculate the subsequent times. They would have to load 9
SPenney's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=107
View this thread: http://www.excelforum.com/showthread.php?threadid=26920
...Help With RSS Red Feed Buttons
Hi All, Thanks for letting me join. I have a question. I just
a free version of an rss software for reading, writing and publishing;
I have about 12 days left on it. Had good customer service when I
downloaded it, they even called me and walked me through using it.
I published two articles for my two websites.....
But........the weekend came and i discovered that the little red
rss buttons were not up on my site. I emailed them and they sent me a
red rss buttons and said that I needed to put them on my sites (I have
sites) and then link it back to the feed.
I don't h...Help needed on date matching and cell reference.
I need a formula to return the value of a cell from a nearby column, based on
a matching of the months and years within a range of dates to the months and
years within a given date. Here is the setup:
Cell BA58 contains the given date.
Column AP, starting in Cell AP59 and going down to AP2000 contains the array
of dates that need to be evaluated to find which date matches the given date
in Cell BA58
Column AR, starting in Cell AR59 and going down to AR2000 contains the array
of numbers from which the result must be displayed. If a match is found
between the given date in...I need help with multiple Fidelity accounts and Money 2006
Here is my situation:
I have the following accounts at Fidelity:
Under my login ID: Financial Institution is named "Fidelity Investments"
for these accounts
My Rollover IRA
My Roth IRA
Joint brokerage account
Under my wife's login ID: Financial Institution is named "Fidelity
Investments # 2" for these accounts
Wife's Rollover IRA
Wife's Roth IRA
Joint brokerage account
The Joint Brokerage account is the same, and shows up at the Fidelity web
site when either of us logs into Fidelity.
This setup is giving m...Help to import data from reference workbook
I wasn't sure if this would require VB or not so I've put this in the
General Question group.
I have 2 workbooks where the first 3 columns of each row (after a title row)
consist of an ID number, a North coordinate and an East Coordinate. Workbook
A is complete in that every ID for our system is included along with the
coresponding North and East coords.
Workbook B includes a subset of the IDs and only some of the IDs have their
coords in columns B and C. How do I import the coords into Workbook B
without having to copy/paste a thousand or more times. Thanks in advance for
a...Activating bold function takes time
I have a PC which is having Office XP installed in it.
When i try to make a text in a cell bold the first time in any worksheet, it
takes aprroximately 4-5 mins, but the very next moment if i want to make
another cell bold, it happens as normal. can u help with the reason why it so
happens & is there any solution for the same. I also tried reinstalling
Office (different version) twice after removing the previous installed
version but the problem is still persisting.
I think I've read posts that say that when this kind of thing happens, it's
usually because the current printe...receiving messages multiple times
Outlook 2002, set in POP3 mode, set to leave a copy of
messages on the (offsite) server. Whenever mail is
received at the server, it is forwarded properly to this
user, but then in 5 minutes or so when Outlook checks the
server again (as it has always done in the past) another
copy of the message is sent. This will continue until a
NEW message arrives at the server, at which point that new
message will be repeatedly sent. There is only one copy of
the email on the server, and another user who monitors
this account using Outlook Express properly receives a
single instance of the messa...LOOKUP Help #7
I have a column (e.g. Column X) that lists a series of dates, entered
by the user.
I have a table array (Columns A-L) of all the months, Jan-Dec.
What I want to be able to do is, under each month in the table, look
into Column X and list all the dates within Column X that are relevant
to that month.
I've tried LOOKUP but because dates are formatted like 31259 I dont
know how to write the logic.
Can anyone help?
Thanks a lot
One way using non-array formulas is illustrated in this sample construct:
Placing source dates under correct month col....restoring an individual mailbox to a give point in time
Have any of you needed to do this and succeeded? What
steps did you take?
not an individual mailbox - only blb will allow you to restore a single
mailbox, but that cannot be done to a point in time; only from when the
backup was taken...only way to do this is to restore the entire database,
then replay all applicable transaction log files...
"dondidati" <email@example.com> wrote in message
> Have any of you needed to do this and succeeded? What
> steps did you take?
...Can i replay logs with eseutil multiple times on the same EDB file?
I was wondering if anyone was ever able to replay logs through eseutil
multiple times on the same database. I tried issueing the command
"eseutil /r E00 /D" once on the original set of logs and it succeeded.
When I added some more logs to the same folder and issued the same
command, it appears that no new logs are replayed to the database.
However, if I only call ESEUTIL once on the comprehensive set of logs
(the original set of logs plus the additional ones), then it works
fine and all the logs are incorporated.
It seems that ESEUTIL will only allow you to replay logs to ...Formulas not calculating???
My excel is no longer calculating formulas, when referencing other cells.
How can I correct this?
maybe: Tools - Options - Calculate and enable automatic calculation
"J Dizzle Fizzle" <J Dizzle Fizzle@discussions.microsoft.com> schrieb im
> My excel is no longer calculating formulas, when referencing other cells.
> How can I correct this?
...Excel:I set the font color to be "Red". Next time file is open, f.
Say I sent the font color to Red in the cell. The next time I open the file,
the font color in the cell changes? Why
Maybe you didn't save the file?
>Say I sent the font color to Red in the cell. The next
time I open the file,
>the font color in the cell changes? Why
...Please verify BUG in Microsoft Windows XP/2003 Accessibility *MPS*
The Problem (Multi Processor only):
This occurs when there is MORE than one Logical/Physical CPU on the system.
When a console winevent hook function is active, changing the codepage of a
console window causes the console window to not respond.
I set a hook using SetWinEventHook to get notified on events
EVENT_CONSOLE_CARET to EVENT_CONSOLE_END_APPLICATION
all is well, events are coming.
When I open a CMD window and change the codepage to a different codepage
than the default one, the window stops responding.
From my tests it appears that the problem is somewhere in the
SetCo...Convert number in time #2
Thank you! :
Megadata's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1487
View this thread: http://www.excelforum.com/showthread.php?threadid=26506
...Automatic email entry help
when i send a new email in outlook 2003, if i type the first letter of the
name in the to blank, it brings up a list of email addresses.
can i edit these addresses???
Those email addresses are pulled from a cache of previously typed email
addresses - what do you need to edit? Is one of them wrong? If yes, just
use the arrow key to select it and press delete.
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. All
unsolicited mail sent to my personal account will be deleted without
After furious head scratching, Keith Girdley aske...calculations between days
I have a problem of customer service report and i need to
solve a problem but i do not know if there is such a
I have two dates. One is the requested day 23/01/2004
(E50), and the second one is the Delivery day 10/05/2004
(Z5). I want to express the difference between the two
days, but i want to see the result as a week number.
There is any possibility to change the days to week
Also in Column E i have the requested days (day format)
In the row 5 from column k to bb i have the days of
delivery (days format). In the area table i have the
the...Need help with recursive SQL
I am using MS Access / Jet.
Problem is of hierarchial query:
I mean typical Boss Employee table:
I need a query that if I take John then all names should be returned
in a single coulmn because he is the highest boss, if i take sam, then
michael, william and alfred should be returned. If I take Michael then
only Michael should come since no one is working under him.
Ok, one boss can have many emplo...IF statement help needed
I am using excel 2007. I have a spreadsheet that contains data:
Acct no Date PPT Paid Sales Tax Amount
1000 4/30/10 60.46 4.54 65.00
1000 4/30/10 32.55 2.45 35.00
1000 4/30/10 65.00 0 65.00
1000 4/30/10 35.00 0 35.00
(PPT Paid + Sales Tax = Amount). I want to exclude the last 2 records. I
can't use sales tax > 0 because I have other records that may have no sales
tax but are still valid. I have tried the delete duplicates on the menu bar
and it helps...Help
email dropped - store will not mount (exchange 2003 on windows 2003 server)
here are the different errors messages I see:
The Exchange store 'First Storage Group\Mailbox Store ( is limited to 18 GB.
The current physical size of this database (the .edb file and the .stm file)
is 12 GB. If the physical size of this database minus its logical free space
exceeds the limit of 18 GB, the database will be dismounted on a regular
Event Type: Warning
Event Source: MSExchangeIS
Event Category: General
Event ID: 1240
Time: 3:27:24 PM
Descr...Re: Count "hours", as 1 each? Example attached....Please Help!
I am totally stumped...
I would like if possible to count how many hours each employee worked,
from a pivot table. I have already captured how many scans each
employee did, just need to get a count of total number of hours each
worker worked. ( Productivity report )
a b c d
e f g H
1 employee 8 AM 9AM
10AM 11AM 12PM 1PM
3 BOB 40 49
50 55 80 274
4 NANCY 50 60 50
100 30 290
5 SUE 25 20
20 20 85
blank cells are when the worker scanned ...some one help with the function (OR)
some one help with the function (OR)
I dont know how to use this function
thankyou for al
Message posted from http://www.ExcelForum.com
Did you check the help file? What part of the explanation didn't you
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
In article <firstname.lastname@example.org>, nader
> some one help with the function (OR)
> I dont know how to use this function
> thankyou for all...Formula for a fill color help
I can't figure out how to make a formula that will recognize a color a
a value. More specifically; If b1 is made to be green (color index 4)
would like c1 to insert the letter Y. I am I'm looking for an I
statement so I can use it throughout the whole workbook.
The formula if I understand it should kind of look like (in C1):
I'm looking to put a "Y" in c1 if b1 is colored in green.
I would really like to also know how to insert a fill color in an
Thank you for any of your help and time,
Yo...Pop Up Calendar Help
I am very new to Excel, working with 2003. I have followed the directions her
I think I am very close, but when I try to test the code I get run time erro
Method'Value' of object 'Icalendar' failed
When I select the debug it takes me t
the line frm.Calendar.Sho
Any help is greatly apprectiead
Did you rename the userform to frmCalendar?
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)