New To UFT? Join the best UFT Training Online!

Micro Focus QTP (UFT) Forums › Micro Focus UFT (earlier known as QTP) › UFT / QTP Beginners v
Error while saving an already opened Excel

Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Thread Modes
Error while saving an already opened Excel
dplank Offline
Junior Member
**
Posts: 4
Threads: 1
Joined: Aug 2014
Reputation: 0
#2
Not Solved 08-28-2014, 06:35 PM
Try this:

Code:
Set objExcel = Eval("GetObject(,""Excel.application"")")    
objExcel.DisplayAlerts = False
Set xlBook=objExcel.Workbooks.ActiveWorkbook
Set xlSheet = xlBook.ActiveSheet
xlSheet.Activate
xlBook.SaveAs("c:\test.xls")
Find
Reply


Messages In This Thread
RE: Error while saving an already opened Excel - by dplank - 08-28-2014, 06:35 PM

Possibly Related Threads…
Thread Author Replies Views Last Post
  [UFT] Close opened folder robertosalemi 1 3,337 02-10-2016, 07:06 PM
Last Post: robertosalemi
  On Saving Script in QTP 11 my Global Data Sheet data is removed M Adnan Iftikhar 0 2,173 06-02-2015, 09:19 PM
Last Post: M Adnan Iftikhar
  QTP 11, Win 7 - Issue while saving the Excel through the script.bu fine in XP sivasuman 0 2,294 11-15-2013, 01:38 PM
Last Post: sivasuman
  Can QTP AOM identify word documents that are already opened anil2u 2 4,373 09-05-2013, 12:45 PM
Last Post: anil2u
  Getting ODBC error while executing the sql query in excel(DB) Shkumari 5 4,914 05-10-2013, 06:15 PM
Last Post: Shkumari

Forum Jump:


Users browsing this thread: 1 Guest(s)