Can I use another text editor to write or modify an spBasic program?
Yes. The SpBasic Edit Form has a built-in editor, or you can use your favorite text editor. I use a single quote in front of a workbook name as a variable value, but I get an error. The single quote is dropped by Excel before the term is evaluated. Put two single quotes before workbook name, one will be dropped but the other one will be valid.