File dropping leading zeros when imported into Excel

[ABerkowicz]

Hi.

I am relatively new to VB and VBA and need some assistance.

I have a macro written in VBA that calls an exported txt file. This macro brings the exported file into excel and does some manipulation. The problem that I am having is that when the export file is brought into excel, the leading zeros of a job number are dropped off. The leading zeros are in the export file; however, I need them to stay when I import them into excel.

Can someone give me some help/hints?

Thank you!
Angela

 

[JohnYingling]

I believe you will need to define that column as having "TEXT" rather than the default "General". If you need to know how to set it then just record a macro while you set a column to "TEXT" in a dummy workbook, stop recording and go look at the generated code in the macro.

http://WWW.VBCompare.Com