Creating a Word Document in vba from an Access Function

Guessed · #1 05-12-2020, 04:03 PM

Don't use a selection object for this. Assuming there is no initial content in the new doc you could remove those pesky .Selection lines and replace it with

.Range.Text = "Station Name" & vbCr & "Programme Number" & vbCr & "Programme Date" & vbCr

jcc285 · #2 05-13-2020, 01:19 AM

Thank you for your reply. I have tried this route before however when the Document is produced the text moves to the bottom of the page. I guess I need to do 'something' to position the table on the page but I have no idea what?

I've attached an image of the current result having replaced the .selection coding with:-

Code:

With oWordDoc
  .PageSetup.Orientation = wdOrientLandscape
  .Range.Text = "Station Name" & vbCr & "Programme Number" & vbCr & "Programme                      Date" & vbCr
End With

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to Open a Word Document from ACCESS VBA	PosseJohn	Word VBA	3	12-06-2013 04:33 PM
Creating a graph for Future Value function (FV function)	bmoody	Excel	2	11-06-2013 10:52 AM
importing Access data to a Word document	WayneCusack	Word VBA	2	12-24-2012 12:26 AM
Access to Word, Creating a list from multiple records	daymaker	Mail Merge	9	03-14-2012 06:37 AM
Protecting Word Document by restricting access permissions!	user	Word	0	11-20-2008 01:21 PM