Quick Macro Question

  • Thread starter Thread starter Toria
  • Start date Start date
T

Toria

Hello,

I'm a bit out of my league here with this question. I want to see if it's
possible to write a macro in Access that would input items in the Access
table into an internal company system. Can that be done in Access or Excel
or does that have to be SQL?

Thank you.
 
I didn't mean SQL. I meant can a macro be written in Access or Excel that
incorporates another program. In this case it would be simulating some data
entry into another system.
 
Without knowing what system Access will have to interact with, I can't say
for certain if it would be possible in your case. It is possible to get
Access to interact with other programs and/or systems, and would require some
advanced programming.

However, it's not entirely possible to get a macro to directly interact with
another system/program. Instead you would have to write the necessary code
in a VBA Module, and use the macro to run a function in the module.
 
Thank you. This is what I needed to know. It sounds like, if I understand
correctly, that this would require advance knowledge of proramming in a VBA
module and not be able to just record a macro in Excel or Access.
 
Toria,

No, that is not correct. It depends a lot on what the other system is,
and what data manipulations etc you need to do. For example, you may be
able to link to the data in the other system, in which case you can
treat the data in a similar way as you deal with the local data tables.
Or you may be able to import from or export to the other system. The
access to the other program's data is the critical factor, I imagine.
Whether you use macros or VBA procedures is another question, but if you
can use VBA, then there is likely no reason why you couldn't use macros.
But this is all at a very general level of discussion, in keeping with
the vague question.
 
Back
Top