My users are emailed an "excel" file each day from the USA. This file
is an extract from a website. It is coded as html (see sample below).
The problem is that the date is coded as mm/dd/yyyy. My users are
Excel/German date format is is dd/mm/yyyy.
I am writing a macro that opens this file, copies the data, and pastes
it into another spreadsheet. When my users open the data file, their
native language Excel automatically converts the date (in the example
below, it converts to an text because 25/10/2005 is not a valid date),
and I'm hosed before I begin.
1) The data set is 10,000 elements per day.
2) There are 35 columns. I'm only showing you one column.
3) We are using Excel 2000 & 2002
I can't read this file as a text file because it's in HTML.
I cannot ask users to change their local language settings.
Suggestions? Please help!!!
Is there a way to write code that will temporarily change the Excel
language setting for the user, open the data file, copy the data, and
change the language setting back?
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"
<html
<head
<meta content="Microsoft Visual Studio 7.0" name=GENERATOR
<meta content=C# name=CODE_LANGUAGE
<meta content=JavaScript name=vs_defaultClientScript
<meta content=http://schemas.microsoft.com/intellisense/ie5
name=vs_targetSchema
</head
<td align="Center"Customer Required Date</td 10/25/2005
--
aldsv
------------------------------------------------------------------------
aldsv's Profile:
http://www.excelforum.com/member.php...o&userid=20494
View this thread:
http://www.excelforum.com/showthread...hreadid=385185