ReImport text data and keep existing formatting

[seannakasone]

Hi, how do I import data from a text file into spreadsheet and preserve
the existing formatting of the spreadsheet? The reason is because I
periodically generate a text file from a database, I then open the text
file in Excel (specify the appropriate field delimiter) then it opens in a
new spreadsheet, but with default formatting. I then format the cells.
Instead, I would like to regenerate the text file, and import it into an
existing excel spreadsheet, keeping the existing formatting and have the
data be replaced.

 

[Dennis Tucker]

Use the two workbook approach.

Have one workbook formatted and ready to receive the new data.

The other workbook is the new(unformatted) version that you do normally.

Next, copy all the data for the new(unformatted) version and use
pastespecial(values) to put the unformatted info into the correct format.


Dennis