Please register or login. There are 0 registered and 1428 anonymous users currently online. Current bandwidth usage: 326.30 kbit/s December 17 - 10:19pm EST 
Hardware Analysis
      
Forums Product Prices
  Contents 
 
 

  Latest Topics 
 

More >>
 

    
 
 

  You Are Here: 
 
/ Forums / Programming /
 

  Auto run excel spreadsheet possible? 
 
 Author 
 Date Written 
 Tools 
David Gander Sep 26, 2008, 06:13am EDT Reply - Quote - Report Abuse
Private Message - Add to Buddy List Replies: 6 - Views: 12105
Hi,

I was wondering if it possible to make a spreadsheet pop up automatically once logged on to a machine on a network without making it happen through some sort of server process? Just something you can program each machine to do? Basically there will be a excel spreadhseet that contains new info everyday and needs to automatically pop up when each individual person logs onto a computer? Is this possible?

cheers


Want to enjoy fewer advertisements and more features? Click here to become a Hardware Analysis registered user.
Rhort Sep 26, 2008, 06:52am EDT Reply - Quote - Report Abuse
Private Message - Add to Buddy List  
>> .
Yes.

Start by creating a folder, and copying the spreadsheet that you want to appear at startup in it (this can be a network folder if you like, as long as the users all have access to it).

Secondly, configure each of the users' Excel to open files in this folder whenever Excel Starts. Do this via Tools > Options > General > At Startup, open all files in > [folder name goes here]

Thirdly, add a link to Excel in the startup folder (Start > [All] Programs > Startup).

_________________________________________________________________________________
~ The manual said "Requires Windows '95 or better" ...so I installed Linux!
David Gander Sep 26, 2008, 07:49am EDT Reply - Quote - Report Abuse
Private Message - Add to Buddy List  
>> Re: Auto run excel spreadsheet possible?
Thats excellent seems to have done the trick...thanky you very much.

Another q if youve got the time....not all users have access to microsoft excel and have the free alternative openoffice calc instead? Im trying to find the same options to set it up as above, but having no luck..any ideas?

Your help is greatly appreciated.

Rhort Sep 26, 2008, 09:45am EDT Reply - Quote - Report Abuse
Private Message - Add to Buddy List  
>> .
Sure.

Again, place the shortcut for Calc in the Startup folder, then, right click on the shortcut and select Properties, then add the following at the far right of the Target box:

-o "<<FULL PATH TO SPREADSHEET HERE>>"

so that the whole thing reads something like this:

"C:\Program Files\OpenOffice.org 2.4\program\scalc.exe" -o "S:\Accounts\Finance Reports\September2008.xls"

_________________________________________________________________________________
~ The manual said "Requires Windows '95 or better" ...so I installed Linux!
David Gander Sep 26, 2008, 11:51am EDT Reply - Quote - Report Abuse
Private Message - Add to Buddy List  
>> Re: Auto run excel spreadsheet possible?
Hey,

Thanks again for your help.

I cant seem to get the -o (open code) part of this to work...obv im still getting the program opening on startup but its not opening the file or attempting to..Ive tried it on various OS and I also tried it with adobe and to open a PDF but its not working..any other code I could try?

Cheers!

habs fan Sep 27, 2008, 01:13am EDT Reply - Quote - Report Abuse
Private Message - Add to Buddy List  
>> Re: Auto run excel spreadsheet possible?
Why not just create a shortcut to the file in question and add that shortcut to the startup folder. It will open the file with whatever application is the default for that file type.

FordGT90Concept Sep 27, 2008, 02:27am EDT Reply - Quote - Report Abuse
Private Message - Add to Buddy List

Edited: Sep 27, 2008, 02:28am EDT

 
>> Re: Auto run excel spreadsheet possible?
habs fan said:
Why not just create a shortcut to the file in question and add that shortcut to the startup folder. It will open the file with whatever application is the default for that file type.

I second that. If it doesn't work, copy the link to Microsoft Excel and change the "Target" to have the full path to the XLS in quotes after it. For example:

"C:\Program Files\Microsoft Office\OFFICE11\EXCEL.EXE" "\\NETWORK\MyFiles\spreadsheet.xls"

"Start In" should be (given the above example):
"C:\Program Files\Microsoft Office\OFFICE11"

________________________
If I remember what I forgot, I have not forgotten it.

Write a Reply >>


 

    
 
 

  Topic Tools 
 
RSS UpdatesRSS Updates
 

  Related Articles 
 
 

  Newsletter 
 
A weekly newsletter featuring an editorial and a roundup of the latest articles, news and other interesting topics.

Please enter your email address below and click Subscribe.