Can you write VBA to export objects

  • Thread starter Thread starter christopher ward
  • Start date Start date
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
 
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
 
Back
Top