Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Is it possible to save just a worksheet out of a workbook that is quite large?
Example: I have a user form that extracts data from a worksheet labeled 'data', and with a command button inputs the data into another worksheet labeled 'form' in the same workbook. The userform also allows the user to change the information on the user form if it is incorrect, and then with the command button populate the appropriate fields on the form (worksheet formatted to look like a commonly used form). Since the workbook's size is upwards of 1 meg, and each applicant would have to be saved, I thought the best way would be to save just the form with the data put into it. I have tried several different ways via this website and others, but I am a novice vba user. Please help! Thankyou. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I save a worksheet within a workbook? | Excel Discussion (Misc queries) | |||
Save Worksheet vs Workbook | Excel Worksheet Functions | |||
Save Every Worksheet as its own Workbook | Excel Programming | |||
Save Workbook or worksheet | Excel Programming | |||
save worksheet as new workbook | Excel Programming |