Problem import via query
When i import data via a webquery from:
I get different values than on the webpage..
When the webpage says:
American Dollar 1.3601 0.73524
Australian Dollar 1.62633 0.614883
Brazilian Real 2.75284 0.363261
I get these values in Excel:
American Dollar 13.601 0.73524
Australian Dollar 162.633 0.614883
Brazilian Real 275.284 0.363261
Some values are ten times to high, some are hunderd times to low.
Is this because in my version we use comma to seperate decimals?
So i see the value 13601 for the US$, and with the...how to control outline group? show or collapse [vba]
I made an project tasks and outlined for each level thru vba.
How can I hide (make it [+]) all the summary tasks if completed?
..showdetail = false looks not working as I wanted
 Task Name %Done Start,
[-] My Project 30
[-] High Level 1st 100
. Task 1 100
. Task 2 100
[-] High Level 2nd 10
. Task 3 20
. Task 4 ...Publisher 2003 Post SP3 Crashes
We have roughly 10k publisher documents, created from PDFs (I'm told). These
documents open pre-Office 2003 SP3 using an XP Pro SP2 pc (or laptop). After
SP3, I get an error :
"Publisher has deteted a problem in the file you are trying to open. If you
are certain the file came from a trusted source...click ok. Other option is
Cancel which blows me out of the program back to the desktop.
Then it provides an error report which reference mspub.exe, the App
versions(11.0.8166.0), and finally if you read the report itself, it
references the ever-generic 0x000000C5 error with no ...Mailbox Restore Policy
We are considering changing our Backup/Restore policy to one that makes
our backups only for disaster recovery of whole stores or servers.
Users will need to use recover deleted items if they lose a message.
It is just too costly in staff time to recover individual items ofr
users who lose things.
(The idea of an archiving solution for meeting institutional/legal
demands is a whole separate issue.)
Before we start pushing this policy, we wanted to know what policies
other organizations follow.
Sr. Systems Analyst
I think that is a sound ...Sliding Scale Percentage via IF?
I'm trying to do a formula for a sliding scale percentage fee, for which it
references the item price of an object. Ie: First $25.00 = 10%, $25.01-100 =
10% of first $25 + 7% of remaining price, $100.01-1000 = 10% of first $25, 7%
of first $25.01-100, and 5% of remaining price, etc.
However! The formula I cobbled together won't debug correctly - it works up
to the 7% range, but trying to get that third jump to the 5% and beyond
returns a value of 'FALSE'. I can see what's happening in the formula
evaluator, but I'm at a loss on how to side-step it.
...Outlook 2002 SP3 Hangs
I have Outlook 2002 with SP3 on an XP machine. I am
connecting to our corporate mail server using IMAP.
For the past 3 days, Outlook has been unbearably slow and
hangs intermittently. Sometimes it's fine, other times it
just hangs (causing an Event 1001 or 1002 in the Event
Log). I have tried connecting to the same server using
IMAp with an Opera client and it seems fine.
Any ideas wher to look?
maybe you look here
Ich habe nichts gemacht, gestern gings noch!
Bitte in den Newsgroup antworten damit jeder etwas davon hat.
B...Data Groupping and Outlining
Here's my problem: I have a large worksheet filled with
calculations and row/column grouppings. Everytime I
expand/collapse, it recalculates the whole worksheet.
How do I disable that function? Here's the tricky part,
I still want the Autocalc set on. I do not wish to go to
In Excel 2000, I didn't have this issue.
Thanks in advance.
There was a change in Excel 2003 which makes hiding/unhiding rows trigger a
recalculation, because the workbook might contain SUBTOTAL functions whose
answer depends on whether rows are hidde...A PCCharge Pro for "hire"
I am an experienced "former" PCCharge Tech Rep... 3+ years with
GOSoftware/Verifone - 10+ in the support field... Know PCCharge in and
out... Warts and all...
Runtime Errors? Reporting Issues? Processor Setup Information?
I set up a PCCharge Yahoo! Group... Initially. it will be moderated
heavily, but I aim to please... Gotta keep the facts straight, and the
spammers away... I can't have people yelling at me because I let a
spammer in to clog your mailboxes :)
I am working on a half decent FAQ (in Dat...Recipient Policies : multiple email domains.
We have two email domains (domain1.com and domain2.com). How do I use the
recipient policies to assign some users to have only domain1.com email
I did create a group (security and distribution) and include some users as
the members of the group but it did not work. The only email address that
was affected is the group itself and not the members.
Any ideas ?
"Zul J" <firstname.lastname@example.org> wrote:
>We have two email domains (domain1.com and domain2.com). How do I use the
>recipient policies to assign some users to have only domai...After SP3 install on exchange 2000 the addressbook has changed
I have just made an update (SP3) on a exchange 2000 server. After this
update all the zip codes in the addressbook has changed. They normally
have a format of 1234 but now the format is DK-1234. The land code has
Why is that, and how can I change it?
I know that the users can change all zip codes manually, but there has
to be an easier way.
COZ <email@example.com> wrote:
>I have just made an update (SP3) on a exchange 2000 server. After this
>update all the zip codes in the addressbook has changed. They normally
>have a format of 1234 but now the ...Sharing large contacts via la and ny
LA office has SBS 2003. Not currently hosting own email(will happen in
users have a 15000 contacts that they share in Exchange. Also, share
the CO documents and filemakers database(I know...filemaker_)
LA office: 8 users - DSL - Firewall - 1 sbs 2003
NY office: 8 users - dsl - firewall - 1 win2k box
They want NY to share the LA contacts and files.
Never replicated 2 Exchange boxes before.
What would be the best solution?
1. VPN the 2 sites? Is the CONTACT dbase size too big for VPN?
If VPN, should NY just login to LA domain and not use the 2nd box in
2. Just replic...Distribution Group in Exchange 2003
I have a litlle problem/question. I have an .msg file containing many e-mail
adresses. Now I want to make a Distribution group in my AD/Exchange
environment, and import these adresses but How?
Does anyone have a solution to this?
Ulrik Franck wrote:
> I have a litlle problem/question. I have an .msg file containing many
> e-mail adresses. Now I want to make a Distribution group in my AD/Exchange
> environment, and import these adresses but How?
You should create contacts in Active Directory to add external recipients to
I...How to disable "sharedfolderscript" using Group Policy?
In Outlook XP SP3 and afterwards, there is a registry key
HKEY_CURRENT_USER\Software\Microsoft\Office\10.0\Outlook\Security to control
the VB script access for shared mailbox. How can I deploy this registry key
by using group policy?
Create a new .adm file (better than editing the existing one) with that =
policy included, then add it to the administrative templates in the =
group policy editor. The contents of the new .adm file could be =
something like this, but you have to decide where in the hierarchy =
("CATEGORY") to put it:=20
CLASS U...new yahoo group
If you want something you never had, do something you have never done.
Don't go the way life takes you.
Take the life the way you go .
And remember you are born to live and
not living because you are born.
I established this forum that I wish to be a place for people who are
new to computer field
and also for the Intermediate, Experienced...... can get help, and
who like to share their experience, knowledge, and to help new comers
...Changing your default recipient policy
We had a query from one of our smtp domains about changing where the NDR's
originate from for our org. Currently they come from
They would like us to change it to our more global name so that it reflects
Microsoft have suggested that we change our default recipient policy to
reflect this domain according to http://support.microsoft.com/kb/249299/
Business is driving this big time, but all I can say is that I have a very
bad feeling about doing this.
What I would like to know if what this could possibly break.
Some...Creating a Field With Percentile Group
I appologies if this is a repertition of questions posted before. I
have been searching all day, I believe I have found some solutions but
they seem to be a little out of my league in terms of interpretation.
I have a list of values in an access table called SAMPLE e.g.
Wh...Recipient Policy-based Auto-Delete sending Read Receipits?
Based on some user reports, I think that a Recipient Policy-based auto-
delete for messages older than x days is sending "negative" read
1) User gets message with read receipt
2) User doesn't read message
3) Recipient Policy deletes message after x days, and sends the
message sender a read receipt saying user has NOT read the message
Is this possible? If it does happen, can we use the user's "never send
read receipts" setting in Outlook to stop it? Is there a way to stop
only the Recipient Policy from sending read receipts for all users,
and ...Grouping data
I am trying to group data for a specific event and have not been successful,
so I am hoping someone can help.
ID Date Value
174 12/3/2007 102
174 12/3/2007 909
174 12/11/2007 405
174 12/11/2007 701
206 12/6/2007 1001
173 12/3/2007 500
I want to group by ID, the MAX Date for that ID and the Max Value for the ID
& Max Date
The desired result would be:
ID Date Value
174 12/11/2007 701
206 12/6/...Forwaring issue to an SMTP account using Exchange 2000 SP3
Exchange is on a Windows 2000 Server SP4
This is killing me!!
I have been unable to get this working.
I tried this -
I create an account on the Exchange Server with a custom SMTP account.
I then edit the local account to forward to this account.
It just doesnt work.
I've tried several SMTP accounts as a test & nothing forwards.
In ESM-Global Settings-Internet Message Format right click Default select
Advanced Tab, make sure the 'Allow Automatic Forwarding' box is checked.
Joh...Can't restore from Recovery Storage Group via Sys Manager or Exmerge.exe
I have successfully restored my old servers store to a recovery storage
group, and see the users and the number of items etc. If I try to
restore one to the new info store on the rebuilt server I get an error
that it failed and the following in the report:
<?xml version="1.0" encoding="unicode" ?>
- <taskWizardRun taskName="Recover Mailbox Data" dcName="MBSERVER01"
<timespan startTime="2006-07-23 02:40:03.484" milliseconds="172" />
- <...XP Policies for user
In XP Pro not on a domain, how can I set policies for normal users to be very
tight - so they cannot change any browser setting, change nothing on PC
configuration including updates, no ctl alt delete? They will only be able to
open IE Browser go to a web page for mail, etc.
Change the authority level on the account, make it restricted.
> In XP Pro not on a domain, how can I set policies for normal users to be very
> tight - so they cannot change any browser setting, change nothing on PC
> configuration including updates, no ctl alt delete?...OL 2003: Reminders via SMS message?
For years I've been using a little utility called my schedule that would
send email when a schedule/even came due. I used it to send SMS messages to
my cell phone.
Alas, this little utility doesn't work in OL 2003. Anybody know of
something else I can use?
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. Due to
the (insert latest virus name here) virus, all mail sent to my personal
account will be deleted without reading.
After searching google.groups.com and finding no answer, Joe Cam...WorkFlow for Sharing an Account via TEAM
I wanted to create a WorkFlow to Share an account to a team? Any ideas or
You need to do coding. Develop a workflow assembly for this purpose. There
is no built-in feature to share a record to a team.
uMar Khan :: MS CRM MVP
Microsoft CRM Consultant
Email :: imumar at gmail dot com
Blog :: http://umarkhan.wordpress.com
MVP :: https://mvp.support.microsoft.com/default.aspx/profile/umar.khan
> I wanted to create a WorkFlow to Share an account to a team? Any ideas or
....NET Client deployment!
I am looking at how to make use of the client
framework, but found the following problems:
The client framework does not include System.Designer
assembly. Without this assembly it is not possible to
register the components to be displayed on the toolbox.
(contains ToolboxItem attribute).
Is it somehow possible to produce two assemblies, where
one will register the components from the first to be
displayed on the toolbox within VS.IDE, but the actual
application will not require it's deployment?
I checked C# partial classes, but they require, that all
the definition...Eliminate Group Members
Is there a way, in Outlook XP to select a GROUP, which
has been created by the administrator, and send an e-mail
message to that group, but eliminate 1 or 2 people from
that group, without having to select everyone
individually from that group. The group may have upwards
of 100 people in it; it's very time consuming. The
people being "left out" will vary, but I still don't want
to have to re-enter all 95 or 98 of the others.
Any ideas would be appreciated.
This functionality is available on Outlook 2003 where you can "explode" the