Word Document Not Opening With Excel VBA

JennEx · #1 06-18-2013, 04:53 PM

Hope this question is OK here ... it was a toss up between Excel and Word VBA ...

I am using this Excel VBA code to open up a word document (H:/Sun/Ps/Doop/Stes/Turtle/Tue 18-Jun-13/DR_WPE1(14).docx) from excel :

Code:

Set wordapp = CreateObject("word.Application")
wordapp.documents.Open "H:/Sun/Ps/Doop/Stes/Turtle/" & waxon & "/" & flname & "/.docx" 
wordapp.Visible = True

Waxon is a folder name ... Tue 18-Jun-13, and flname = DR_WPE1(14)

The problem .. although Word (the application)opens, there is no document.

DepricatedZero · #2 06-20-2013, 05:25 AM

I use "Dim wordApp as Word.Application" rather than "Set wordApp = CreateObject("word.Application")"

May need to add an appropriate reference to do so, I'd give that a try and see if it helps?

JennEx · #3 06-20-2013, 10:09 AM

Thanks for the suggestion Depricated ...

Turns out it was a simple spelling mistake. "/.docx", should be just ".docx".

DepricatedZero · #4 06-20-2013, 10:10 AM

I completely overlooked that hah

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Need help opening my important word document	HenrikSandstrom	Word	1	12-03-2012 03:52 PM
Problem opening second Word document	bTaryag	Word	1	08-02-2011 02:48 PM
Get just grey box when opening Excel Document 2010	sebbero	Excel	1	11-10-2010 04:24 AM
Word document not opening	7beats	Word	2	04-16-2010 12:40 AM
Opening word document problem	SPARKY77	Word	4	11-02-2009 01:34 AM