Exporting files and save method

XLS Padlock
1

Hello, hope someone may be able to point me in the right direction to solve:

A routine is being used to export tables to an external workbook. The routine works successfully in .xlsm format with either “ThisWorkbook.Path” or its XLSPadlock equivalent function.
However in the compiled .exe version the exporting of the file appears successful but the dialogue box is opening asking for the workbook (i.e. the compiled exe file) to be saved to its .xlsc format. How can I suppress this from happening please?

Thank you,
Dave

2

You can use this VBA routine:

This is exactly what you are looking for.

3

Thanks - managed to get it working.
Dave

1 Like