Problem Saving With Different Version
I have a problem with my macro concerning different excel versions. The
macro was written with excel 2003 and runs perfectly on it. unfortunately I had to find out, that with different versions such as excel 2000 or excel for apple, this macro causes problems and basically is not saving the file. Worksheets(ComboBox1.Value).Copy Workbooks(Workbooks.Count).Activate Application.DisplayAlerts = False Application.Dialogs(xlDialogSaveAs).Show ("Name der Exportdatei.xls") Workbooks(Workbooks.Count).Close Application.DisplayAlerts = True do you know how to fix this problem, what is causing the problem or at least which versions are affected by this problem? thx a lot for your help alex |
Problem Saving With Different Version
I do not see where there is a command for it to save the file.
" wrote: I have a problem with my macro concerning different excel versions. The macro was written with excel 2003 and runs perfectly on it. unfortunately I had to find out, that with different versions such as excel 2000 or excel for apple, this macro causes problems and basically is not saving the file. Worksheets(ComboBox1.Value).Copy Workbooks(Workbooks.Count).Activate Application.DisplayAlerts = False Application.Dialogs(xlDialogSaveAs).Show ("Name der Exportdatei.xls") Workbooks(Workbooks.Count).Close Application.DisplayAlerts = True do you know how to fix this problem, what is causing the problem or at least which versions are affected by this problem? thx a lot for your help alex |
Problem Saving With Different Version
If you are relying on the Application.Dialogs(xlDialogSaveAs).Show command to
save the file, the user will have to enter the file name in the dialog box that this command calls. Whatever the user puts in that dialog box is what the file will be saved as, so if the user is not aware that the file should be a specific name, it could be being saved under almost any name. " wrote: I have a problem with my macro concerning different excel versions. The macro was written with excel 2003 and runs perfectly on it. unfortunately I had to find out, that with different versions such as excel 2000 or excel for apple, this macro causes problems and basically is not saving the file. Worksheets(ComboBox1.Value).Copy Workbooks(Workbooks.Count).Activate Application.DisplayAlerts = False Application.Dialogs(xlDialogSaveAs).Show ("Name der Exportdatei.xls") Workbooks(Workbooks.Count).Close Application.DisplayAlerts = True do you know how to fix this problem, what is causing the problem or at least which versions are affected by this problem? thx a lot for your help alex |
Problem Saving With Different Version
The user is supposed to enter a name. No automatic name needed. "Name
der Exportdatei" is just the default name. The problem is, that it just works with some Versions, and other cause problem. On the computer of a friend the save button of the xldialogsaveas-box is just not responding. nothing happens. any ideas why??? JLGWhiz schrieb: If you are relying on the Application.Dialogs(xlDialogSaveAs).Show command to save the file, the user will have to enter the file name in the dialog box that this command calls. Whatever the user puts in that dialog box is what the file will be saved as, so if the user is not aware that the file should be a specific name, it could be being saved under almost any name. " wrote: I have a problem with my macro concerning different excel versions. The macro was written with excel 2003 and runs perfectly on it. unfortunately I had to find out, that with different versions such as excel 2000 or excel for apple, this macro causes problems and basically is not saving the file. Worksheets(ComboBox1.Value).Copy Workbooks(Workbooks.Count).Activate Application.DisplayAlerts = False Application.Dialogs(xlDialogSaveAs).Show ("Name der Exportdatei.xls") Workbooks(Workbooks.Count).Close Application.DisplayAlerts = True do you know how to fix this problem, what is causing the problem or at least which versions are affected by this problem? thx a lot for your help alex |
All times are GMT +1. The time now is 04:00 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com