Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

CreateObject("Excel.Application")

Status
Not open for further replies.
TheConeHead

TheConeHead

Programmer
Aug 14, 2002
2,106
US
This works locally on an html page just fine - but when I put it on a sverer on asp I get the following error:

ActiveX component can't create object: Excel.Application

Is something missing from the server?

Code: 
<SCRIPT LANGUAGE=VBScript>
     Dim objExcel
     Sub Btn1_onclick()
	 call OpenWorkbook("C:\Inetpub\[URL unfurl="true"]wwwroot\folder\file.xls")[/URL]
     End Sub
							
     Sub OpenWorkbook(strLocation)
	Set objExcel = CreateObject("Excel.Application")
	objExcel.Visible = true
	objExcel.Workbooks.Open strLocation
	objExcel.UserControl = true
     End Sub
</SCRIPT>

<a href="#" class="contentsw" NAME='Btn1'>Link</a>	

[conehead]
 
Sort by date Sort by votes
Does the machine that the code is running on have Excel installed? Are the security settings low enough to allow the code to create the object?

[red]"... isn't sanity really just a one trick pony anyway?! I mean, all you get is one trick, rational thinking, but when you are good and crazy, oooh, oooh, oooh, the sky is the limit!" - The Tick[/red]
 
Upvote 0 Downvote
yes - it does have excel installed - the security settings should be good - is there anything inparticular you would suggest I check?

[conehead]
 
Upvote 0 Downvote
make sure the IUSR_MachineName and IWAM_MachineName has the correct permissions...

-DNG
 
Upvote 0 Downvote
ConeHead - What is it that you are trying to do? Open a current spreadsheet or create a new one?


To look at old ones (and even edit them) you should look into
Code: 
Set excelApp = Server.CreateObject("Excel.Application")
			excelApp.Workbooks.Open Server.MapPath("../uploads/lrt/abstracts/" & lseAbs),false, true

For creating them from your ASP page, look at XML
Code: 
dim act
Set act = fso.CreateTextFile(fileName, true)
with act
	.WriteLine "<html xmlns:x=""urn:schemas-microsoft-com:office:excel"">"
	.WriteLine "<head>"
	.WriteLine "<!--[if gte mso 9]><xml>"
	.WriteLine "<x:ExcelWorkbook>"
		.WriteLine "<x:ExcelWorksheets>"
			.WriteLine "<x:ExcelWorksheet>"
			.WriteLine "<x:Name>" & cbr & "</x:Name>"
				.WriteLine "<x:WorksheetOptions>"
					.WriteLine "<x:PageSetup>"
						.WriteLine "<x:Header>" & CBR & "</x:Header>"
					.WriteLine "</x:PageSetup>"
					.WriteLine "<x:Print>"
						.WriteLine "<x:ValidPrinterInfo/>"
					.WriteLine "</x:Print>"
			.WriteLine "</x:WorksheetOptions>"
			.WriteLine "</x:ExcelWorksheet>"
		.WriteLine "</x:ExcelWorksheets>"
	.WriteLine "</x:ExcelWorkbook>"
	.WriteLine "</xml>"
	.WriteLine "<![endif]--> "
	.WriteLine "</head>"
	.WriteLine [blue]write an HTML table here and it is written as an Excel Sheet[/blue]
end with
act.close

Programming today is a race between software engineers striving to build better and bigger idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning. - Rick Cook
 
Upvote 0 Downvote
I am wanting to open an existing .xls but NOT open it in a browser window - but rather have it open in the excel app....

[conehead]
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

leifoet
  • Locked
  • Question
How to link a condition to a session(&quot;UID&quot;) ?
Replies
14
Views
522
leifoet
leifoet
leifoet
  • Locked
  • Question
How to display an existing date in Input type=&quot;date&quot;?
Replies
4
Views
296
leifoet
leifoet
krabban
  • Locked
  • Question
Using application(&quot;something&quot;) along with regular expressions
Replies
0
Views
151
krabban
krabban
TribeMan
  • Locked
  • Question
Jmail error message &quot;jmail.SMTPMail error '8000ffff' The message was undeliverable...&quot;
Replies
2
Views
176
ggriffit
ggriffit
cat5ives
  • Locked
  • Question
Server.CreateObject(&quot;Scripting.FileSystemObject&quot;) file exist doesn't work
Replies
2
Views
334
cat5ives
cat5ives

Part and Inventory Search

Sponsor

Back
Top