starting a spreadsheet at machine boot

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

agwat

Thread Starter
Joined
Feb 6, 2003
Messages
8
I would like to know how to start a spreadsheet from boot-up. The spreadsheet I would like to start has macros, when I place it in the startup menu I get an error "An error occured initializing the VBA libraries (14)", thus the spreadsheet doesn't operate properly. Also, I get the message that "cannot use object linking and embedding".

I would really like to auto-start the particular spreadsheet, if anyone has a solution I would really appreciate it.

Agwat
 

Anne Troy

Anne
Joined
Feb 14, 1999
Messages
11,749
YOu should be able to put it in the startup, but I also suggest:

In Excel, go to Tools-Macros-Security and make sure that you've got it set to Low, and try again.
 

agwat

Thread Starter
Joined
Feb 6, 2003
Messages
8
thanks...I have made the macro security low...but the error persists...agwat. It's like the machine isn't ready to run the app when it tries to open it.

agwat
 

Anne Troy

Anne
Joined
Feb 14, 1999
Messages
11,749
No problem.

You're aware that a line in the code that automatically runs is attempting to find a file, right?

This line:

RetVal = Shell("C:\WINWEDGE\WINWEDGE.EXE C:\WINWEDGE\excel.SW3", 4)

Of course, I get the error that it cannot find it.

What I'm thinking is this:

Instead of putting THIS file in the startup, why don't you just put Excel in the startup, right? And then in Excel's personal.xls file, you could place a timer that, say....10 seconds after startup, it launches the Excel file, which launches the autorun...etc.??
 

agwat

Thread Starter
Joined
Feb 6, 2003
Messages
8
good Idea...yes I am aware that it is launching another app...it is opening an exe that is parsing ascii serial data and then writing it to the spreadsheet.

what is personal.exe?

agwat
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Staff online

Top