Hello everyone. I am new in doing the VBA in access and here is my problem.
I have 10 different sheets in a workbook and I want to make link the two sheets to my database which are sheet 1 and 10. In linking the sheet 1 i am using this code:
DoCmd.TransferSpreadsheet acLink, , "Sheet1", "Workbook1", True
i have noticed that this code, by default, is getting the first sheet of the workbook.
Is there any way to put the Sheet name to be linked? My problem is how to link the Sheet 10 using vba.
Hope that you can help me on this.
Thanks.
stigmatized