Wildcards in IF statement
I need to select base on whether a field has three alphabetic characters
followed by three numbers. I tried
but it didn't treat my string as a wildcard. Is there another way to do it?
Please reply to newsgroup, not e-mail
I think you have to use your Regular Expression in a macro.
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dm...Can we get notification of opening any site ??..
I am trying to get notification of any browser request... (not only that
of the local server.. e.g. http://localhost/. so ISAPI filters will not be
the right way to solve problem)
So, whenever any request like (http://www.yahoo.com/) is made in IE, I
want my DLL routine or my EXE to be called.. So, how to do that, any
suggestion will be highly appreciated...
Is there any registry entry that enables us to do that...
If you know then please tell me...
Or atleast tell me, is it possible or not so that I don't waste time on
email@example.com...Prevent Access To already open file
I am new to excell and this forum.
Is there a way of preventing someone else opening an excel spreadsheet
whilst it is being edited by someonelse even read only.
ashtod1's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=30168
View this thread: http://www.excelforum.com/showthread.php?threadid=498523
...Shape.OnAction stops working after workbook closed and re-opened
I have created a set of icons which are made up of 3-4 individual
shape objects grouped together. One of those objects needs to respond
to a mouse click which I achieve using the OnAction setting, ie.
shp.GroupItems(shp.Name).OnAction = "ShapeClick"
where the shape and the group have the same name.
Connector lines are used to join the icons up into a network.
Unfortunately in XL2007 when connecting a line to the object the click
event fires so to avoid this I first set OnAction to "" and then set
it back to my macro after connections are made.
Initially this w...how can I open *.php documents in Publisher or Works 8?
I now have a PC running WP Home edition, with Office 2003 Small Business
edition. Works 8 was pre-installed on the PC. How can I open *.php
documnents?? Publisher can save in this format but won't open the old
documents in this format.
You can't. The format .php is for Home Publishing, not Publisher. And I
don't know what renegade version of Publisher you have but my copy of
Publisher 2003 does not have the ability to save as a .php .
MVP Microsoft [Publisher]
"Steve Narbrough" <Steve Narbrough@discussions.microsoft.com> wrote in
message...HR Benefit Table
I'm trying to do some cleanup of our benefits (delete benefits that were
enrolled and never used) and in the process of querying table BE010130 there
are a ton of benefits that have a 0 in the BENEFITSTATUS_I field. When I try
to pull them up in GP they don't show under the specified employee. Can
anyone tell me what these are and if I can delete them?
After looking at the HRBEN.DOC from the SDK, it doesn't appear the BE010130
should have a value of 0. The values that should b...unable to open exchange system manager
I am running exchange 2k3 in a active/passive (win2k)
cluster. After I changed the password of the domain
administrator, I am unable to open ex2k3 system manager
and also cluster administrator. It gives "access denied
ID: c00700005" error. I also changed the permision in the
registry for WINREG key in LOCAL MACHINE/Control/... etc,
but that did not help.
However I can open the cluster administrator from passive
node. Active node is also not showing active directory
objects (displays unspecified error message)when I try to
assign NTFS permisions to some folders. When I run
...Filename Split, then files not found, then original file opens...
The craziest thing has started happening. When I open a file excel
splits my file (path and name) on spaces and tries to open individual
files of the text strings created by the split.
So if I open C:\Documents and Settings\User\Desktop\file.xls
If will alert:
\e.xls could not be found....
then it will alert
C:\Documents.xls could not be found
then it alerts
and.xls could not be found
Settings\User\Desktop\file.xls could not be found
Then it opens the file...
Very weird, and very annoying. Does anybody know how to fix this?
Message posted from http://www...multiple scenario forumla (maybe a nested if statement)
I have a spreadsheet of possible hiring canidates that may or may not go
through 5 stages of the hiring process which are listed below.
I need to know for instance if a candidate made it through some stages or all
stages of the hiring process. Under the column headings (Attded Career
Session, Test Score, Chosen 4 1st interview, Chosen 4 2nd Interview, Hired)
the data will be listed but Im not sure how to say Canidate 1 made it through
all but the Chosen 2nd Intereview.
Canidate Attded Career Session, Test Score, Chosen 1st interview, Chosen
2nd Interview, Hired
Any ...Transaction Memo Data
When I download bank info, the Money checking register shows the additional
Memo data initially, but usually within 2 minutes or so, that data disappears
(or is deleted) leaving only the Payee info intact. Why does Money do this?
I am in the process of transitioning from Quicken 2005 to Money, so much of
what MS Money does is New to me!
Are you using 2005/6? (Version is almost always pertinent data in support
discussions.) Are you using Advanced Register?
"New$" <New$ @discussions.microsoft.com> wrote in message
news:6D3FDF8F-D2DF-423A-BCA5-88318566C22F@microsoft.com....pop3 sending and receiving
When I send a message in Outlook 2002 I can open the Send/Receive
status window to watch its progress.
There is a line showing the send/receive progress but under this
there is a second line as if there is a queue.
Can someone explain what is going on here?
...Money including transactions from "deleted" accounts.
I have several checking acctouns with the same bank. Money auto-pulls
updates from all of them. Two of the acctounts are "personal spending" for
me and my wife. These contain "disposable" monies, and I don't care to
categorise this spending. I've marked these two accounts as "closed" but
Money still incorporates transactions from those acctounts into any Report I
make. I noticed that although I marked the two acctounts as closed, and I
don't see them in the acctounts register, Money is still pulling updates from
these acctounts. When I try...how to open a pagemaker file with the extension .pmd , read only t
i'm using vc++6.0 MFC Application Wizard dialog based application and
i need to open the pagemaker file with the extention .pmd using vc++ coding
and i should read only the text from the file and i have to write the text in
an excel sheet using vc++ coding..
can anyone help me to solve this problem.......
...2 IF statements in same cell?
I have a client that wants to know if you can have two IF statements in the
check you're previous post.
"Carla Bradley" <CarlaBradley@discussions.microsoft.com> wrote in message
>I have a client that wants to know if you can have two IF statements in the
> same cell?
> Carla Bradley
Thanks JulieD. Not sure how I got 3 of them! SORRY!! But thanks, she'll ...OL2002 won't open when clicking on web links
I have WinXP home ed., Office XP small bus. ed., with
outlook 2002. It was working fine but now when I click on
a link on a web page I get a message saying "cannot open
microsoft outlook. can't create item."
I tried reinstalling officeXP and also went into file
associations and made sure the URLmailto was associated
with outlook. In IE 6.0 it does show outlook as being the
default mail client. Email me if you can help! Thanks!
...Re: Calculate A Date Excluding Weekends And Holidays
I have a date and a series of tasks that need to be completed by a
certain number of days from the intial date. The time to complete the
tasks can not include weekends or holidays.
Example: Initial date is 2/15/2006
I have 10 business days to complete a task
All Help will be appreciated. Thank you.
travelersway's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=17623
View this thread: http://www.excelforum.com/showthread.php?threadid=510028
A good starting place for info...SQL Error when running Paid Trx Removal
When running Paid Trx Removal, we get the following error:
Microsoft ODBCSQLServerDriver Cannon insert duplicate key row in object
RM30101 with unique index AK4RM30101.
Then another error: The stored procedue RMPaidTransRemoval returned the
following results DBMS 2601, Great Plains: 0.
I ran check links and that didn't fix it. What can I do? Is there a query
that I need to run to delete this dup. key? Any help would be great, this
removal/report needs to be run asap. Thank you.
The problem here is that the RM30101 has duplicate key for one your
transactions. If you kn...How to stop Personal.xls opening at startup
Somehow I've got this file starting automatically when I open Excel
2003. How can I make it stop? And what does it do? I hope I don't
Personal.xls is the default name of the workbook that XL creates in the
XLStart folder when you store a macro. It's just a workbook, but since
it lives in XLStart, it's opened each time XL is opened.
To "make it stop", move or delete the file.
In article <firstname.lastname@example.org>,
> Somehow I've got this file start...Open/Partial/Closed PO icons gone
One of the computers here had a problem with Windows and I had to blow it
away and re-install everything. I installed RMS v2.0 Store Ops & HQ and
applied the Hot Fix we're all running (v2.0.0109, I think).
The PO list used to have icons for Status. White/Blank for Open, White
w/Red Exclamation Point for Partial and Yellow w/Lines for Closed.
On this one PC, these icons have been replaced with text. It's obviously
not a critical issue, but the user of this PC has been looking at those icons
for over two years and she would prefer the icons over the text.
Problem also appl...Open Gp
Hello all, just did the upgrade to GP 8 and everything went fine.. However
when I uninstalled GP 7.5 the Icon for 8 went with it. I tried to drag the
dynamics.set file ontop on the dynamics exe file for the association and
that worked however i have to do that the entire time.. I checked the
properties of the shortcut and they point to the appropriate directory but
each time I have to "open launch file" from the dexterity Runtime.. can't
find anything on customer source as of yet.. Many thanx
Are you talking about the desktop icon? If so you need click on my computer
expand ...Outlook.pst file is 2Gb and cannot be opened
I tried to open outlook this morning and was unable to.
The error box said something like ... The file outlook.pst
has reached it's maximum size and cannot be opened, please
delete unnecessary items permanently (Shift + del)
The only problem is I cannot open outlook.pst to delete
The size of the file is 2Gb - and I'm sure that last time
(a week or so ago) I looked at the file is was 85Mb
Well, either you have a lot of girlfriends or then just a
sh!t load of spam... Goodluck on that one, my pst is
>-----Original...How to use nested IF statements
Operating System: Mac OS X 10.6 (Snow Leopard)
Hi everyone, <br>
was wondering if anyone could help me figure out using nested IF statements in excel 2008.I'm used to using it in windows XP and the procedure is pretty straight forward: to nest a statement you just click on the IF button in the "name bar" when you are in the IF False box.....that doesn't seem to work here....any suggestions would be appreciated,thanks.
Dunno what "clicking on IF" does, but just type away -- making sure you
know whether you want ...IIf Statement Error
I'm trying to formulate an if/then statement in a query and it returns with
error as the value.
I've a calculated expression as Expr2:
Expr2: First(([SumOfACREAGE]*10)*([% PMT]))
which returns a value. This part works well. It returns a dollar value.
I then use that Expr2 in another query in an IIf statement:
I want it to return a value of 1000 if the value of Expr2 is greater than
1000, and Expr2 if the value is less than 1000. It's not working. I've
tried adding .00 to the 1...Outlook 2003 opens very slowly pls help
I am running Outlook 2003 on Exchange Server and I notice when I have an
email with an attachment it takes a long time to open.
Does anyone know why this is happening and how to correct the problem?
...files will not open after 10.1.6 security update for Office X
I've updated office X to version 10.1.6 using the recently developed
security update. I've encountered some problems with files that I had
previously made using powerpoint. Seems as if the updated version of
powerpoint will no longer open some of these files. The exact error
message I receive is as follows:
PowerPoint cannot read HD:Users:reddog:Desktop:235 presentation.ppt.
After uninstalling the 10.1.6 and reinstalling Office up to the 10.1.5
update, everything opened fine. So, I'm guessing this recent update
is the culprit (although I'm sure I could be wrong)...