0

I am having a difficulties to find the way on how to open the file in LiveLink using VBA in Excel. I know the folder where its placed and I know the name of the file; is there any straightforward way to perform this please?

Many thanks in advance,

Michal

user2784432
  • 1
  • 1
  • What kind of file? You *should* be able to use the webdav path to open the file (assuming you mean you want to open an excel file in Excel...) Path will be something like `WorkBook.Open "http://yourLLserver/livelinkdav/folder1/folder2/ExcelFileName.xls"` – Tim Williams Sep 16 '13 at 15:59
  • I meant `WorkBooks.Open` of course... – Tim Williams Sep 16 '13 at 23:58
  • Many thanks Tim, exactly what I was looking for! I couldn't figure out, how to specify the file/folder not based on the object number. It can be any kind of file, but I'd expect this should work in any case, right? – user2784432 Sep 17 '13 at 16:22

1 Answers1

0

Use the Shell function - see here for more info. Also, see the VBA info on this function here.

Community
  • 1
  • 1
Aaron Thomas
  • 5,054
  • 8
  • 43
  • 89