can't save VBA script when saving excel file

T

thinktwice

there's any error message when i save a excel file which contains vba
script, but when i reopen it ,the vba script has gone, why?
 
D

Dave Peterson

What version of excel are you using?

And are you saving the file as a normal workbook or a text file (.prn, .csv,
....)?
 
D

Dave Peterson

I've never used the chinese version of excel, but you didn't answer the second
question.

If you're saving it as text (extensions of .prn, .csv in English), then macros
won't be saved with it.
 
T

thinktwice

sorry, didn't notice your second question,
i saved it as a normal workbook (xls)

"Dave Peterson дµÀ£º
"
 
D

Dave Peterson

I don't have another guess, but maybe you can check to see if it's excel or just
that single workbook by creating a new workbook, adding some macros and seeing
what happens.
 
Top