Dim xx As New Microsoft.Office.Interop.Excel.Application '定义进程
Dim yy As Microsoft.Office.Interop.Excel.Workbook '定义工作簿
xx = CreateObject("Excel.Application") '创建Excel对象
yy = xx.Workbooks("sheet1")
yy.Worksheets("sheet1").range("A1")="sheet2!b2"
yy.Save()
yy.Close()
yy = Nothing
xx.Quit()
xx = Nothing '销毁组建释放资源
追问你好,我是要在AI建一个超链接,超链接指向sheet2的B2,不是向A1赋值为"sheet2!b2"