Avatar of Peter Chan
Peter Chan
Flag for Hong Kong

asked on 

Issue to table name

Why is there error
due to this line

Set rs = db.openrecordset("select * from " & ActiveSheet.Name & ";")

Open in new window

while ActiveSheet.Name is having value like "Week8-13"?

Microsoft AccessVBAMicrosoft ExcelMicrosoft Office

Avatar of undefined
Last Comment
Fabrice Lambert

8/22/2022 - Mon