| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cannot save excel files to a folder on a network | Excel Discussion (Misc queries) | |||
| Cannot save external data into file excel system show not respondi | Excel Discussion (Misc queries) | |||
| I can not save archive file in excel | Excel Discussion (Misc queries) | |||
| TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
| Excel XP: File name in Title Bar not changed after Save As... | Excel Discussion (Misc queries) | |||
Linear Mode
