Auto save problems with a Excel Dashboard over a mounted share directory.

mieko1970

New Member
Joined
Mar 20, 2019
Messages
1
I hope somebody can be of assistance as i am rather lost.

My issue is the following.

The company is deploying a custom excel dashboard to access file shares and incorporate several quote forms that the user can fill and save the information.

The xlsx dashboard and fileshare directory is stored on a separate fileserver and the shared drives are mounted on each user's computer via network share.

Therefore each user has access to the dashboard .xlsx and the file directories.

Users can access the varied directories through the links provided on the dashboard and those directories will pop up.

If a admin accessed the fileserver directly and interacts with the dashboard where it originally saved - that user has no issues using the forms portion of the
dashboard as it's in it's native saved directory.



The problem is when a networked user goes to enter data into one of the forms attempts to save it, they're greeted with this error:

Run Time Error '1004'

"The file name or path does not exist"


The creator of this dashboard is not being very cooperative and i'm tasked to just make it work.

He sent me a example of the Sub SvMe macro that he used and the file path incorporates a local file path.

Is the a way to incorporate a network file path into the macro is it's the only thing that is making any sense to me right now.




Any assistance would be greatly appreacted.

Thanks,
Mieko




AF1QipNNYHlvf2EfrPKbTewpDxJ2qHUjIJOHubMCc8fM


AF1QipNNYHlvf2EfrPKbTewpDxJ2qHUjIJOHubMCc8fM
 

Excel Facts

Easy bullets in Excel
If you have a numeric keypad, press Alt+7 on numeric keypad to type a bullet in Excel.

Forum statistics

Threads
1,224,823
Messages
6,181,181
Members
453,021
Latest member
Justyna P

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top