Hi all,

What I am trying to do is to open an Excel file in a macro but using a
shortcut.

The following code works:
Workbooks.Open("FileName.xls)

The following code does not work:

WorkBooks.Open("FileNameShortcut")
Nor
WorkBooks.Open("FileNameShortcut.xls")

I do have th same problem with the FileSearch function.

Any Idea on how to perform taht ?

Thanks,
nde

Try using the shell command with the shortcut name (.lnk extension).

--
Regards,
Tom Ogilvy


"nde" wrote:

Hi all,

What I am trying to do is to open an Excel file in a macro but using a
shortcut.

The following code works:
Workbooks.Open("FileName.xls)

The following code does not work:

WorkBooks.Open("FileNameShortcut")
Nor
WorkBooks.Open("FileNameShortcut.xls")

I do have th same problem with the FileSearch function.

Any Idea on how to perform taht ?

Thanks,
nde

Worked perferctly with the lnk extension.

Thanks a lot, you made my day !

Nde

"Tom Ogilvy" wrote:

Try using the shell command with the shortcut name (.lnk extension).

--
Regards,
Tom Ogilvy


"nde" wrote:

Hi all,

What I am trying to do is to open an Excel file in a macro but using a
shortcut.

The following code works:
Workbooks.Open("FileName.xls)

The following code does not work:

WorkBooks.Open("FileNameShortcut")
Nor
WorkBooks.Open("FileNameShortcut.xls")

I do have th same problem with the FileSearch function.

Any Idea on how to perform taht ?

Thanks,
nde