I have an app that appends to a .xls file (tab delimited). I open excel and
then use File - Open to open the file read-only.

But every time I do it I have to go thru the Text Import Wizard and I lose
all my formatting. I need a way to go thru the wizard just the first time
and retaining the formatting.

If the data is saved as a text file (tab delimited), then the formatting won't
be saved.

Maybe you could start a new workbook
record a macro when you open the text file
keep recording as you format your data the way you like
and then stop recording.
(and close the text file)

Then add a button from the Forms toolbar to the first worksheet in that workbook
with the recorded macro. Assign the macro to this button.

Then whenever you need to import the text file, you can open this workbook and
click the button.

grok wrote:

I have an app that appends to a .xls file (tab delimited). I open excel and
then use File - Open to open the file read-only.

But every time I do it I have to go thru the Text Import Wizard and I lose
all my formatting. I need a way to go thru the wizard just the first time
and retaining the formatting.

--

Dave Peterson

But the app is writing the file as .xls so doesn't that make it an excel
file? I can make the app write any way I want is there some way to write so
formatting is retained?

"Dave Peterson" wrote:

If the data is saved as a text file (tab delimited), then the formatting won't
be saved.

Maybe you could start a new workbook
record a macro when you open the text file
keep recording as you format your data the way you like
and then stop recording.
(and close the text file)

Then add a button from the Forms toolbar to the first worksheet in that workbook
with the recorded macro. Assign the macro to this button.

Then whenever you need to import the text file, you can open this workbook and
click the button.

grok wrote:

I have an app that appends to a .xls file (tab delimited). I open excel and
then use File - Open to open the file read-only.

But every time I do it I have to go thru the Text Import Wizard and I lose
all my formatting. I need a way to go thru the wizard just the first time
and retaining the formatting.

--

Dave Peterson

If that application writes to a real excel workbook, then you shouldn't be
losing your formatting.

But I was confused by this:
I have an app that appends to a .xls file (tab delimited).

If that application writes to a text file with an extension of .xls, it's still
a text file. Just adding the extension isn't enough to convert the file to a
normal workbook.

If I had doubts about the real nature of that file, I'd open NotePad and then
File|Open the file that the application creates. (Do not save the file! You
could destroy it--in fact, it would be safer to do this against a copy.)

If you see plain old text in that file (while in notepad), then it's not an
excel workbook.

If you see a bunch of greek text that you can't decipher (for the most part),
then the file could be a normal excel workbook.



grok wrote:

But the app is writing the file as .xls so doesn't that make it an excel
file? I can make the app write any way I want is there some way to write so
formatting is retained?

"Dave Peterson" wrote:

If the data is saved as a text file (tab delimited), then the formatting won't
be saved.

Maybe you could start a new workbook
record a macro when you open the text file
keep recording as you format your data the way you like
and then stop recording.
(and close the text file)

Then add a button from the Forms toolbar to the first worksheet in that workbook
with the recorded macro. Assign the macro to this button.

Then whenever you need to import the text file, you can open this workbook and
click the button.

grok wrote:

I have an app that appends to a .xls file (tab delimited). I open excel and
then use File - Open to open the file read-only.

But every time I do it I have to go thru the Text Import Wizard and I lose
all my formatting. I need a way to go thru the wizard just the first time
and retaining the formatting.

--

Dave Peterson


--

Dave Peterson

Dave, I looked at the file with Notepad and it looked normal so it's not an
excel workbook. What happens is:

1. My app deletes the file (if it exists) and writes a header to it tab
delimited. (Not excel here)
2. I open excel and then open the file with File-Open.
3. I format the spreadsheet and save back to the same file.

Does step 3. convert the file to a worksheet? I guess not. Is there some
way to convert it to excel?

grok



"Dave Peterson" wrote:

If that application writes to a real excel workbook, then you shouldn't be
losing your formatting.

But I was confused by this:
I have an app that appends to a .xls file (tab delimited).

If that application writes to a text file with an extension of .xls, it's still
a text file. Just adding the extension isn't enough to convert the file to a
normal workbook.

If I had doubts about the real nature of that file, I'd open NotePad and then
File|Open the file that the application creates. (Do not save the file! You
could destroy it--in fact, it would be safer to do this against a copy.)

If you see plain old text in that file (while in notepad), then it's not an
excel workbook.

If you see a bunch of greek text that you can't decipher (for the most part),
then the file could be a normal excel workbook.



grok wrote:

But the app is writing the file as .xls so doesn't that make it an excel
file? I can make the app write any way I want is there some way to write so
formatting is retained?

"Dave Peterson" wrote:

If the data is saved as a text file (tab delimited), then the formatting won't
be saved.

Maybe you could start a new workbook
record a macro when you open the text file
keep recording as you format your data the way you like
and then stop recording.
(and close the text file)

Then add a button from the Forms toolbar to the first worksheet in that workbook
with the recorded macro. Assign the macro to this button.

Then whenever you need to import the text file, you can open this workbook and
click the button.

grok wrote:

I have an app that appends to a .xls file (tab delimited). I open excel and
then use File - Open to open the file read-only.

But every time I do it I have to go thru the Text Import Wizard and I lose
all my formatting. I need a way to go thru the wizard just the first time
and retaining the formatting.

--

Dave Peterson


--

Dave Peterson

I guess that what I have to do is have the app write the header to a
different file name, open that file with excel, format it, save it to the
final file name, exit excel. Then can the app append to it without
destroying its status as an excel workbook?

"grok" wrote:

Dave, I looked at the file with Notepad and it looked normal so it's not an
excel workbook. What happens is:

1. My app deletes the file (if it exists) and writes a header to it tab
delimited. (Not excel here)
2. I open excel and then open the file with File-Open.
3. I format the spreadsheet and save back to the same file.

Does step 3. convert the file to a worksheet? I guess not. Is there some
way to convert it to excel?

grok



"Dave Peterson" wrote:

If that application writes to a real excel workbook, then you shouldn't be
losing your formatting.

But I was confused by this:
I have an app that appends to a .xls file (tab delimited).

If that application writes to a text file with an extension of .xls, it's still
a text file. Just adding the extension isn't enough to convert the file to a
normal workbook.

If I had doubts about the real nature of that file, I'd open NotePad and then
File|Open the file that the application creates. (Do not save the file! You
could destroy it--in fact, it would be safer to do this against a copy.)

If you see plain old text in that file (while in notepad), then it's not an
excel workbook.

If you see a bunch of greek text that you can't decipher (for the most part),
then the file could be a normal excel workbook.



grok wrote:

But the app is writing the file as .xls so doesn't that make it an excel
file? I can make the app write any way I want is there some way to write so
formatting is retained?

"Dave Peterson" wrote:

If the data is saved as a text file (tab delimited), then the formatting won't
be saved.

Maybe you could start a new workbook
record a macro when you open the text file
keep recording as you format your data the way you like
and then stop recording.
(and close the text file)

Then add a button from the Forms toolbar to the first worksheet in that workbook
with the recorded macro. Assign the macro to this button.

Then whenever you need to import the text file, you can open this workbook and
click the button.

grok wrote:

I have an app that appends to a .xls file (tab delimited). I open excel and
then use File - Open to open the file read-only.

But every time I do it I have to go thru the Text Import Wizard and I lose
all my formatting. I need a way to go thru the wizard just the first time
and retaining the formatting.

--

Dave Peterson


--

Dave Peterson

If you don't do anything special with #3, then it's still plain text.

But you could use File|SaveAs and choose an excel workbook (normal workbook) at
the top of the "Save as Type" box.

---
You should have gotten a warning from Excel each time you just saved the text
file. Excel will try to convince you to save it as a normal workbook--but it's
your decision to dismiss that warning message.



grok wrote:

Dave, I looked at the file with Notepad and it looked normal so it's not an
excel workbook. What happens is:

1. My app deletes the file (if it exists) and writes a header to it tab
delimited. (Not excel here)
2. I open excel and then open the file with File-Open.
3. I format the spreadsheet and save back to the same file.

Does step 3. convert the file to a worksheet? I guess not. Is there some
way to convert it to excel?

grok

"Dave Peterson" wrote:

If that application writes to a real excel workbook, then you shouldn't be
losing your formatting.

But I was confused by this:
I have an app that appends to a .xls file (tab delimited).

If that application writes to a text file with an extension of .xls, it's still
a text file. Just adding the extension isn't enough to convert the file to a
normal workbook.

If I had doubts about the real nature of that file, I'd open NotePad and then
File|Open the file that the application creates. (Do not save the file! You
could destroy it--in fact, it would be safer to do this against a copy.)

If you see plain old text in that file (while in notepad), then it's not an
excel workbook.

If you see a bunch of greek text that you can't decipher (for the most part),
then the file could be a normal excel workbook.



grok wrote:

But the app is writing the file as .xls so doesn't that make it an excel
file? I can make the app write any way I want is there some way to write so
formatting is retained?

"Dave Peterson" wrote:

If the data is saved as a text file (tab delimited), then the formatting won't
be saved.

Maybe you could start a new workbook
record a macro when you open the text file
keep recording as you format your data the way you like
and then stop recording.
(and close the text file)

Then add a button from the Forms toolbar to the first worksheet in that workbook
with the recorded macro. Assign the macro to this button.

Then whenever you need to import the text file, you can open this workbook and
click the button.

grok wrote:

I have an app that appends to a .xls file (tab delimited). I open excel and
then use File - Open to open the file read-only.

But every time I do it I have to go thru the Text Import Wizard and I lose
all my formatting. I need a way to go thru the wizard just the first time
and retaining the formatting.

--

Dave Peterson


--

Dave Peterson


--

Dave Peterson