Wrox Programmer Forums
|
Classic ASP Basics For beginner programmers starting with "classic" ASP 3, pre-".NET." NOT for ASP.NET 1.0, 1.1, or 2.0
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Classic ASP Basics section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old November 17th, 2008, 07:23 PM
Friend of Wrox
 
Join Date: Jan 2004
Posts: 1,870
Thanks: 12
Thanked 20 Times in 20 Posts
Send a message via AIM to mat41
Default Create PowerPoint files

Good day -

Classic ASP to PowerPoint, is this possibe?

So far my research is not going well for good old classic ASP. has anybody done, heard about or think this is possible?

TYIA

Wind is your friend
Matt
www.elitemarquees.com.au
__________________
Wind is your friend
Matt
 
Old November 17th, 2008, 07:53 PM
Friend of Wrox
 
Join Date: Jun 2008
Posts: 1,649
Thanks: 3
Thanked 141 Times in 140 Posts
Default

Probably same answer as ASP-to-Word or ASP-to-Excel.

You have to use
    Set ppt = Server.CreateObject("PowerPoint.Application")
(or similar) and then you can use all the methods that PP "exposes" to VBA coding.

That is, if you know how to use VBA within PowerPoint, you can probably translate the VBA to ASP-based VBS without *too* much difficulty.

The objects, methods, properties, and events you can use are all documented in the HELP for PP, but wading through those docs is not for the faint of heart.

Good luck.
 
Old November 24th, 2008, 10:09 PM
Friend of Wrox
 
Join Date: Jan 2004
Posts: 1,870
Thanks: 12
Thanked 20 Times in 20 Posts
Send a message via AIM to mat41
Default

mmmmmm im giving up on this one and I guess I am posting this here for the benefit or advice of others....

I use:
Response.ContentType = "application/vnd.ms-excel"

for example when creating .xls docs. Its all to easy to show the ASP pages content inside a .xls file, insert that line above and presto you have your .xls - This powerpoint thing all looks very dificult. The only way I have seen that remotly may do what I wish turns ASP to XML to PowerPoint. However this relies on the client having PowerPoint 2007. There is an update which can enable PP 2003 to facilitate this but this is not an option for me as the SOE of the production environment is very strict and will not allow any client updates.

AGGGHHHH

Wind is your friend
Matt
www.elitemarquees.com.au
 
Old November 24th, 2008, 10:48 PM
Friend of Wrox
 
Join Date: Jun 2008
Posts: 1,649
Thanks: 3
Thanked 141 Times in 140 Posts
Default

Not at all the same thing.

It just so happens that Excel *can* open up an HTML <TABLE> as if it is a single spreadsheet.

But you can't (for example) produce a multiple-sheet ".xls" file in this manner and you can't create graphs and and and...

To do any of that stuff, you'd have to do as I noted: Script the excel object *ALL ON THE SERVER*. And, unfortunately, that's the answer for PowerPoint.

Not at all trivial. I think I could create a two-slide presentation with simple content in...oh, maybe a full day of messing around?
 
Old November 24th, 2008, 10:58 PM
Friend of Wrox
 
Join Date: Jan 2004
Posts: 1,870
Thanks: 12
Thanked 20 Times in 20 Posts
Send a message via AIM to mat41
Default

Interesting, I understand now...

I am steering the client towards simply placing a link in PP preso to extrenal ASP files. Apart from how difficult this would be my leverage is the moment the PP preso is created and distributed its out of date in relation to the main ASP system data. This I think is reason enough to convince them to forget idea.

As always your knowledge is very much appriciated. have a nice day Old Pendant :o)

Wind is your friend
Matt
www.elitemarquees.com.au
 
Old November 25th, 2008, 10:40 PM
Friend of Wrox
 
Join Date: Jun 2008
Posts: 1,649
Thanks: 3
Thanked 141 Times in 140 Posts
Default

As a minor comment: Even the show-table-as-Excel fails if the user does not have Excel installed on his/her computer. It's strictly a client-side operation.
 
Old November 25th, 2008, 10:45 PM
Friend of Wrox
 
Join Date: Jan 2004
Posts: 1,870
Thanks: 12
Thanked 20 Times in 20 Posts
Send a message via AIM to mat41
Default

Of course they wouldnt be able to open it but for what ever reason they could still save the .xls file.

Wind is your friend
Matt
www.elitemarquees.com.au





Similar Threads
Thread Thread Starter Forum Replies Last Post
Create pdf files from VB.net hoeknu VB How-To 4 October 27th, 2006 10:03 AM
How I create setup files in vb 2005 express aeroboy32000 Visual Basic 2005 Basics 1 June 14th, 2006 08:06 PM
How to create a folder in server and rename files pramos.21d ASP.NET 2.0 Basics 0 April 24th, 2006 05:27 AM
how to create playlist for real audio files method PHP How-To 0 July 11th, 2005 08:11 AM
Create/Delete files w/ASP using FileSystemObject John K. King Classic ASP Basics 3 August 17th, 2003 06:53 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.