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
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
