Problem with komma versus period in Excel
I am have problems with the use of period in Excel. I
Denmark komma is the decimal seperator.
If I convert (from within VB Editor) the content of a cell
from "6340,00" to text and replace the komma with period I
get "6340" (I wanted "6340.00).
If I make the convertion in Excel and record the macro at
the same time I get the desired result i my sheet. BUT
when I put in my code in VBA and run it from here I still
get the wrong result, "6340" and not "6340.00".
I know Excel (VBA) transform "." to "," probably acording
to...Is it possible to generate non-technical schema validation errors?
With the 1.0 Framework, I've worked out using the XmlValidatingReader. Since
I'm using the validation errors as feedback to the end user, I'm hoping to
get away from techy messages such as "The
'http://tempuri.org/XMLFile1.xsd:MaxDependents' element has an invalid value
according to its data type. An error occurred at
and go with a user friendly message of "Max Dependents must be between 0 and
10". I've scoured the newsgroups, MSDN and docs for creating custom
valid...How to create an "and" rule in Query Based Distribution Groups
With Exchange 2003 Query Based Distribution groups, is it possible to create
an "and" rule? ie, all users who are based in "London" "and" have the first
Please reply to news group only. Thank you.
"Curtis Fray" <email@example.com> wrote in message
news:OjVc...Time performance Chart
I need to develop a chart that graphically depicts an employees start
time and end time each day. This chart would be a bar chart. The bar
chart would have days of the month along the bottom, and the side
would start at 00:00 at the bottom and end at 24:00 at the top. I
need to be able to enter an employees start time and end time and have
it charted along the bar. So if the employee started at 07:00 and
ended work at 18:00, the chart would show a colored bar that
corresponds to the start time and the end time. Also, if an employee
came back to work the chart would refl...date/time formatting
I download a csv report from a web based program. Everything works great
but the date comes through as "Jul 21 2009 1:51pm". I do not need the time
in my report. I have tried reformatting the cells, tried to copy to a new
file with the cells already formatted to "7/21/09", opening the cell format
using the F2 key and deleting the time (time will still not be formatted
correctly). The only way I get get just the time is to retype every cell.
What am I doing wrong?
I am using Excel 2002 SP3
When data is downloaded from the web, a lot of "other&quo...Time Conversion
I need help in converting time. I am using data from a time clock which
currently formats time as 1.5. When I input this data into a cell how can I
have it formated to read 1 hour and 30 minutes (1:30)
What you could do in an adjacent row or column is format
them as Time and then using a formula, divide the input
time by 24(hours in a day).
>I need help in converting time. I am using data from a
time clock which
>currently formats time as 1.5. When I input this data
into a cell how can I
>have it formated to read 1 hour and 30 minut...Prevent users from saving music and pictures to their hard drives without folder redirection?
Hi there. I'm wondering if there is a way via GPO or anything else to
prevent users from saving music and pictures to their local hard
drives without using any type of profile or folder redirection.
I have four fields on a form to show time. I want a seprate "Total" field to
add the time between the first two fields and then add the time between the
second two fields. Like this:
In LunchOut LunchIn Out
6:00am 12:00pm 12:30pm 4:30pm
The first four fields are stored as medium times. Can someone let me know
how to do this?
Message posted via AccessMonster.com
"ladybug via AccessMonster.com&quo...time formats #3
I have an Excel sheet with a long list of times spent on various projects.
The times should all be in minutes and seconds. The first time reads 2:29
and I know that is accurate, for 2 min, 29 seconds. In the formula bar, it
reads, 2:29:00 AM. Another...the cell displays 0:40 and I know that is
right, for 40 seconds. But in the formula bar, I see 12:40:00 AM
I want numbers, but apparently I am looking at times.
I tried changing the format. When I check the format for 2:29, it comes up
Custom and says it is hh:mm, not mm:ss. I tried changing it to mm:ss, but
that changes the displa...Winmail takes 4 minutes to load at boot time
Running Windows Vista Home Premium on Lenovo Laptop 2 gig mem. After
logging in after rebooting, it takes 4 minutes to load Win mail. I used the
"event Viewer" to see what was happening. It showed ESENT with ID
102--start Win mail, then the next event is ESENT ID 103 4 minutes
later--terminate Win mail.
Anyone have a clue why it is taking Win mail so long to load? Win mail
works fine after computer loads.
> Running Windows Vista Home Premium on Lenovo Laptop 2 gig mem. After
> logging in after rebooting, it takes 4 minutes ...Preventing changes in the Options
Is there a way in Excel to prevent users from making any
changes in the Options (ie protect or disable the Options
Thanks in advance,
...Taking a loooong time for new mailboxes to appear.
We have a tool which creates a batch of mailboxes, then logs into each
one via MAPI to migrate old messages.
Today we ran the tool and mailbox-enabled 300+ mailboxes in one go.
Although the Exchange tabs were present and the SMTP address was filled
out on each user in ADUC, the mailboxes didn't appear in ESM until
about an hour later. How is that possible?
Manually running RUS didn't help either. We've got one DC and a
separate E2k3 server.
Any RED errors in the event logs on that Exchange box during that time>
...Rules gone crazy!
When I create a rule to move mail sent to a second e-mail
account into a specified folder I follow the steps listed
at the end of this post. However, when I choose the
email acount I'm interested in (we'll use New email and
Old email as the accounts) it changes on me. In other
words, let's say I want a rule that sends my Old email
messages to an Old Email folder, I follow the correct
steps and then press ok. When I go back to look at the
rule afterwards, the email account shows New email,
instead of Old email. No matter how many times I change
it back or punch the wal...how do I format cells to change date and time to just date
I want to format a column that contains date and time and I want it to show
just the date and not the time. Going into format and clicking on the date
and changing doesnt work.
Probably the cells aren't really dates, but text. You can check with the
If they are text, formatting doesn't have any effect.
Microsoft MVP - Excel
"bondam" <firstname.lastname@example.org> wrote in message
>I want to format a column that contains date and time and I want it t...Prevent copy and paste in one column
I am having trouble trying to prevent copying and pasting in one specific
column. The code refers to the specific range, but yet it prevents copying
and pasting on the whole worksheet.
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Not Intersect(Target, Columns("H:H")) Is Nothing Then
Application.CellDragAndDrop = False
Application.CutCopyMode = False
Application.CellDragAndDrop = True
Works for me in Excel 2003
Gord Dibben MS Excel MVP
On Fri, 30 Apr 2010 11:42:01...How to prevent line breaks in XML file?
I am creating XML from SQL2000 using a vb.net page, then posting it to
a remote server as a string.
The remote server requires that the xml contain no line breaks, but
there are some ntext fields in the database that contain long text
with line breaks.
How do I get rid of the line breaks? Can I do this with the
XmlTextWriter, or do I need to handle each affected field seperately
before handing it to the XmlTextWriter?
> How do I get rid of the line breaks? Can I do this with the
> XmlTextWriter, or do I need to handle each affected field seperately
> bef...Counting the number of times more than 1 variable occurs
I need to determine how many Separations were processed by a particular
A | B
1 MIKE | SEPARATION
2 MIKE | LEAVE
3 SARA | SEPARATION
4 JOE | SEPARATION
5 JAMIE | LEAVE
6 MIKE | LEAVE
7 JOE | LEAVE
8 SARA | SEPARATION
The only way I can think of is the COUNTIF Funtion
This does not work though. The results return 0 with no errors when
the answer should be 1.
does anyone else know of a wa...Validation Problem #2
I have a schema file PDDSch.xsd which validates the PDD.xml file. the
rootnodes are as shown below
<PDD xmlns="http://tempuri.org/PDDSch.xsd" xmlns:xsi="http://www.w3.org/2001/XMLSchema-Instance" >
attributeFormDefault="quali...Want to modify this procedure to have a range of periods rather than a single period
This is a multi-part message in MIME format.
I have the procedure below
I want simply modify the periods procedure below to be -- perpost >=3D =
'201001' and <=3D '201012' so I want a range of periods rather than a =
single period as in the example below
I would really appreciate it if someone can help me out on this.
Declare @perpost nvarchar(8)
/* Do not edit Above=20
...How to prevent users sending mail on Internet ?
Do you know how to prevent certain users (NOT all users) to sending
mail on Internet ?
I am using Exchange 2003 with Outlook 2000 clients
Thank you in advance,
PS : french translation of this message is also posted on this group
you could try permissions on the default server object. Not tried this
Just had a play with my exchange setup.
If your using Connectors, you can set who can access through it. Under
delivery restrictions select who can access the net through this connector.
Then reject all others. If the address space on this connector is set to * ...Date/Time stamp in Memo Field
Hi all..is it possible to programmatically insert Now() when text in a Memo
field becomes edited?
Thanks for all help!
If it has to be entered directly in the memo field tetxbox:
Private Sub MemoFieldName_AfterUpdate()
If IsNull(Me.MemoFieldName.OldValue) Then
Me.MemoFieldName = Now & " " & Me.MemoFieldName
Me.MemoFieldName = Left(Me.MemoFieldName, Len(Me.MemoFieldName.OldValue)) &
" " & Now & " " & Right(Me.MemoFieldName, Len(Me.MemoFieldName) - Len(Me.
Me.Dirty = False
End...Run-time error 432
I'm getting a run-time error 432 when trying to open some areas of a VB
program in excel. This program works on some machines and not others. We
all have the same version of excel and our settings seem to be the same.
Does anyone have any idea where I can start to look for the reason this is
After doing a search of Google, you may like to try this solution...
download and install file....
Then go to RUN and type: Regsvr32C:\WINDOWS\SYSTEM\Dao360.dll ...Rules Wizard #53
After installing office 2003 which connects to MS small biz server when i
select the Rules Wizard its just flashes up and disapears again, i have tried
the repair option and even installed a new copy of Office on this XP machine
and it still wont work, it works ok on the other PC's in the office, thanks
in advance of any help i can get
...Outlook Filter Mail
Hi, I would like to know if it is possible to direct mail from a
particular domain (e.g. @yahoo.com) to a particular folder using Rules
& Alerts or VBA Macro.
Thanks for your help!
Sure. Use the condition "with specific words in the sender's address" =
and enter the domain name.=20
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
and Microsoft Outlook Programming - Jumpstart for=20
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx...Validate if a mail user exsits
Can Exchange 2003 SP2 be configured to just drop any email that it receives for
and @company.com address that doesn't have a valid username?
I am looking for a built in option or relativley easy/inexpensive option,
nothing like GFI Mailessentilas or the like, but preferably built in to Exch
Yes. ESM/Message Delivery/Properties/Recipient Filtering. Check the box
"Filter recipients who are not in the Directory"
Now you need to enable Recipient Filtering.
ESM/servers/Servername/Protocols/SMTP/Default SMTP Virtual
Server/Properties. On the...