Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access VBA
Access VBA Discuss using VBA for Access programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old May 29th, 2004, 03:58 AM
Authorized User
Join Date: Dec 2003
Posts: 13
Thanks: 0
Thanked 0 Times in 0 Posts
Default Access 97 and opening a Word document

Morning All,

I have an app where the database creates an 'info' doc in Word and saves it automatically in a specified directory using a unique name composed of the customer's name and ID.

I need some code to retrieve that document, i.e to simply open it in Word for editing. Any ideas would be greatly appreciated.


Old June 11th, 2004, 12:29 PM
Authorized User
Join Date: Apr 2004
Posts: 45
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to lguzman

    Dim stAppName As String
    Dim VFile As String

    VFile= whatever formula you use to create the file name

    stAppName = "C:\Program Files\Microsoft Office\Office\WINWORD.EXE " & VFile
    Call Shell(stAppName, 1)

Hope this helps.


Similar Threads
Thread Thread Starter Forum Replies Last Post
Opening word document read only in VB StevenVints VB How-To 1 May 3rd, 2006 09:52 AM
Print Word document from Access Form ppenn Access VBA 2 December 14th, 2005 07:51 AM
Opening a MS Word document from ASP saturdave Classic ASP Basics 0 May 25th, 2004 01:47 PM
Access 97 Benwaa Access VBA 0 January 28th, 2004 02:37 PM
Migrating from access 97 to access 2000 Khalifeh Access 12 October 2nd, 2003 02:54 PM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.