How to make a userform.

[Dan-Rod]

Hello, I have an excel in which I fill in data to be able to convert it to a .scr file since it is a routine to convert files with multiple sheets from pdf to dwg.

The problem is that I have to be modifying the excel, go to notepad and save in .scr, I would like to see if someone can help me know how to have a userform in which I feed only the data that makes the routine work, in this case it would be 2, the size of the sheet and the file path, the excel is already formulated.

[Sea-Haven]

Three answers, are you aware you can copy a excel column of cells and paste to command line, no script required.

A excel VBA macro can write a file based on column values just google write file column cells Excel VBA, I am sure an answer is there.

Last answer can read a Excel file from CAD, so would read the cell data and use that in a lisp command. Just reading rows of data.

So your choice.