Web Query question
I am trying to download stock options through the following vba code, however
i am having problem with separator between "m" field which is month and "s"
field which is stock symbol, I appreciate any help i can get,
With ActiveSheet.QueryTables.Add(Connection:= _
I think you are mising (at least) one quote?
> I am trying to download stock optio...Two mailboxes for one user account after mailbox moved to a new server
After moving a user's mailbox from a Exchange 2003 to a new Exchange
2003 server, Outlook has listed two mailboxes with same name in the
"All Mail Folders"area. The Outlook profile only has the user mailbox
and no other mailboxes added to it. The user can send and recieve email
just fine. The mailboxes seem to be clones of each other. New mail show
up in the mailboxes at the sametime.
How can I get Outlook to only show one mailbox?
Any help would be appreciated,
...Baseball Stats question: How can I get the RBI's?
I have a data table that looks like this:
STR-S SNK-S STR-K STR-F SNK-S STR-3 STR-2 STR-F SNK-S SNK-4 SNK-S STR-3 SNK-F STR-4 STR-O
"STR", etc at the beginning are pitch types, SNK is Sinker for example
The end character is the result of the pitch, a 4 would be a home run,
3 a triple, and so forth. O is out, F is foul, S is strike --- you ge
How can I figure the amount of RBI's? I know that it's 5, but I can'
think of any automated way to calculate this, anyone got any ideas?
THANK YOU!! :confused
AVER...How do I send a welcome message to a new created mailbox automatically?
My exchnage send a message automatically but I need to change the message
where do I change it?
On Tue, 21 Jun 2005 16:35:53 -0700, "Ron" <firstname.lastname@example.org> wrote:
>My exchnage send a message automatically but I need to change the message
>where do I change it?
Exchange doesnt do that unless you have something scripted.
If you are referring to the welcome message in Outlook, its called
welcome.msg , but I dont think its been used since Outlook 2002.
So where would I plug in the script? Also I searched for welcome.ms...Need a default email account for all users, need help.
I have a tablet PC running WinXP Tablet with Outlook 2003. This tablet
connect to our exchange server via VPN. How can I set it up so that
that logs onto their account can access one (the same) email account.
problem is that I dont know at this point all of the users however
using the tablet will use one generic email account. So how can I set
Outlook to default to this account so that no matter who logs on they
use this account?
...AD/Network design question
I have a 2 sites which users come and go from. These sites have 2 different
network ip domains (192.168.1.x and 192.168.2.x). Users need to be
authenticated using the same user id and password at both sites. DC/GC is at
192.168.1.x and is a SBS 2003. Server at 192.168.2.x is Server 2003.
When the server at 192.168.2.x is connected via vpn to 192.168.1.x all is
How do I get the server at 192.168.2.x to act as a AD/DC when it’s not
connected to 192.168.1.x ?
I think you will run here into the limitations of SBS :-(
@ SBS experts : ...Office 2010 Buying Question Assistance Needed
I've been looking through the MS Office 2010 web site to try to determine
what my new small company would require, but I can't find the information I
We for sure would need Office Pro Plus, but other than that I'm not sure. We
want to run it on our own server. We will initially have 3-5 people using it
and perhaps more later on. Would we need to purchase site licensing?
Unfortunately, our programmers are MS haters (I'm not) and I can't get any
assistance from them on this, but I have power of the pen. I would appreciate
any assistance I can get.
Th...How to view the same email message at the different PC users
My husband & I use the same PC(Windows XP) but have an
individual user accounts. We have several email addresses
for individual usages and shared usages and all enable to
receive and view by Outlook 2000 inbox. We have noticed
that the emails came in while I'm on Outlook (or
minimized at the bottom) can not view when my husband
goes to his Window user and open the Outlook. And vise
versa. We want to be able to look at all emails that came
into the Outlook inbox at both Window user's Outlook
inboxes. How can we do that?
...New Named Range Created Each Time Data Imported into Excel via Macro
I have noticed that each time I import data into an Excel spreadsheet
via a macro, a new named range (for the same range) is created. This
does not pose a problem, but after a while, I'll have a huge number of
named ranges that will never be used. Why does Excel name the range
and how can I stop this? I noticed in the recorded macro, there was a
line .Name = "drd_5". I commented this out to see what would happen,
but it just renamed the range "ExternalData_5". The next one was
You could refresh with differen...why I see times new roman?
I have several html email messages composed in outlook express 6,
I'm sure I highlited all text and set it to Arial 10.
Then I drag the file to desktop, move it to vista windows mail draggin
into inbox or other folder. The result is some parts of text shows arial 10
some others Times new roman 10 or 12 what is annoying, because I use
all arial 10, so I have to manually forward the email, highligh it again and
set arial 10
and then, yes, I can see it properly.
I checked the compose default font and everything is fine.
Why is that? Is there any work around
, helo...Custom CRect Question
I have a custom rectangle class that inherits from CRect:
class CCustomRect : public CRect
CCustomRect(RECT* source, CPoint pt, COLORREF rgb);
void Update(RECT* r);
Inheritance has worked well until I found myself needing to create the
RectBase function (above) to return the rectangle dimensions.
CRect does not seem to have any methods that can be called to return the
base class's RECT value.
I could take CRect::Size and construct a rectangle to return, but this seems
a bit much.
My...Question About Missing Data
So, this is probably really easy, but I just want to ask and see if I may be
missing something here. Some data on vendor numbers changed. Let’s say IBM
used to have a vendor number 12345 and now it’s vendor number is 56789. I
can identify IBM as IBM, but I really want to use the number, not the name.
Should I set up a table that ties the numbers together, so that Access knows
12345 = 56789? Or, should I do some kind of Update Query and change all
incidences of 12345 to be 56789? Or, is there some other, method, like a
‘best practices for missing data’?
...single user mode
I need to be able to establish an exclusive connection to the database
and do a restore to it. Nobody, can be connected to that database
prior to the restore. Also, I need to be able to schedule it to run
on a daily basis.
I tried putting that db in a single user mode and then do the restored
in a transaction but I got the error that the restore command is not
allowed in the begin tran commit tran.
How can I accomplish that?
tolcis (email@example.com) writes:
> I need to be able to establish an exclusive connection to the database
> and do a restore to it. Nobody, c...VS 2005 beta question
I need to complie some code. I am going from 16bit to 64 bit. The job do
not want to spend the money on VS 2005.net. If I compile the code with the
beta version or trial version of VS 2005.NET will it time bomb on me?
Thanks in advance
The code won't, but eventually the compiler will stop working. Don't know
if the trial will support 64 bit though.
I guess you get what you pay for.
"karibbean" <sharp_mind@REMOVE.this.email.msn.dotcom> wrote in message
> I need to complie some cod...Why do my questions get deleted sometimes?
Apologies, I have posted this on the worksheet functions group too...
I love the feedback I get from these groups, but every now and then, my
messages get deleted.
I'd like to know what I'm doing wrong.
Many of my messages ARE posted and answered, and I'm grateful for that, but
one or two get removed - regardless of how often I post them.
I don't swear or say anything bad about Excel - I love it.
So why don't they get posted are there some words or subjects that I should
Will this one get deleted - it's a bit off subject? But I'd love to have an
I have a total sheet that gets data from three different shift sheets (all
in the same workbook) for a monthly report. I have named ranges on each
shift sheet for each month's production data (S1M1, S1M2, S1M3, S2M1...)
where S1M1 =A2:AC147, S1M2 = A148:AC329, etc. The old formula
was:=SUMIF('SHIFT 1'!$L$1:$L$147,"BB",'SHIFT 1'!$T$1:$T$147). I'm stumped as
to what the new formula would be - how would I direct Excel to column L of
S1M1 to search for "BB", then add the contents of column T? The range
changes each month, and I tho..."Organizational folder": 'new' menu is not available
I am following article:
and I try to create an organization folder. I go to my "Public FOlder",
click "System folder".
I see EFORMS listed there. I right click the option and I don't see the
What's wrong ? Exch 2000SP3.
...Help please user not showing in 5.5 GAL but is in exchange 2003 GA
Up until today I have been bable to add users fine and their address would
appear in both the 5.5 GAL and the exchange 2003 GAL.
Is a single site with 2 5.5 servers and 1 exchange 2003 server.
When I add a new user now through users and computers and put the mailbox on
the new exchange 2003 server the user gets his email addresses and appears in
the GAL on the 2003 server but people connected the the old 5.5 servers
cannot see it.
When I open the 5.5 exchange admin tool again if connected to one of the old
5.5 server I cannot see the person I just created but when connected the the
20...VLookup #VALUE! error help needed to resolve
The following is the funcation I have:
=VLOOKUP(B10,'FA CC Summary Report 1141'!F$9:G$92,2,0)
I have all the columns formatted the same; as in the column that the
function is using to lookup is text and so is the column for this figure in
order to pull back the appropriate answer. I have keyed the data instead of
having links. I have replaced the final '0' with TRUE & FALSE then put it
back. I have formatted the columns for text and for numbers.
But I am getting the #VALUE! error in SOME of the cells NOT all of the
cells. I don't know what else to d...A question about CToolTipCtrl.
Chinese English following!
I add a CToolTipCtrl member in my dialog, and create it in OnInitDialog
function, at last, I add a CEdit control to CToolTipCtrl member.When the
CEdit control is enabled, tool tip can pop up normally, but when the CEdit
control is disabled, tool tip can't pop up. How can I solve this problem?
Take a look at
If the message was helpful to you, click Yes next to Was this post helpful
"fiveight" wrot...Mail to No. of users
I our organization we are having Exchange 2003. We are
facing one small problem that whenever user tries to send
a mail to multiple user (especially multiple distribution
groups)he recives following error message from
The e-mail system limits the number of recipients that can
be addressed in a single message. Send the message
multiple times to fewer recipients.
Where i can found this setting so i can get rid of this
limit... Please help
go to exchange -globle setting - message deliver and right click and
proper...Public Folder acces right for user from other domain
I need to make a public folder accesible for users drom another domain. I
have read that this can be done by configuring the folder as a publicly
available newsgroup but how do I do this?
...Problem in restricting users from sending/receving internet email
I have found a helpful articel here:
I read it through couple times but I would like to ask some questions
before I start the work on our Exchange 2000 server.
1. The "group" I am going to create for adding users into the
restricting list, will it be a Security group or Distribution group?
What group scope should I give it?
2. Under the section of "Restricting Users from Sending Internet Base
Email", the article tells us to create a *new* SMTP connector and add
the group into the "Dilivery Restriction" page.
Will ...User accout shows new email
On start up a message shows in my user account that I have new email messages
but am using Outlook 2003 and all incoming emails have been deleted. How do I
clear the message
...Remote ActiveSync User Permission Errors...
We recently purchased a few Motorola Q smartphones for our users. I already
have a PPC-6700 that I've been using Exchange ActiveSync on for about 10
months. It works fine.
So, I installed the same certificate on the Motorola and provided the end
username and password, entering it exactly as is on mine.
It gives the 0x85010004 error...."Your account in Microsoft Exchange Server
does not have permission to synchronize with your current settings. Contact
your Exchange Server administrator"
So...the first thing I did was check Mobile settings for the user...