Can you write VBA to export objects


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




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.


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