Solved

Open Excel 2007 Workbook by Scheduled Task on Server 2008R2

Posted on 2013-12-30
6
1,007 Views
Last Modified: 2013-12-30
I want to be able to open an xls file automatically on a scheduled basis without being logged in.  Is this possible using scheduled tasks? If so, what parameters would I need to use to in order to achieve this?
0
Comment
Question by:fireguy1125
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
6 Comments
 
LVL 14

Expert Comment

by:Don Thomson
ID: 39746372
You should be able to - The actual command would have to be something like
excel  filename.xls   - The excel.exe must be in the path or you will need to show the path   (i.e. C:\Program Files (x86)\Microsoft Office\OFFICE11\Excel.exe

I'm assuming that you need to open it so it can update from other data sources on an automated basis, then save and close again.
0
 
LVL 16

Expert Comment

by:R. Andrew Koffron
ID: 39746492
wouldn't it be better to pipe text into a txt file than import it when you are logged in?

there's a lot of automation tools. but all i've tried are prone to errors or not grabbing the info I'd like to collect properly.

echo <text you want to send> >> <c:\folder\fileyouwantappended.txt>

>> adds to last line in a txt file
> re-writes the file.

Maybe I'm missing something, but I can't see the point of opening an excel file while not logged in. unless there's some other process that's going to use/add data etc...

just my knee jerk reaction, but I'd look for a more programatic method of capturing the end goal, without relying on excel when you're not logged in.
0
 
LVL 1

Author Comment

by:fireguy1125
ID: 39746507
Thanks, I put this in a batch file, and it runs successfully, however when I make it a scheduled task, it shows the operation completed successfully, but it did not.
0
Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

 
LVL 16

Expert Comment

by:R. Andrew Koffron
ID: 39746562
if your not logged in how would you know?
is the excel collecting data, or writing data. or do you just want it open someplace?
I don't understand the goal. if there are no users logged on I don't think excel is going to do anything or even actually open, as it's an application that interacts with the user environment. so might work if the user space is logged in and locked, but if "no one" is able to interact what could it do?

I've not tried this so I'm not saying it's impossible, but it doesn't make sense to me.
sorta like asking why a car won't fly.
0
 
LVL 1

Author Comment

by:fireguy1125
ID: 39746568
When i test the scheduled task, it is doing it while logged in.

The file is a simple batch file that just has the path to an xls file.

The xls file has a Macro in it that runs and modifies the file, then saves it as a different file name in the same directory.
0
 
LVL 16

Accepted Solution

by:
R. Andrew Koffron earned 500 total points
ID: 39746586
try it with the user account locked, instead of logged out.

I just don't think excel can run as a service.

you might try macking a vbs macro based on the what's in excel that should be able to run on it's own.
0

Featured Post

Salesforce Made Easy to Use

On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article explains how to install and use the NTBackup utility that comes with Windows Server.
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

707 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question