This macro will loop thru objects in Sheet "Main" and will send object with Caption Name specified by userinput
name = ActiveDocument.GetApplication.InputBox("Enter name of the object?")
Objects = ActiveDocument.ActiveSheet.GetSheetObjects
For j = lBound(Objects) To uBound(Objects)
set obj = Objects(j)
IF obj.GetCaption.Name.v = name Then
You can add listbox with objects in the sheet so user knows names of the objects.
make sure that all objects have caption name
Export.qvw 131.8 K
Thanks for your nice feedback. I can get a text file in my local machine with piece of code i have already mentioned. My problem is, when i press the web mode on it doesnt work. What i mean is, If i deploy the Dashboard in production, will the macro going to work in the accesspoint? Is it going to prompt a download option of the specified object in text file?