VBA Export Excel to Notepad

[Oldfozzy]

I would like to export some excel columns to notepad using VBA.
I have 4 sheets in an excel the first is an input and basic calculation sheet the next three are output sheets.

The information is contained in the three sheets in Column A, cells 1 to 113.
It consists of text, numbers, and blank cells, The output is a "Script" file for Autocad which requires the blank cells to act as "Return" characters in Autocad.

Each output sheet provides the command information to draw one item in Autocad.
I want to be able to output each of the 3 sheets seperately to different files.
The 3 files can be named from the text in cell A92, and the Notepad file should be of a .scr filetype.

 

[Oldfozzy]

I'll do that when I get home I can't do stuff like that on the company pc it won't permit it...
I'll email the file to myself.

 

[Oldfozzy]

I'll do that when I get home I can't do stuff like that on the company pc it won't permit it...
I'll email the file to myself.

https://www.dropbox.com/s/usmac2tpyw8al13h/Drawing_spiral_staircase.xls

 

[Oldfozzy]

I'll do that when I get home I can't do stuff like that on the company pc it won't permit it...
I'll email the file to myself.

Sorry there's a stray 1 that Url it should be

https://www.dropbox.com/s/usmac2tpyw8al3h/Drawing_Spiral_staircase.xls