Bex Excel VBA Save Workbook as New Workbook

[Former Member]

Hi All,

I'm trying to write VBA to save a workbook back to the SAP server with a new name. Basically the code will have to emulate the "save as new workbook" button on the on the bex toolbar except we would already have the new name defined. I know there is a vba function sapbexsaveworkbook but I don't believe it can accomplish what I want to do.

Any help would be greatly appreciated.

Thanks,

Jon

[Former Member]

Jon,

The BEx API Function you are referring to would be called with the following line of code:

Run "SAPBEX.XLA!saveNewWorkbook"

I think it will do exactly what you describe that you want. Try it, and if it does not do exactly what you want, please explain.

- Pete