Page 1 of 1 1
Topic Options
#85178 - 2002-02-28 11:21 PM Save and close excel -- it is a race, on you mark, get set.... GO
Radimus Moderator Offline
Moderator
*****

Registered: 2000-01-06
Posts: 5187
Loc: Tampa, FL
I need COM Save and Close and Excel doc that I have COMed open. When I close excel it asks me to save.

I want it to save without asking.

Anyone???

_________________________
How to ask questions the smart way <-----------> Before you ask

Top
#85179 - 2002-02-28 11:52 PM Re: Save and close excel -- it is a race, on you mark, get set.... GO
Radimus Moderator Offline
Moderator
*****

Registered: 2000-01-06
Posts: 5187
Loc: Tampa, FL
Never mind... got it.

$xlopen = $objexcel.workbooks.open("$logon\Inventory\AhcaUser.xls")

$xlclose = $xlopen.save
$xlclose = $xlopen.close

_________________________
How to ask questions the smart way <-----------> Before you ask

Top
Page 1 of 1 1


Moderator:  Shawn, ShaneEP, Ruud van Velsen, Arend_, Jochen, Radimus, Glenn Barnas, Allen, Mart 
Hop to:
Shout Box

Who's Online
0 registered and 2312 anonymous users online.
Newest Members
fgarcia, Viginette, ManuvdWielNL, Sir_Barrington, batdk82
17889 Registered Users

Generated in 0.12 seconds in which 0.094 seconds were spent on a total of 12 queries. Zlib compression enabled.

Search the board with:
superb Board Search
or try with google:
Google
Web kixtart.org