Iam trying to import my data to another pc. I want to create excel files automatically to other pc and it should keep on updating by creating new files when ever i import new updated data. iam using this module to perform this task but the colored line is giving an error ( Obj is missing).Can any one plz explain this code.
sub Exportexcel1
vFile = ActiveDocument.Variables("vInput1").GetContent.String
'XLDoc.SaveAs "c:\Qlikview\Claro"& vFile &".xls"
set obj = ActiveDocument.GetSheetObject("CH580")
obj.ExportEx "C:\Users\jyothishk\Desktop\ADI\Feedback\Amit Saini\"& vFile &".xls",5
End sub
Best Regards,
KC