GETOBJECT and open Book2 and Book4 (Posted by Khurram Tahir) - www.foxite.com

From: Khurram Tahir

Tags

GETOBJECT and open Book2 and Book4 Khurram Tahir GETOBJECT open Book2 Book4

Subject:	GETOBJECT and open Book2 and Book4
Thread ID:	226580	Message ID:	226580	# Views:	21	# Ratings:	0
Version:	Visual FoxPro 9		Category:	Microsoft Office Automation
Date:	Saturday, May 02, 2009 3:24:35 PM

Tmpsheet = GETOBJECT('','Excel.Sheet')

XLApp = Tmpsheet.Application

XLApp.Visible = .t.
XLApp.WorkBooks.Add()
XLSheet = XLApp.ActiveSheet

Q1. Why it is creating 2 Excel files naming Book2 and Book4 how can i avoid 2 Excel files only open and save 1 Excel file from above commands

Tip: click here to scan for Windows Registry Errors and Optimize PC performance

COMPLETE THREAD

GETOBJECT and open Book2 and Book4 Posted by Khurram Tahir @ 5/2/2009 3:24:35 PM

RE: GETOBJECT and open Book2 and Book4 Posted by Mike Gagnon @ 5/2/2009 3:39:37 PM