Open New from Word Template

M

MIG

I think there's plenty of advice on opening Word documents using VBA
in Access, but does anyone know how to open a new document based on a
template?

I've been able to open the Word template from access for editing, as
happens when one opens it from within Word, but I want to open a new
document based on the template (and run the AutoNew) as when you run a
template from Windows Explorer or do a File, New.

Any ideas? Thanks.
 
D

Dave

I think there's plenty of advice on opening Word documents using VBA
in Access, but does anyone know how to open a new document based on a
template?

I've been able to open the Word template from access for editing, as
happens when one opens it from within Word, but I want to open a new
document based on the template (and run the AutoNew) as when you run a
template from Windows Explorer or do a File, New.

Any ideas?  Thanks.

Just a quick search gave me this link to export a report to Word based
on a template. If all you're doing is opening a blank document from a
template, it should be even easier than what is shown at the link
below. May not help you, but seeing as how you have no reply yet, I
thought it worth a shot.
http://en.allexperts.com/q/Using-MS-Access-1440/report-Output-word-template..htm
 
A

a a r o n . k e m p f

SQL Server Reporting Services is free and it is 100 times better at
generating word docs than mountains and mountains of VBA code
 
M

MIG

Just a quick search gave me this link to export a report to Word based
on a template. If all you're doing is opening a blank document from a
template, it should be even easier than what is shown at the link
below. May not help you, but seeing as how you have no reply yet, I
thought it worth a shot.http://en.allexperts.com/q/Using-MS-Access-1440/report-Output-word-te...

OK ... so the bit that's actually doing the work is
wdapp.Documents.Add as opposed to .Open?

That's pretty simple but I didn't spot it.

Incidentally, would that create a copy of a .doc file or would it have
to be a .dot?

Thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top