Jump to content

Runs on Shared Ổ - Excel Macro

Recommended Posts


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


Share this post

Link to post
Share on other sites

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.