07-09-2011, 12:24 AM
Maybe that's my issue: lol.
I seem to be getting two open xls sheets (Book1 and DocCviewHref.xls).
After Book1 is created, my goal is to determine if it is already saved. If not Save, if iut is present SaveAs.
But, my following code opens the DocViewHref.xls while the Book1 is still there. I just need to save the Book1 (which is currently open) as DocViewHref.xls and only keep this xls file iopemn.
What is wrong with my code? What do I change:
set wb=objExcel.Workbooks.open(original)
to?
thxx
I seem to be getting two open xls sheets (Book1 and DocCviewHref.xls).
After Book1 is created, my goal is to determine if it is already saved. If not Save, if iut is present SaveAs.
But, my following code opens the DocViewHref.xls while the Book1 is still there. I just need to save the Book1 (which is currently open) as DocViewHref.xls and only keep this xls file iopemn.
What is wrong with my code? What do I change:
set wb=objExcel.Workbooks.open(original)
to?
thxx