Jump to content
RosemaryWilkins

Runs on Shared Ổ - Excel Macro

Recommended Posts

RosemaryWilkins

Need help creating a script to locate and open an excel file on a shared drive and then run a basic macro attached to the file. I can finish if the file is local, but can not figure out how to locate the script when it's on the network share drive. I keep getting errors that the files could not be found.

The Excel file is located at the following location:

O: //Appearance/Scorecard/Scorecard.XLSM

https://www.google.com.vn/

Share this post


Link to post
Share on other sites
Subz

So you mean a drive mapped to O:?  Wouldn't your path be O:\Appearance\Scorecard\Scorecard.xlsm?

Can't you just use the UNC path for example \\ServerName\Share\Appearance\Scorecard\Scorecard.xlsm?

Edited by Subz

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.