Hi all,

Need help with exporting from Excel to Excel!

I have a form in Excel which certain information from the user and outputs a calculated figure.

After all the information has been input and the user has been presented with an output the user has to be able to save all this information for future reference. They can simply do this by clicking on the save button. The problem is the resulting file is big in size due to the form being full of macros and user interfaces. To eliminate this problem I want to write a macro which copies only the variable information from the form (the information input by the user) and exports it to another excel workbook and then saves that instead. The resulting file is much smaller as it only contains raw data.

Users input information into cells and the cells they input the information into is always the same (i.e. the copy range is fixed). So here is a simplified version of the problem:

1. User opens the form
2. Inputs values into cells: C5 , D12, E13
3. After all is done they run the macro (the macro I’m intending to write) and Excel creates a new excel file in the named folder containing the following information: A1 = C5 (C5 from the form), A2 = D12 and A3 = E13.

Any help is much appreciated. Please be descriptive as I’m still a novice in VBA.

Many thanks