can't save VBA script when saving excel file

  • Thread starter Thread starter thinktwice
  • Start date Start date
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?
 
What version of excel are you using?

And are you saving the file as a normal workbook or a text file (.prn, .csv,
....)?
 
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.
 
sorry, didn't notice your second question,
i saved it as a normal workbook (xls)

"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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2007 Can't Save File with VB Script but it can in 97/2003format??? 2
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
VBA to Save Email and set Custom Properties 0
Excel 2003 save as .XLSX 10
Unable to save files 0
How do I copy some cells(including formatting) and save as image fileusing VBA? 1
How to Pause an Excel VBA script without freezing excel 1
VBA code for "Save as PDF" 1

Back
Top