Windows Scheduler – Process Excel when user not logged in

Problem:

Recently we came across one of the scheduling issue reported by a client. He is having an executable (exe) which process an excel file, create tables in database, populate values to the database and generate log files (csv). When we scheduled the exe execution using Windows Scheduler it works fine. But, when we marked the task to execute when the user is not logged into the system, the task fails to process the excel files.

Solution:

After lot of analysis we have fixed the issue with a simple solution. Create one folder called “Desktop” under the following paths
C:\Windows\System32\config\systemprofile
c:\windows\syswow64\config\systemprofile

Note:- Depends on 32-bit or 64-bit, we can create the folder under the respective folder.

When the user is not logged into the system, system uses the specified path as temporary location to process the excel (may be office) files.

Advertisements

About ambilykk

I am a Technology Evangelist on Microsoft Technologies. I am carrying the passion on Microsoft technologies specifically on web technologies such as ASP .Net and Ajax. My interests also include Azure and Visual Studio. Technology adoption and learning is my key strength and technology sharing is my passion.
This entry was posted in General and tagged , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s