Can you write VBA to export objects

C

christopher ward

Hi Experts

Any help you give greatfully recieved

I have a VBA solution which includes 2 modules .bas files and a large form
which has a frm file and frx file when you export the objects. Can VBA do
this from a macro automatically as an export tool , and also could VBA import
the objects automatically. The VBA I talk about is of course being moved to
many spreadsheets that have a similar form but different data within them
each being customer specific.

An unusual question I know but one which if solved could save me time of
doing the exports manually each time the code changes.

kind regards

Chris
 
T

Tim Williams

If the code is the same across all files then you might consider moving it
to an add-in.
That way you'll only have the one file update code in.

Tim
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top