Everytime i turn on my computer, i have to open several openoffice or excel documents. So i would need to open on each of those one at a time etc. Is there a way to open excel where the moment i click on openoffice or excel, it opens up these documents all at once? Thus so i do not need to manually open on each one as i have to click on start menu, then type in the document? Because i have to open about 5 of them each time i start up… its the same openoffice and/or excel documents.
I’d think the easiest thing to do (which would not open those documents on occasions where you didn’t wish to) would be to create a dummy worksheet which had a macro in it that opened the files. In the macro, I’d think you’d have to type the file names because the mouse movements might not be the same, but I’m not sure how Open Office interprets mouse movements in Macros.
Give the macro a start key sequence like Ctl-U hat you don’t otherwise use and put the spreadsheet itself on your desktop. Then when you turn on the computer, you double click on the spreadsheet and enter Ctl-U
For Win 7, 8, 10 try this:
Highlight the document you want to see at start up
<ctrl> C to copy it to clipboard
<windows key> R
type shell:startup
in the folder that opens up , right click and select Paste Shortcut
Hope this helps, although I just put shortcuts to frequently used docs on the Desktop
Messing with macros is definitely the hard way.
As to Excel just follow the pattern shown here: http://boards.straightdope.com/sdmb/showthread.php?t=833300, but substitute Excel for Chrome and the filenames of your spreadsheets for the urls of your sites.
You’ll need to be able to specify the complete path to Excel and the complete path to each of your files. So the final shortcut will look something like
C:\Program Files\Microsoft Office\Office 14\Excel.exe "C:\Users\George\Documents\Project1\SpreadsheetA.xlsx" "C:\Users\George\Documents\Project2\SpreadsheetB.xlsx" "C:\Users\George\Documents\Project3\SpreadsheetC.xlsx"
The result of this will be a single shortcut that, when clicked, will open all your spreadsheets.
If you want to make that happen automatically every time on boot-up, which is a very very *very ***BAD **idea, then follow Baron Greenback’s advice to move the shortcut into shell:startup. But when that destroys all your work don’t come crying to me. I warned you.
OpenOffice may or may not be able to open multiple documents off one command using the same syntax. Try it and see. Or read the documentation.
FYI, it’s also helpful if you mention which kind of computer, OS, & versions you’re using. It turns out that for Excel on a PC under Windows this pattern works from Win95 through to Win10 and for Excel 95 through to Office 16. But you didn’t know that before you asked.
In Excel you can just put all the files in one folder and have Excel open them all on startup. It’s in Options. Excel 2010 it’s in File - Options - Advanced - General
- At startup, open all files in:
That bad, huh? :o Sorry OP!
Why would opening a fixed series of Excel files on Windows startup destroy any work?
It’s probably not what the asker wants (I think they want the files open on startup of Excel specifically), but I don’t see how it’d be so dangerous. Annoying, perhaps.
Why do you think telling Excel to open a few files on login (pedantic nitpick: the folder is called “Startup” but it actually opens the documents on login, which is different) would cause work to be destroyed?
My thought is that there’s a good opportunity for problems during repeated reboots for updates.
There’s also the issue that assume the machine crashes once and now we have auto-recovered versions of these files. The next time the machine fires up it opens the usual batch of autorecovers. That UI is confusing enough without having to deal with several at once. Now the machine wants to shut down again for whatever reason and the autorecovers have been opened and perhaps modified by the presence of a NOW() or TODAY() function.
Either the shutdown hangs for lack of “OK to close” inputs, or perhaps the autorecovers get lost and the user is stuck going back to earlier backups.
In all, the risk is not large, but the underlying problem is that there are more kinds of boot-ups than the typical “I show up at work and turn my PC on”. The OP was thinking only of the vanilla situation. Not all plausible situations. And he’s only saving one mouse-click by embedding the “start Excel & open several files” shortcut into his boot or login script.
All in all that seems a poor risk/reward to me. Said another way, it’ll be fine for a great many days. Until one fine day it isn’t.
If an update is doing repeated reboots, it’s not going to bother to log in any user inbetween those reboots. Since the “open on startup” folder is actually an “open on login” folder, the documents will never be opened in this case.
Well, but how does that differ from having files open that aren’t opened on login? I see the concern, but I don’t see how it differs from status quo.
I’m not convinced.
As you say, it may be belt and suspenders. Or I may be rehashing concerns that were valid a few generations of software ago.