Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Save As issue
#6
Solved: 11 Years, 4 Months ago
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
Reply


Messages In This Thread
Save As issue - by mv8167 - 07-07-2011, 11:01 PM
RE: Save As issue - by rajpes - 07-07-2011, 11:20 PM
RE: Save As issue - by mv8167 - 07-08-2011, 04:35 AM
RE: Save As issue - by mv8167 - 07-08-2011, 09:43 PM
RE: Save As issue - by rajpes - 07-08-2011, 09:56 PM
RE: Save As issue - by mv8167 - 07-09-2011, 12:24 AM
RE: Save As issue - by mv8167 - 07-09-2011, 01:54 AM
RE: Save As issue - by rajpes - 07-09-2011, 08:02 AM
RE: Save As issue - by mv8167 - 07-11-2011, 08:51 PM
RE: Save As issue - by rajpes - 07-11-2011, 10:23 PM

Possibly Related Threads…
Thread Author Replies Views Last Post
  Save or Save As not working for QTP 11 Nick 1 3,222 08-13-2011, 12:16 PM
Last Post: vaddevinod

Forum Jump:


Users browsing this thread: 3 Guest(s)