Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
jyothish8807
Master II
Master II

Importing issue

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
Labels (1)
0 Replies