I wrote (with mvp help, of course ;- }) a small app that I have now
installed on my work computer, which is on a network.
The IT guy set a path to drive P for me and that is where all my files and
app are located.
But my app throws an error that it cannot find the worksheets I am
requesting - so I moved all to drive C and lo and behold, I get the same
error.
Not sure I am asking this question in the right forum, just thought maybe
someone has run into this before and can give me a hint or two how to fix
it.
All help, as always, is much appreciated.
Joanne

Try this
\\ServerName\PathtoFolfer\Book1.xls

"Joanne" wrote:

I wrote (with mvp help, of course ;- }) a small app that I have now
installed on my work computer, which is on a network.
The IT guy set a path to drive P for me and that is where all my files and
app are located.
But my app throws an error that it cannot find the worksheets I am
requesting - so I moved all to drive C and lo and behold, I get the same
error.
Not sure I am asking this question in the right forum, just thought maybe
someone has run into this before and can give me a hint or two how to fix
it.
All help, as always, is much appreciated.
Joanne

In your code there must be a hardcoded reference to your computer, you can
change that by using the following syntax:
\\servername\Folder\Subfolder\youfile.xls

Note that you need double slash when using a server name.
--
If this posting was helpful, please click on the Yes button.
Regards,

Michael Arch.




"Joanne" wrote:

I wrote (with mvp help, of course ;- }) a small app that I have now
installed on my work computer, which is on a network.
The IT guy set a path to drive P for me and that is where all my files and
app are located.
But my app throws an error that it cannot find the worksheets I am
requesting - so I moved all to drive C and lo and behold, I get the same
error.
Not sure I am asking this question in the right forum, just thought maybe
someone has run into this before and can give me a hint or two how to fix
it.
All help, as always, is much appreciated.
Joanne

Thank you all so much - I was not pointing to the server in my path. I'm
sure I will be good to go now.

Joanne wrote:

I wrote (with mvp help, of course ;- }) a small app that I have now
installed on my work computer, which is on a network.
The IT guy set a path to drive P for me and that is where all my files and
app are located.
But my app throws an error that it cannot find the worksheets I am
requesting - so I moved all to drive C and lo and behold, I get the same
error.
Not sure I am asking this question in the right forum, just thought maybe
someone has run into this before and can give me a hint or two how to fix
it.
All help, as always, is much appreciated.
Joanne