Link to home
Start Free TrialLog in
Avatar of pdering
pdering

asked on

Updating an Excel document via Access VBA

Why doesn't this code work?
Access 2013
Excel 2010


 Set objapp = CreateObject("Excel.Application")

            objapp.Visible = True
            Set wb = objapp.Workbooks.Open("c:\test.xlsx", True, False)
               objapp.Range("A1").Cells.Replace What:="123", Replacement:="456", LookAt:=xlPart, _SearchOrder:=xlByRows, MatchCase:=False
ASKER CERTIFIED SOLUTION
Avatar of IrogSinta
IrogSinta
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of pdering
pdering

ASKER

Great!