Hi.. Having syntax problems and can't find help on FAQ.
Have an Access form with 3, textboxes. AfterUpdate on the last box, need to go and Open workbook and place on sheet1.cells(r,c).values from the textboxes.
I can get the workbook open with no problems, but cannot add the data to the appropriate sheet.
Thanks for the help..
Have an Access form with 3, textboxes. AfterUpdate on the last box, need to go and Open workbook and place on sheet1.cells(r,c).values from the textboxes.
I can get the workbook open with no problems, but cannot add the data to the appropriate sheet.
Thanks for the help..