| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
International HTML Import Problem
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Import HTML Table | Setting up and Configuration of Excel | |||
| HTML Import Errors | Excel Discussion (Misc queries) | |||
| html import errors | Excel Discussion (Misc queries) | |||
| HTML/XML Import Error -ExcelName | Excel Programming | |||
| international problem, decimal separator and chart series | Excel Programming | |||
Threaded Mode
