![]() How I want the text file to look is also attached. Open DraftSight program (see location below)ĭraftSight is located in "C:\Program Files (x86)\Dassault Systemes\DraftSight\bin\DraftSight.exe".Īttached is the worksheet (I saved as a non-vba enabled worksheet) (example: if user types "scripttest" and if scriptest exists, then save as "scripttest1")ĥ. ![]() If name exists, then add a numeric number after the filename. Initiate an InputBox to ask user what they want the txt file (or script file) to be called. I've searched this forum and tried other code in here but the best i've found will copy all the data to a text file, but leave numerous spaces in between script commands which is unacceptable.Ģ. I have my excel worksheet setup up so that all I need to do is copy and paste Range T6:T163 to a text file, then save as a ".scr" file and the script will run perfectly. DraftSight is a knock-off version (yet FREE version) of AutoCAD that unfortunately does not have VBA capabilities (but can initiate scripts). The data is used to create a script that is later to be run by the program DraftSight. If the file name already exists then a version number is parentheses is appended to file name like 'DraftScript(1).scr'. However, the only files listed are those with a '.scr' extension. I have data in excel that I need to copy to a. This will create a '.scr' file from the values in column 'T'.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |