Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Macro won't record importing into AR Customers

Status
Not open for further replies.

Shacktar

Programmer
Sep 13, 2005
10
CA
Hi all,

I've been trying to record a VBA macro which imports a given CSV file to AR Customers. Unfortunately, all the macro records is the opening of the windows. There is nothing after that. Do you guys have any ideas?

thanks,
shacktar
 
Another thought...

The import function is error prone, actually the import file is prone to user error, and the imports crap out with cryptic messages.

A better option is to use the API and write customer details directly to the views.

Record a macro while you add a customer to see how this is done, you need to filter out a lot of the junk that is recorded in teh macro.

I do many integrations like this and it is way better than messing around with import files.
 
Search this site for 'ARCustomers' or 'AR0024'. You should get an example of using the API.

zemp
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top