Hi Phreud,

I'm working on a pretty big project where I use UserForms for better
interface. The xls file i pretty big due to quite alot of work with the
UserForms. Now I want a way for users to be able to save the
information in the worksheet, without having to save the whole xls file
(with userforms and all).

Can anyone point me in the right direction? I'm thinking maybe the best
way to go is using some sort of import/export function to save the
contents of the worksheet into a text file (with my own file extension?
Maybe I can even customize an icon?). If so, is GetSaveAsFilename the
right function to use?


Consider copying all worksheets to a new workbook (which will have no
code unless you have code behind the sheets) and saving the copy:

ThisWorkbook.Worksheets.Copy
Activeworkbook.SaveAs "c:\WhateverPath\WhichEverFilename.xls"
Activeworkbook.Close False

Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com