I'm trying to export an input box to excel via macro similar to this method that I know to work with a list box:
sub exportExcel()
set obj = ActiveDocument.GetSheetObject("LB01")
obj.ExportBiff "C:\test.xls"
set obj = nothing
end sub
I know this macro to work successfully and export a list box to an Excel workbook. However, whenever I try to do it with an input box it doesn't execute instead bringing me to the module. To try and make it work wit the input box all I'd do is change the ("LB01") to ("IB01") but to no avail.
I'd like to know what I could to to make it work, what I'm doing wrong, any help is appreciated.