Codemodule insertlines problem

Hi all,

Basically I'm trying to use a texbox.value to be inserted in a codemodule line. Line 6 & 7 to be exact. The textbox name is "frmNewAccount.txtNewAccountName". The codemodule name is "cmdSaveQuote".

So here is my problem. The workbook name and file path that I'm trying to change it to doesn't exist yet. I have a userform with a textbox. When the user types in text and clicks "OK" then the new workbook with file path will be created so I don;t know the exact file name. The workbook file name will be whatever the user types into the textbox "txtNewAccountName". In my code I Dim file_name As string and file_name = frmNewAccount.txtNewAccountName. So when I insertlines in the code module I use file_name. It litterally inserts "file_name" instead of the value in the textbox obviously because I'm not doing it correctly. My code is incomplete because I ran into this road block but...

Here is my code,

Please Login or Register  to view this content.

Any help on this would be greatly appreciated. I've been banging my head against the wall for several days trying to get this code to do what I want. Code that writes code is hard. I'm barely learning it now. I didn't even know it existed until about a week ago.

Moderator note - code tags added for you

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here