Resolution Try this Regards, Try to change the directory path and run the macro where you have access. Mandeep baluja
Examine the path of the WebDir and DBDir folders. To do this, log into Forecaster by using the SYS user and then clicking the company link. Both the WebDir and the DBDir folders should be on the IIS Server. The WebDir folder should have the following path: \\MACHINENAME\WEBDIR\ The DbDir folder should have the following path: \\MACHINENAME\DBDIR\ If there are multiple companies, set up separate WebDir and DBDir folders for each company. Companies should not share these folders. You should also enable Web sharing for the WebDir folder, and set the read and write permissions for the folder. To do this, follow these steps: 1. In Windows Explorer, right-click the WebDir folder, and then click Sharing and Security. The Properties dialog box opens. 2. Click the Sharing tab. 3. Click to select the Share this Folder option, and then click Permissions. 4. In the Group or user names box, click the target user group. 5. In the Permissions box, click the appropriate check box to enable or to deny each permission. Then click OK. 6. Click the Web Sharing tab. 7. Click to select theShare this Folder option. 8. Repeat steps 4 and 5 on this tab. Note The DBDir folder should be shared with full control permissions enabled for the frxforecaster user. This article was TechKnowledge Document ID: 27775 -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at https://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
