Thread: Loading excel
View Single Post
  #10   Report Post  
Mike R
 
Posts: n/a
Default

Jeff Thanks for the post

I placed or code and it did not work. Knowing very well that you are trying
to fit a problem that you can't see and you are only interpreting what I am
giving you, I think it is time to let you off the hook with a major THANK
YOU. There is something else happening here and I think I need to back up
(or out) and look at what is happening and possibly why. I will look at what
I have done, because it has to be there. I have other avenues of help that
might work. I would never discount your effort, but I do know you are
working blind Thanks again so much for your time and effort.

Mike R.

"Jeff" wrote:

Mike, I am not sure what is different in your environment ... removing
the /e from the XLS file association worked for me (unless I had
another Workbook in the XLSTART file which also auto-starts, in which
case it does not create book1.xls). A couple of other things you might
check are in your Personal.xls file, did you look in the "ThisWorkbook"
module for a Workbook_Open procedure that might be affecting this?
Although, I would have thought any such would have behaved the same on
both your PC & laptop ...). Also, if you have any add-ins that load
when starting Excel ... perhaps something there is affecting this? At
any rate,
if you copy the following code to the "ThisWorkbook" module of your
Personal.xls file, this will open it for you when starting Excel:

Sub Workbook_Open()

On Error Resume Next

Workbooks("Book1.Xls").Activate

If Err < 0 Then

Workbooks.Add

' Or if you want to base the new workbook on a template, delete the
"Workbooks.Add"
'above and uncomment the following line (substitute the correct
path to your xlt file):

'Workbooks.Open filename:=C:\Documents and
Settings\username\Application Data\Microsoft\Excel\XLSTART\Book.XLT"

End

End If

On Error GoTo 0

End Sub

HTH,

Jeff