I am trying to write a macro to export data from a table from QV to an excel spreadsheet. I am new to this and so I am having trouble debugging and fixing the error that I am receiving. Here is the macro so far..
Set AD=ActiveDocument Set MN=AD.Fields("Month_Name") Set XLApp = CreateObject("Excel.Application") Path = "RightPath" FileName = "RigthFile.xls"
XLApp.Visible=True Set XLS = XLApp.Workbooks.Open(Path & FileName)