I have to confess I am a complete dummy when it comes to VB.
I have an Excel spreadsheet which I would like to export to notepad.
There are 4 sheets to the spreadsheet.
The first takes input and runs some calculations and gives out figures. The following three take the information and translate it into a series of commands to form 3 scripts (one per sheet) to automatically draw 3 assemblies in Autocad, each sheet forms a seperate script file, one for each assembly.
The commands are all contained in column A rows A1 to A113.
There are blank cells in the column which issue return characters within the script file so must be transfered as blank lines into notepad.
Cell A92 contains text which can be used as a file name to save the file and the file extension should be .scr
I would like to put a button on the sheet to run the macro, I assume I can do this simply?
Can anyone help please.
I have an Excel spreadsheet which I would like to export to notepad.
There are 4 sheets to the spreadsheet.
The first takes input and runs some calculations and gives out figures. The following three take the information and translate it into a series of commands to form 3 scripts (one per sheet) to automatically draw 3 assemblies in Autocad, each sheet forms a seperate script file, one for each assembly.
The commands are all contained in column A rows A1 to A113.
There are blank cells in the column which issue return characters within the script file so must be transfered as blank lines into notepad.
Cell A92 contains text which can be used as a file name to save the file and the file extension should be .scr
I would like to put a button on the sheet to run the macro, I assume I can do this simply?
Can anyone help please.
