I created an OLE object to embed an .xls file into the table.
...
OLETable2.OLETypeAllowed = acOLEEmbedded
OLETable2.Action = acOLEInsertObjDlg
...
The code works, but in the same time I want to use the original .xls file name and copy and rename it in the same directory ( I used for this the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.