Can't start Excel!

R

rede96

Wonder if anyone can solve this for me please?

I was looking in Excel for the method to change the current director
when opening a file using VBA. (E.g to use “D:\MyDatabases\Claims” a
the default path.)

I tried a few bits of code (Which I can’t remember!) until I found th
right one. (‘ChDir’)

However, whatever other code I messed about with now has done somethin
to Excel! When I try and start Excel I get the message below. If
press ok, Excel tries to open up what ever files are in that directory
Whatever type they are. (Which is why I get the message below as I a
assuming it is trying to open a database in that is in that folder.

I can get around this issue by renaming the folder that I wa
originally trying to point to. (E.G. change “D:\MyDatabases\Claims” t
“D:\MyDatabases\MyClaims”)

When I do this Excel starts normally. However as soon as I change th
folder name back, I get the problem back.

I’ve been able to isolate the issue to the “Claims“ folder. If I renam
that folder or remove all files from that folder, then Excel start u
normally. Also, whatever Excel file I put in that folder will ope
automatically when I start Excel.


Can anyone help me get back to normality please?

Thanks

Attachment filename: message.jpg
Download attachment: http://www.excelforum.com/attachment.php?postid=50362
 
F

Frank Kabel

Hi
goto 'tools - Options - General' and change your starting folder in the
lower area of this dialog
 
R

rede96

Hi Frank,

I only wish it were as simple as changing the default start u
directory! I'm afraid that's not the problem. If I do change it, Exce
just tries to open up whatever files are in the directory it i
pointing to.

It's actually trying to import every file in whatever start u
directory it is pointing to. The only way to get it to open normally i
to point it to an empty directory.

The only thing I've done is mess about with some VBA code that I didn'
really know what it did. If I could remember the code that might o
been a help. I guess you learn by you mistakes!

I'll try and re-install Excel.

Thanks anyway
 
F

Frank Kabel

Hi
just delete this parameter in the Options file or create a separate
startup directory for Excel, set the parameter to this directory and
leave this directory empty
 
Top