Open Excel 2007 Workbook by Scheduled Task on Server 2008R2

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?
LVL 1
fireguy1125Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Don ThomsonCommented:
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.
R. Andrew KoffronownerCommented:
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.
fireguy1125Author Commented:
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.
Become a CompTIA Certified Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

R. Andrew KoffronownerCommented:
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.
fireguy1125Author Commented:
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.
R. Andrew KoffronownerCommented:
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.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Windows Server 2008

From novice to tech pro — start learning today.