.SaveAs2 in excel with txtBox.Value

[cvelle89]

Hello,
Please give me a feedback about this code>

Please Login or Register  to view this content.

and

Please Login or Register  to view this content.

Please provide me any additional solution (it can be simple one without txtBoxes..).

Thank you very much!

[Norie]

Could you give us some more information?

For example, what are you trying to do?

Also, where did you get SaveAs2 from?

[cvelle89]

Ok.

Well I want to import data from UserForm directly to the word document via bookmarks.

I've attached .xls as well as template in word.
On button "Import&new" you can see code.

What do you think?

I ve added just bookmarks 1 2 and 3, later on I will add more for the whole table in word.

Any suggestion would be appreciated!

Thanks!

[Norie]

What are you trying to do?

What's not working?

[cvelle89]

I get run time error 438, it is highlighted the row where is .saveAs2 code..

And I dont know why..

Thanks and sorry fot the confusion

[Norie]

What's the error message?

What's in txtName when you get the error?

[cvelle89]

run time error -2147417851 (80010105)
Automation error
The server threw an exception.

I've modified a litle bit a line > .SaveAs2 FILE_PATH & Cells(1, 1) & FILE_EXT, I've ran it through debugger. All is OK, it writes the values into FILE_PATH, Cells(1,1,) - I put some values into A1 cell just to be sure instead of txtName.Value..but still nothing.