Mark,

Frank is correct regarding updating SAP, use the supplied API. Even if you
could work out how to update directly, you are creating a maintenance
headache when SAP moves on . The API will be protected, the fundamentals
less likely to be.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Frank Kabel" wrote in message
...
Hi Mark
IMHO the way to go is to use SAP function modules (BAPI calls). Don'
update the tables directly (you may get problems when updating SAP)

SAP delivers example codes for calling function modules from VB, JAVA,
C++, etc. this should be adaptable to VBA (though i have never done
this).

--
Regards
Frank Kabel
Frankfurt, Germany

Mark Bigelow wrote:
Hello,

I would like to do two things:

1. Update forecasts in the R/3 system via Excel VBA. There are two
ways I could do this and I would appreciate help on either one:
a. Through transaction MC94 and a VBA transaction call
b. Directly updating the R/3 table itself.

2. Call report transactions in R/3 through VBA and return the output
to Excel.

Any help would be VERY appreciated.

Thanks in advance!
Mark