Hi folks,We can create excel by using print statment also,
how to create using it .
Thanks in advance
Hanuman maruti
Subject: Can you restate the problem with a bit more detail?
Subject: RE: Can you restate the problem with a bit more detail?
Is there is some way like doing like this
Print |content type: mybook.xls|
Subject: RE: Can you restate the problem with a bit more detail?
Still not totally clear on your requirements so I’m going to guess “you want to print an Excel file. The Excel file lives on a file share or the user’s C: drive. You want to use LotusScript for the printing function”
If this is a Notes app, you could use OLE.
Code is written in LS
Open the file
Issue the OLE commands to print (search the forum and use the FAQs, lots of information on using OLE and Excel)
Close the file
If the file included a print macro, you could just run that macro via OLE.
If this is a web thing…no clue.
Subject: RE: Can you restate the problem with a bit more detail?
Dear Doug Finner ,Thanks a lot for your response, may be the way i questioned is not correct. I got the solution for it ,i will explain what excatly i want so that it will be usefull for others.
My Question::can we create excel without creating Excel object?
Answer:: yes we can create
Solution::
dirpath = session.GetEnvironmentString(“Directory”, True)
newfilenumber% = Freefile()
filepath = dirpath & "Hanuman.xls"
Open filepath For Output As newfilenumber
Print # newfilenumber%, |
| My table |
Close newfilenumber%
