Runtime error "Remote Call Procedure Failed"

macropod · #1 03-13-2020, 01:45 AM

Try changing that line to:

Set xlWkBk = .Workbooks.Open(StrWkBkNm, False, True)

pushpi004 · #2 03-13-2020, 01:55 AM

Quote:

Originally Posted by macropod

Try changing that line to:
Set xlWkBk = .Workbooks.Open(StrWkBkNm, False, True)

I have tried that already..doesn't work..the only way the code works is when I keep the Excel session visible, i.e. .visible=true

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
"Floating" Text (Don't know what else to call it)	shawn.low@cox.net	Word	0	05-31-2019 09:59 AM
How to call up "Recovered Files" on demand	slavrenz	Office	7	10-16-2015 05:57 PM
Error: "Changes made were lost...reconnect with server", when switching "from" field	randhurrle	Outlook	2	02-25-2015 06:51 PM
Execution error 2147023170 - Failure call of distant procedure - POWERPOINT 2013	fidecourt	PowerPoint	2	02-26-2013 10:25 AM
Microsoft Office 2010 programs display error message "Application has failed to start	SamSR	Office	1	02-15-2011 07:15 AM