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

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

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

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