docsrc.close not working

kateabode · #1 10-14-2018, 06:00 PM

I'm trying to close the docsrc at the end of the code which pulls data from an external document upon clicking a button.

I've tried this which I got from another website but changed it from ActiveDocument to DocSrc.

Code:

With DocSrc.Close _
 SaveChanges:=False, _
 OriginalFormat:=False
End With

Any help would be greatly appreciated.

Guessed · #2 10-14-2018, 06:34 PM

Get rid of the With and End With. It should just read as

Code:

DocSrc.Close SaveChanges:=False

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
Userform close after use	Mikedk64	Excel Programming	3	09-21-2017 02:35 AM
Auto_open & Close	gacartwright	Excel Programming	0	07-29-2015 03:53 PM
Message Box on Close	thedeadzeds	Word VBA	1	05-10-2013 03:54 PM
Close 'downloads' window with VBA	CatMan	Excel Programming	6	12-14-2012 01:34 PM
Is there an exit on close ?	mhdadmh	Word	0	10-12-2006 04:28 PM