Is it possible to use excel to input data into another application.
I want to use excel to input my Journal Entries into SAP.
All It needs to do is the eqivalent of me pressing:
Alt-tab, down arrow, down arrow, ctrl-V, Alt-Tab(back to excel).
Is this type of action possible with excel?
Is there an easier way to write this:
dim lastcell as range
Set lastcell = ActiveCell.Offset(-1, 7) 'happens at somepoint in the program
Range("b4:" & lastcell.Address(RowAbsolute:=False, ColumnAbsolute:=False)).Select
how about this:
Range(ActiveCell.Address(RowAbsolute:=False...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.