New To UFT? Join the best UFT Training Online!

Micro Focus QTP (UFT) Forums › Micro Focus UFT (earlier known as QTP) › VB Scripting/Descriptive Programming v
I want to Save the excel file without a save as window

Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Thread Modes
I want to Save the excel file without a save as window
sreekanth chilam Offline
Senior Member
****
Posts: 350
Threads: 2
Joined: Mar 2008
Reputation: 0
#2
Solved: 11 Years, 3 Months, 3 Weeks ago 02-03-2010, 10:07 PM
Hi,

Try as given below.

Code:
sourcefile = "\\..\..\Type_QTP.xls"
Set xlApp = CreateObject("Excel.Application")
xlApp.Workbooks.Open(sourcefile)
xlApp.sheets("Sheet1").Select
xlApp.sheets("Sheet1").Range("G2:G20") = "Some data"
xlApp.ActiveWorkBook.Save
xlApp.Application.Quit
Set xlApp = Nothing
Find
Reply


Messages In This Thread
RE: I want to Save the excel file without a save as window - by sreekanth chilam - 02-03-2010, 10:07 PM

Possibly Related Threads…
Thread Author Replies Views Last Post
  Save scripts from QC to Local Disk-need help with code monsuer15 1 3,196 10-10-2017, 03:08 PM
Last Post: bela.chuphal
  Object doesn't support this property or method: 'window(...).window(...).winobject' senthil5683 1 3,674 07-04-2016, 07:08 PM
Last Post: venkatesh9032
  How to update CSV File and need to Save same CSV File kotaramamohana 1 3,511 10-24-2015, 08:40 AM
Last Post: tigerliew
  Not able to click the save button in Save As window while downloading from SAP kathirvelnagaraj 0 2,459 08-25-2015, 07:37 PM
Last Post: kathirvelnagaraj
Sad Save data from pdf file to a word doc Amar 0 2,623 12-12-2013, 12:29 PM
Last Post: Amar

Forum Jump:


Users browsing this thread: 1 Guest(s)