Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Save Excel file
#5
Not Solved
I got it, finally. Dont know why, but I changed objExcel.close to objExcel.quit and everything works.

Well almost everything.

Only the obExcel.ac tiveworkbook.save does not save the file with the latest time stamp, thus it must not be saving as I expect it to. The code does the step, bbut the time stamp does not update to the newest time.

Do I need to do something to re save the xls file with the new time stamp.

or

Can I add a count, or change the save name to add the time or env?
Reply


Messages In This Thread
Save Excel file - by mv8167 - 07-13-2011, 12:57 AM
RE: Save Excel file - by rajpes - 07-13-2011, 09:20 AM
RE: Save Excel file - by mv8167 - 07-13-2011, 07:48 PM
RE: Save Excel file - by rajpes - 07-13-2011, 10:58 PM
RE: Save Excel file - by mv8167 - 07-14-2011, 02:19 AM

Possibly Related Threads…
Thread Author Replies Views Last Post
  How to export the output value of a webedit object to a new excel file. mounika6677 1 1,334 04-14-2019, 05:18 PM
Last Post: mounika6677
  Access not saved excel file randhirsinghskhn 0 934 09-04-2018, 07:26 AM
Last Post: randhirsinghskhn
  dtLocalSheet empty even though excel file contains data cantorre 2 2,230 05-10-2017, 12:47 PM
Last Post: vidhi
  Extract and save a file from zip folder using VB Script karthicksri07 1 6,193 06-29-2016, 02:19 PM
Last Post: Ankesh
  Unable to Save a file in UFT 12.0.2 (Sequence contains more than one matching elemen) noeldsouza89 0 2,489 02-02-2015, 03:03 PM
Last Post: noeldsouza89

Forum Jump:


Users browsing this thread: 1 Guest(s)