MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Personal Workbook corrupted

  Asked By: Maya    Date: Sep 12    Category: MS Office    Views: 2378

I created a form in a module in the Personal Workbook.
I think I named a click button the same name as a
procedure in the Personal Workbook. When you first
click the form in question you get an error message
that says "module not found" but you can see it in the
project window. The second time you click it the form
comes up. If you click any of the buttons on the form
you get a blank code window. it is completely blank
with no declaration or clicks at the top. You can't
type on it or anythin. When you click save it says
"document not saved". Then it highlights a worksheet.
When I compile the project is says "invalid procedure
call" but it doesn't stop on any line to tell me where
the problem is. All the macros worked so it doesn't
appear to be a problem in the macros.

Any ideas how to get my personal workbook back? I
copied all the macros in the only module and saved
them to a new module. I deleted this module. It
still won't let me save the Personal workbook. I
removed the form also. It sill won't let me save the
personal workbook. Is there a way to remove the
worksheet object in the personal workbook? I don't
know why I think it is that object because when I try
to save the personal workbook it highlights the
worksheet object and then says "cannot save document".

Is my only option to reinstall Excel?



4 Answers Found

Answer #1    Answered By: Fahmida Ahmed     Answered On: Sep 12

can you copy everything you want to a new wkbk then close excel  and delete
personal.xls. Then open the one you copied the stuff to and save  it as

Answer #2    Answered By: Vidhya Iyer     Answered On: Sep 12

I am at home so I can't try deleting it
until Tuesday but I changed the name of the workbook
that works to personal.xls. I am at home I now have my
personal workbook.

I don't understand how that is different from using
any other workbook  name? Right now it is a blank
workbook that stores the project  I am working on and
it has to be open to run these macros  but am running
them on another spreadsheet report that has to be
doctored up each week. This other report I need to
save as a text file for input to Indesign via a
plug-in. Every week! I have that spreadsheet as the
active one (open on top) .

The problem  came about when I have the project
workbook open (now named  personal.xls) that it saves
itself, the project file (personal.xls) as text NOT
the spreadsheet report I want to save  as text. Then
it crashes itself , most of the time, it gives this
weird message and then sometimes it saves itself as a
text file which is totally wrong. I want my personal
workbook to save the macros I use each week.

The value 19 is supposed to be a Mac text file. I
tried putting the application display alert sign in
there to get it to bypass the alert.
This alert step doens't work at all so there is
something wrong with the path or the code. Someone
told me this error  doens't happen on a PC.
----error message-----
"run-time error '1004' The file could not be
accessed. try one of the following:
make sure the specified folder exists. make sure the
folder is not read only....."


Sub saveIndesign()
'Appends date to filename so as to not write over an
existing file

' saveIndesign Macro

Const fPath As String = "Mac OS X:Desktop: "
Dim fName As String
Dim myFileName As String
myFileName = Left(ActiveWorkbook.Name,
Len(ActiveWorkbook.Name) - 4) & Format(Now,
"yyyymmdd_hhmmss") & ".txt"

fName = fPath & myFileName
Application.DisplayAlerts = False
'do the save

ActiveWorkbook.SaveAs Filename:=fName, FileFormat:=19
Application.DisplayAlerts = True

MsgBox "File Saved to " & fName
End Sub

Answer #3    Answered By: Cyka Jansen     Answered On: Sep 12

I did not realise you were on a Mac. There are differences from
Windows and I do not know what they are. Have never used one.

In Windows versions the Personal.xls is used in a similar way to normal.doc in
word. It contains macros  and other customisations which are available each
time you use Excel. It is opened as a hidden worksheet  each time  you open
Excel. If you want to change it you may need to unhide it. In Windows it
lives in C:\Documents and Settings\<username>\Application
Data\Microsoft\Excel\XLSTART\ I don't know where it is on the Mac.

Answer #4    Answered By: Robin Hayes     Answered On: Sep 12

It was acting the way you mention. I didn't know
there was a hidden worksheet  associated with it. I
thought it was just to store macros. I just need to
fix it and get it back  again.

Didn't find what you were looking for? Find more on Personal Workbook corrupted Or get search suggestion and latest updates.