Microsoft Office Forums - View Single Post - [Solved] Runtime error "Remote Call Procedure Failed"

Thread: [Solved] Runtime error "Remote Call Procedure Failed"

View Single Post

Old

03-13-2020, 01:55 AM

pushpi004

pushpi004 is offline

pushpi004 uses Windows 10

Windows 10 pushpi004 uses Office 2016

pushpi004 uses Office 2016

Office 2016

Novice

The original poster

Join Date: Feb 2020

Posts: 21

pushpi004 is on a distinguished road

Default

Quote:

Originally Posted by macropod

View Post

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

Reply With Quote