?
Solved

VBA Export Worksheet module with worksheet formulas

Posted on 2011-05-06
6
Medium Priority
?
485 Views
Last Modified: 2012-05-11
I am working on a source control untility for vba for excel.

I am aware it is possible to export modules, class modules, forms.

I would like to understand if it is possible to export worksheets modules with the formulas on front end for that WS to an external location for backup?

if above is not possible any alternative?

does VSS handle this? or it can work only with modules ?
0
Comment
Question by:cynx
  • 4
  • 2
6 Comments
 
LVL 6

Expert Comment

by:Eric Zwiekhorst
ID: 35705730
Hi Cynx,

if you open VBA go to the sheet holding the modules, right click the sheet icon and choose export file excel will create a Sheetxx.cls holding all Subroutines and functions of this sheet.


Kind regards

Eric
0
 
LVL 6

Accepted Solution

by:
Eric Zwiekhorst earned 2000 total points
ID: 35705743
If you would need to have fomula's on the sheet also, copy sheet to new workbook and save this workbook. Then the new workbook will hold all modules and the cell contents.

Kr
Eric
0
 
LVL 1

Author Comment

by:cynx
ID: 35705863
thanks for your input, yes I did consider the option to setup a centralized workbook for backup of modules aswell as the worksheet.
however before I start on this utility, I would like to understand how VSS works, if it does handle the worksheet backup, I can consider using VSS rather developing new utility.

Could you please confirm if VSS would allow only check out / check in of Modules/class/forms and not worksheets (with formulas) ?
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
LVL 6

Expert Comment

by:Eric Zwiekhorst
ID: 35717797
Please have a look at this
http://en.wikipedia.org/wiki/Microsoft_Visual_SourceSafe

It might answer some of your VSS questions...
0
 
LVL 1

Author Comment

by:cynx
ID: 35718702
I had a look at above link. this doesnt provide info on my query...which is,
Could you please confirm if VSS would allow only check out / check in of Modules/class/forms and not worksheets (with formulas) ?
0
 
LVL 6

Assisted Solution

by:Eric Zwiekhorst
Eric Zwiekhorst earned 2000 total points
ID: 35718732
VSS has the file, if you change the file (after check out check in) all changes will be in, also Module class forms.
If you do not want workeheets but only the modules themselves you can transport as file. And then again VSS will check in/check out the file as is is plain text...

Maye you would need to change the file type..

Kr Eric
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you need to forecast numbers -- typically for finance -- the Windows and Mac versions of Excel 2016 have a basket of tools to get the job done.
New style of hardware planning for Microsoft Exchange server.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question