Need help with custom open/save functions
 

Hi,

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

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

I'm pretty new at all this, so any help will be useful.

Thanks in advance

--
Message posted from http://www.ExcelForum.com

Need help with custom open/save functions
 

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

Need help with custom open/save functions
 

Hi Jan,

Thanks for your reply. I'll check that out. Something tells me I'll be
back with follow-up questions :)

/ phreud


---
Message posted from http://www.ExcelForum.com/