can't save VBA script when saving excel file
 

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?

can't save VBA script when saving excel file
 

What version of excel are you using?

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



thinktwice wrote:

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?

--

Dave Peterson

can't save VBA script when saving excel file
 

Excel2003 chinese version


What version of excel are you using?

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

Dave Peterson

can't save VBA script when saving excel file
 

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.

thinktwice wrote:

Excel2003 chinese version

What version of excel are you using?

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

Dave Peterson

--

Dave Peterson

can't save VBA script when saving excel file
 

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

"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.

thinktwice wrote:

Excel2003 chinese version

What version of excel are you using?

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

Dave Peterson

--

Dave Peterson

can't save VBA script when saving excel file
 

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.

thinktwice wrote:

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

"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.

thinktwice wrote:

Excel2003 chinese version

What version of excel are you using?

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

Dave Peterson

--

Dave Peterson

--

Dave Peterson