excel - Opening a workbook from an http file path -


forgive me mistakes it's first time posting question.

i'm trying open workbook vba located on company's intranet. i've used same strategy before file path. when use code below a:

"run-time error '424':
object required"

sub openworkbook()      dim filename string      filename = range("af10").value      workbook.open (filename)  end sub 

cell af10 contains text string "http:// intranet/...\filename.xlsm"

i'm not tied of functions, i'm new , wasn't able find better online.

beside backslash, shouldn't workbooks.open filename?


Comments

Popular posts from this blog

c# - Send Image in Json : 400 Bad request -

jquery - Fancybox - apply a function to several elements -

An easy way to program an Android keyboard layout app -