Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 305 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 260 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Classic 2009SP1 Job Queue Saveas problem: SaveAs method of workbook class failed
rocopsa
Member Posts: 38
Dear Experts,
I know that this is a very old issue that has been discussed for long. Yet, I cannot find the answer eventhough I used the whole afternoon to read the forum and other sites.
Actually, I am using Job Queue to auto load some reports to a specific folder on the DB server. I used Codeunit to do so and everything is fine as if I execute it manually.
However, when I place the codeunit to Job Queue, I observe that Excel has been successfully executed in task manager, seems data loading is also fine. But, the final stage of SaveAs stucks and finally Job Queue Entry Log says "SaveAs method of workbook class failed".
Honestly I did not expected such problem and my schedule of submission is very near, could anyone knows the solution please kindly tell me?!!!!
Thanks a lot in advance!
Louisa
I know that this is a very old issue that has been discussed for long. Yet, I cannot find the answer eventhough I used the whole afternoon to read the forum and other sites.
Actually, I am using Job Queue to auto load some reports to a specific folder on the DB server. I used Codeunit to do so and everything is fine as if I execute it manually.
However, when I place the codeunit to Job Queue, I observe that Excel has been successfully executed in task manager, seems data loading is also fine. But, the final stage of SaveAs stucks and finally Job Queue Entry Log says "SaveAs method of workbook class failed".
Honestly I did not expected such problem and my schedule of submission is very near, could anyone knows the solution please kindly tell me?!!!!
Thanks a lot in advance!
Louisa
0
Best Answer
-
rocopsa
Member Posts: 38
Solution found!!!
Just simple add a folder named Desktop to the following path of your machine, problem solved!!!
For 64 bit environments the folder path is:
C:\Windows\SysWOW64\config\systemprofile\Desktop
For 32 bit it is:
C:\Windows\System32\config\systemprofile\Desktop
For details, pls browse below:
http://www.jigsaw.com.au/blog/2013/october/18/dynamics-nav-nasjob-queue-excel-saveas-method-failed.aspx
Hope it helps to those who encounters same problem!0
Answers
Just simple add a folder named Desktop to the following path of your machine, problem solved!!!
For 64 bit environments the folder path is:
C:\Windows\SysWOW64\config\systemprofile\Desktop
For 32 bit it is:
C:\Windows\System32\config\systemprofile\Desktop
For details, pls browse below:
http://www.jigsaw.com.au/blog/2013/october/18/dynamics-nav-nasjob-queue-excel-saveas-method-failed.aspx
Hope it helps to those who encounters same problem!