Macro export excel with saving text format

[warfollowmy_ver]

!I want to upload an excel object with saving format.

0000 in front of the text. My macro inserts the data as values.

I have an idea!

First unload the headlines.

Then find the Код - assign a text format this column and insert data as usual.

How to do it in a macro? !