I am trying to fulfill some contract document, made from
word documents with information I would get from Excel.
I am not talking of the publipostage option as this
command should be done trhough the program I have created
from Excel in VBA.
For exemple : car rental contract
from the windows on screen, developped in VBA, I want to
print the data I have just input on a renting contract,
which is a word document.
Cette action est irreversible, confirmez la suppression du commentaire ?
Signaler le commentaire
Veuillez sélectionner un problème
Nudité
Violence
Harcèlement
Fraude
Vente illégale
Discours haineux
Terrorisme
Autre
Lydya
Hi Eric
This may give you an idea...
Sub WordFromExcel() Dim AppWord As Object Set AppWord = CreateObject("Word.Application") With AppWord .Visible = True 'creates a new Word document .documents.Add 'opens an existing document (change path) '.documents.Open FileName:="C:whatever.doc" .activedocument.PrintOut End With End Sub
You need to add the Microsoft Word Object Library to your Excel VBE (Tools / References...) to access the VBA Word help.
Lydya
------------- "Eric" a écrit dans le message de news:01f101c39339$fcd2d3c0$
hi everybody,
I am trying to fulfill some contract document, made from word documents with information I would get from Excel.
I am not talking of the publipostage option as this command should be done trhough the program I have created from Excel in VBA.
For exemple : car rental contract from the windows on screen, developped in VBA, I want to print the data I have just input on a renting contract, which is a word document.
Do you have any idea about it.
cheers
Eric
Hi Eric
This may give you an idea...
Sub WordFromExcel()
Dim AppWord As Object
Set AppWord = CreateObject("Word.Application")
With AppWord
.Visible = True
'creates a new Word document
.documents.Add
'opens an existing document (change path)
'.documents.Open FileName:="C:whatever.doc"
.activedocument.PrintOut
End With
End Sub
You need to add the Microsoft Word Object Library to your Excel VBE (Tools /
References...) to access the VBA Word help.
Lydya
-------------
"Eric" <anonymous@discussions.microsoft.com> a écrit dans le message de
news:01f101c39339$fcd2d3c0$a301280a@phx.gbl...
hi everybody,
I am trying to fulfill some contract document, made from
word documents with information I would get from Excel.
I am not talking of the publipostage option as this
command should be done trhough the program I have created
from Excel in VBA.
For exemple : car rental contract
from the windows on screen, developped in VBA, I want to
print the data I have just input on a renting contract,
which is a word document.
Sub WordFromExcel() Dim AppWord As Object Set AppWord = CreateObject("Word.Application") With AppWord .Visible = True 'creates a new Word document .documents.Add 'opens an existing document (change path) '.documents.Open FileName:="C:whatever.doc" .activedocument.PrintOut End With End Sub
You need to add the Microsoft Word Object Library to your Excel VBE (Tools / References...) to access the VBA Word help.
Lydya
------------- "Eric" a écrit dans le message de news:01f101c39339$fcd2d3c0$
hi everybody,
I am trying to fulfill some contract document, made from word documents with information I would get from Excel.
I am not talking of the publipostage option as this command should be done trhough the program I have created from Excel in VBA.
For exemple : car rental contract from the windows on screen, developped in VBA, I want to print the data I have just input on a renting contract, which is a word document.
Do you have any idea about it.
cheers
Eric
Transport adapté Amos
You pourrais make the programme in Word et use le mail-merge.
"Eric" a écrit dans le message de news:01f101c39339$fcd2d3c0$
hi everybody,
I am trying to fulfill some contract document, made from word documents with information I would get from Excel.
I am not talking of the publipostage option as this command should be done trhough the program I have created from Excel in VBA.
For exemple : car rental contract from the windows on screen, developped in VBA, I want to print the data I have just input on a renting contract, which is a word document.
Do you have any idea about it.
cheers
Eric
You pourrais make the programme in Word et use le mail-merge.
"Eric" <anonymous@discussions.microsoft.com> a écrit dans le message de
news:01f101c39339$fcd2d3c0$a301280a@phx.gbl...
hi everybody,
I am trying to fulfill some contract document, made from
word documents with information I would get from Excel.
I am not talking of the publipostage option as this
command should be done trhough the program I have created
from Excel in VBA.
For exemple : car rental contract
from the windows on screen, developped in VBA, I want to
print the data I have just input on a renting contract,
which is a word document.
You pourrais make the programme in Word et use le mail-merge.
"Eric" a écrit dans le message de news:01f101c39339$fcd2d3c0$
hi everybody,
I am trying to fulfill some contract document, made from word documents with information I would get from Excel.
I am not talking of the publipostage option as this command should be done trhough the program I have created from Excel in VBA.
For exemple : car rental contract from the windows on screen, developped in VBA, I want to print the data I have just input on a renting contract, which is a word document.
Do you have any idea about it.
cheers
Eric
Eric
What is exactly the mail merge???
-----Message d'origine----- You pourrais make the programme in Word et use le mail- merge.
"Eric" a écrit dans le message de
news:01f101c39339$fcd2d3c0$
hi everybody,
I am trying to fulfill some contract document, made from word documents with information I would get from Excel.
I am not talking of the publipostage option as this command should be done trhough the program I have created
from Excel in VBA.
For exemple : car rental contract from the windows on screen, developped in VBA, I want to print the data I have just input on a renting contract, which is a word document.
Do you have any idea about it.
cheers
Eric
.
What is exactly the mail merge???
-----Message d'origine-----
You pourrais make the programme in Word et use le mail-
merge.
"Eric" <anonymous@discussions.microsoft.com> a écrit dans
le message de
news:01f101c39339$fcd2d3c0$a301280a@phx.gbl...
hi everybody,
I am trying to fulfill some contract document, made from
word documents with information I would get from Excel.
I am not talking of the publipostage option as this
command should be done trhough the program I have
created
from Excel in VBA.
For exemple : car rental contract
from the windows on screen, developped in VBA, I want to
print the data I have just input on a renting contract,
which is a word document.
-----Message d'origine----- You pourrais make the programme in Word et use le mail- merge.
"Eric" a écrit dans le message de
news:01f101c39339$fcd2d3c0$
hi everybody,
I am trying to fulfill some contract document, made from word documents with information I would get from Excel.
I am not talking of the publipostage option as this command should be done trhough the program I have created
from Excel in VBA.
For exemple : car rental contract from the windows on screen, developped in VBA, I want to print the data I have just input on a renting contract, which is a word document.
Do you have any idea about it.
cheers
Eric
.
Lydya
publipostage!!!
"Eric" a écrit dans le message de news:2c72001c393ba$96184940$ What is exactly the mail merge???
-----Message d'origine----- You pourrais make the programme in Word et use le mail- merge.
"Eric" a écrit dans le message de
news:01f101c39339$fcd2d3c0$
hi everybody,
I am trying to fulfill some contract document, made from word documents with information I would get from Excel.
I am not talking of the publipostage option as this command should be done trhough the program I have created
from Excel in VBA.
For exemple : car rental contract from the windows on screen, developped in VBA, I want to print the data I have just input on a renting contract, which is a word document.
Do you have any idea about it.
cheers
Eric
.
publipostage!!!
"Eric" <anonymous@discussions.microsoft.com> a écrit dans le message de
news:2c72001c393ba$96184940$a601280a@phx.gbl...
What is exactly the mail merge???
-----Message d'origine-----
You pourrais make the programme in Word et use le mail-
merge.
"Eric" <anonymous@discussions.microsoft.com> a écrit dans
le message de
news:01f101c39339$fcd2d3c0$a301280a@phx.gbl...
hi everybody,
I am trying to fulfill some contract document, made from
word documents with information I would get from Excel.
I am not talking of the publipostage option as this
command should be done trhough the program I have
created
from Excel in VBA.
For exemple : car rental contract
from the windows on screen, developped in VBA, I want to
print the data I have just input on a renting contract,
which is a word document.
"Eric" a écrit dans le message de news:2c72001c393ba$96184940$ What is exactly the mail merge???
-----Message d'origine----- You pourrais make the programme in Word et use le mail- merge.
"Eric" a écrit dans le message de
news:01f101c39339$fcd2d3c0$
hi everybody,
I am trying to fulfill some contract document, made from word documents with information I would get from Excel.
I am not talking of the publipostage option as this command should be done trhough the program I have created
from Excel in VBA.
For exemple : car rental contract from the windows on screen, developped in VBA, I want to print the data I have just input on a renting contract, which is a word document.
Do you have any idea about it.
cheers
Eric
.
Eric
Merci Lydya, I will have a go
-----Message d'origine----- Hi Eric
This may give you an idea...
Sub WordFromExcel() Dim AppWord As Object Set AppWord = CreateObject("Word.Application") With AppWord .Visible = True 'creates a new Word document .documents.Add 'opens an existing document (change path) '.documents.Open FileName:="C:whatever.doc" .activedocument.PrintOut End With End Sub
You need to add the Microsoft Word Object Library to your Excel VBE (Tools /
References...) to access the VBA Word help.
Lydya
------------- "Eric" a écrit dans le message de
news:01f101c39339$fcd2d3c0$
hi everybody,
I am trying to fulfill some contract document, made from word documents with information I would get from Excel.
I am not talking of the publipostage option as this command should be done trhough the program I have created
from Excel in VBA.
For exemple : car rental contract from the windows on screen, developped in VBA, I want to print the data I have just input on a renting contract, which is a word document.
Do you have any idea about it.
cheers
Eric
.
Merci Lydya, I will have a go
-----Message d'origine-----
Hi Eric
This may give you an idea...
Sub WordFromExcel()
Dim AppWord As Object
Set AppWord = CreateObject("Word.Application")
With AppWord
.Visible = True
'creates a new Word document
.documents.Add
'opens an existing document (change path)
'.documents.Open FileName:="C:whatever.doc"
.activedocument.PrintOut
End With
End Sub
You need to add the Microsoft Word Object Library to your
Excel VBE (Tools /
References...) to access the VBA Word help.
Lydya
-------------
"Eric" <anonymous@discussions.microsoft.com> a écrit dans
le message de
news:01f101c39339$fcd2d3c0$a301280a@phx.gbl...
hi everybody,
I am trying to fulfill some contract document, made from
word documents with information I would get from Excel.
I am not talking of the publipostage option as this
command should be done trhough the program I have
created
from Excel in VBA.
For exemple : car rental contract
from the windows on screen, developped in VBA, I want to
print the data I have just input on a renting contract,
which is a word document.
Sub WordFromExcel() Dim AppWord As Object Set AppWord = CreateObject("Word.Application") With AppWord .Visible = True 'creates a new Word document .documents.Add 'opens an existing document (change path) '.documents.Open FileName:="C:whatever.doc" .activedocument.PrintOut End With End Sub
You need to add the Microsoft Word Object Library to your Excel VBE (Tools /
References...) to access the VBA Word help.
Lydya
------------- "Eric" a écrit dans le message de
news:01f101c39339$fcd2d3c0$
hi everybody,
I am trying to fulfill some contract document, made from word documents with information I would get from Excel.
I am not talking of the publipostage option as this command should be done trhough the program I have created
from Excel in VBA.
For exemple : car rental contract from the windows on screen, developped in VBA, I want to print the data I have just input on a renting contract, which is a word document.