Open test.dot

[ChrissyBZ]

HI!

Sorry for my bad english but i´m from germany!

I have a problem:

I want to open with a button a test.dot!

How can i handle this?

thank you all for your answer!

Bye

Chrissy

[Pirate]

Sorry I don't get it ? What's that you want to open ??

[ChrissyBZ]

I want to open a template (test.dot)

This is a word file (makro)!

Whis this file i can make Serial letters

i have made it so:

Dim xlApp As Word.Application
xlApp = CreateObject("Word.Application")
xlApp.Documents.Open("D:\test.dot")
xlApp.Visible = True


But when i try it so, then only word opens the test.dot!

But actually the program should open a new document with the ending .doc

[Pirate]

Try this with the right path to your file .

Dim proc As New Process()
proc.Start("c:\readme.txt")

[ChrissyBZ]

Thank you for you really fast answer!

But whith you suggestion Word opens the test.dot!

Normally when i click in the explorer on the test.dot word opens a new document whith the test.dot makro!

I will try,

i hope i will find a sollusion


Thank you

[Pirate]

if you want to start new sheet then pass the path of macro application instead of the file name .

[ChrissyBZ]

Thank you!

[Pirate]

Here's a tutorial teaches you how to pass one or multiple file parameters to start an application in customized way!

It should all of your questions !

[ChrissyBZ]

Wow cool!

Thank you very much!