pdering
asked on
Updating an Excel document via Access VBA
Why doesn't this code work?
Access 2013
Excel 2010
Set objapp = CreateObject("Excel.Applic ation")
objapp.Visible = True
Set wb = objapp.Workbooks.Open("c:\ test.xlsx" , True, False)
objapp.Range("A1").Cells.R eplace What:="123", Replacement:="456", LookAt:=xlPart, _SearchOrder:=xlByRows, MatchCase:=False
Access 2013
Excel 2010
Set objapp = CreateObject("Excel.Applic
objapp.Visible = True
Set wb = objapp.Workbooks.Open("c:\
objapp.Range("A1").Cells.R
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER