Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
2003 sp3 changes how text .xls files open
Before SP3 we renamed a text file to filename.xls and then executed
it (done by an automatic process) which made excel open it up with all contents in the first column. It was then up to the user to do a text to columns either by fixed size or delimited as they wanted. After SP3 Excel auto-delimits the file , and I cannot see a way to stop it from doing this as 99% of the time its delimiting is wrong. Can anyone help or am I stuffed. ps excel 2003 .. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003 Latest patch changes how text .xls files open
On Mar 27, 1:52 pm, wrote:
Before SP3 we renamed a text file to filename.xls and then executed it (done by an automatic process) which made excel open it up with all contents in the first column. It was then up to the user to do a text to columns either by fixed size or delimited as they wanted. After SP3 Excel auto-delimits the file , and I cannot see a way to stop it from doing this as 99% of the time its delimiting is wrong. Can anyone help or am I stuffed. ps excel 2003 .. OOPS .. sorry its not SP3 related .. its related to the latest office security patches ... |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003 Latest patch changes how text .xls files open
Maybe one of Dave Peterson's comments in this post will be of help... http://tinyurl.com/2q5rr8 -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming) wrote in message On Mar 27, 1:52 pm, wrote: Before SP3 we renamed a text file to filename.xls and then executed it (done by an automatic process) which made excel open it up with all contents in the first column. It was then up to the user to do a text to columns either by fixed size or delimited as they wanted. After SP3 Excel auto-delimits the file , and I cannot see a way to stop it from doing this as 99% of the time its delimiting is wrong. Can anyone help or am I stuffed. ps excel 2003 .. OOPS .. sorry its not SP3 related .. its related to the latest office security patches ... |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003 Latest patch changes how text .xls files open
Hi Jim,
Actually I found what caused it .. http://support.microsoft.com/kb/943985 this patch V1 and V2 have changed how text based .xls files are opened, it seems to automatically run the text to columns wizard using the fixed width option which works on the first few lines of text to work out columns .. this isnt any good as usually our "text" files are reports from another system with headings etc that in no way line up with the columns of data .. (we get two columns in one , numbers cut in half ) . If I remove the two patches above .. V1 and V2 they open as I would expect with all data in the first column allowing the user to manually choose columns/ delims . I am unable to hold shift down as excel is being run/opened programatically from another program . Carl "Jim Cone" wrote: Maybe one of Dave Peterson's comments in this post will be of help... http://tinyurl.com/2q5rr8 -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming) wrote in message On Mar 27, 1:52 pm, wrote: Before SP3 we renamed a text file to filename.xls and then executed it (done by an automatic process) which made excel open it up with all contents in the first column. It was then up to the user to do a text to columns either by fixed size or delimited as they wanted. After SP3 Excel auto-delimits the file , and I cannot see a way to stop it from doing this as 99% of the time its delimiting is wrong. Can anyone help or am I stuffed. ps excel 2003 .. OOPS .. sorry its not SP3 related .. its related to the latest office security patches ... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
open 2000 files with 2003 | Excel Discussion (Misc queries) | |||
suddenly I cannot open any office 2003 files | Excel Discussion (Misc queries) | |||
Excel 2003 files not displaying it's already open | Excel Discussion (Misc queries) | |||
Excel 97-2003 files won't open in 2007? | Excel Discussion (Misc queries) | |||
how do i set Excel 2003 files to open in own window | Excel Discussion (Misc queries) |