Issues with saving current worksheet without macros, conditional, formulas + email in Lotus

[csimonds]

Hi,

I have a spreadsheet set up as an order form. The orders are entered within a table, the table contains 3 dependent drop downs across 3 columns. I have a "Submit" button, which prompts the order form to be emailed using Ron de Bruin, Lotus Notes: Send the active sheet as an attachment http://www.rondebruin.nl/notes7.htm. What I am wanting this code to do is save a copy of the spreadsheet in a defined folder, removing macros, formulas, buttons and dropdowns. This should be the same format for the file then emailed, (currently the code emails the spreadsheet as is with macros etc.). I would then like the code to close the original spreadsheet without saving.

Any assistance would be greatly appreciated.

Thank you

 

[Sal Paradise]

Hi,

I have a spreadsheet set up as an order form. The orders are entered within a table, the table contains 3 dependent drop downs across 3 columns. I have a "Submit" button, which prompts the order form to be emailed using Ron de Bruin, Lotus Notes: Send the active sheet as an attachment http://www.rondebruin.nl/notes7.htm. What I am wanting this code to do is save a copy of the spreadsheet in a defined folder, removing macros, formulas, buttons and dropdowns. This should be the same format for the file then emailed, (currently the code emails the spreadsheet as is with macros etc.). I would then like the code to close the original spreadsheet without saving.

Any assistance would be greatly appreciated.

Thank you

Why don't you copy the data (values) and formats to a new sheet? That shouldn't copy the dropdowns, and the sheet would look the same, but since it's a new book it wouldn't contain any code or formulas, just the final info.

So the general code would be:
- Once submit is hit
- Copy values, paste special to new sheet
- Copy formats, paste special to new sheet
- Save new sheet as whatever file name in whatever folder
- E-mail new sheet
- Close original sheet without saving