Velocity Reviews

Velocity Reviews (http://www.velocityreviews.com/forums/index.php)
-   HTML (http://www.velocityreviews.com/forums/f31-html.html)
-   -   ActiveX / Excel help... (http://www.velocityreviews.com/forums/t164289-activex-excel-help.html)

firstcustomer@gmail.com 02-21-2006 12:34 PM
ActiveX / Excel help...
 
Hi fellas, another request for help I'm afraid!

I've got a HTML page that has a form. When submitted, the form writes
to an Excel file. The problem is that the user is told that the file
already exists, do they want to overwrite it?

I want it to work without them being prompted (i.e it just overwrites
it without asking). Is this possible?

The HTML/ActiveX code and the Excel code is below:

<!--HTML-->
<HTML>
<HEAD>
<SCRIPT LANGUAGE="JavaScript">

<!-- Begin
function xlWrite(r,c) {
var xlApp, xlSheet;
xlApp = new ActiveXObject("Excel.Application");
xlApp.Visible = true;
xlApp.Workbooks.Open("C:\\xlText.xls");
xlSheet = xlApp.ActiveSheet;
xlSheet.Cells(r,c).Value = frm.txt.value;
xlSheet.SaveCopyAs("C:\\xlText.xls");
xlApp.Quit();
xlApp = null;
setTimeout("CollectGarbage()",1);
}
// End -->
</script>
</HEAD>

<FORM NAME="frm">
<INPUT TYPE="Text" NAME="txt" Value="Some cell text"><BR>
<INPUT TYPE="Button" VALUE="Put in row 1, column 2" ONCLICK="xlWrite
(1,1)">
</FORM>
</HTML>
<!--end HTML-->

Yes, I know it isn't "valid" HTML, but it works fine other than this
problem that isn't caused by the lack of body tags etc.

<!--excel-->

Private Sub Workbook_BeforeClose(Cancel As Boolean)
Application.DisplayAlerts = False
rowcounter = 2
While Range("a" & rowcounter) <> ""
rowcounter = rowcounter + 1
Wend
Rows("1:1").Copy
Rows(rowcounter).Select
ActiveSheet.Paste

End Sub

<!--end excel-->

Basically, the HTML form writes to a specified cell (A1 in this
example) and then closes Excel. before closing, Excel copies what is in
the top row, to the next empty row, if you get my meaning...

How can I stop it prompting whether to overwrite or not?

TIA, Neil.

Travis Newbury 02-21-2006 12:39 PM
Re: ActiveX / Excel help...
 
firstcusto...@gmail.com wrote:
> I want it to work without them being prompted (i.e it just overwrites
> it without asking). Is this possible?

Anything is possible...

firstcustomer@gmail.com 02-21-2006 12:44 PM
Re: ActiveX / Excel help...
 
Ok Travis, how is it possible?! :-)

Jose 02-21-2006 01:52 PM
Re: ActiveX / Excel help...
 
> I've got a HTML page that has a form. When submitted, the form writes
> to an Excel file. The problem is that the user is told that the file
> already exists, do they want to overwrite it?
>
> I want it to work without them being prompted (i.e it just overwrites
> it without asking). Is this possible?

Given a solution, how is the user protected against a similar, hostile
web page that overwrites his own excel spreadsheets?

Jose
--
Money: what you need when you run out of brains.
for Email, make the obvious change in the address.

Andy Dingley 02-21-2006 02:11 PM
Re: ActiveX / Excel help...
 
Jose wrote:

> Given a solution, how is the user protected against a similar, hostile
> web page that overwrites his own excel spreadsheets?

By the sandbox model. What an ActiveX is allowed to get up to depends
on from where you obtained the page. With crazyily insecure configs
this could be a problem, but the defaults are generally fairly safe.

This type of question though is really an Excel / COM / VBA question.
You'll find more relevant eyeballs over in one of the microsoft.*
groups.

Neil Monk 02-21-2006 07:17 PM
Re: ActiveX / Excel help...
 

"Jose" <teacherjh@aol.nojunk.com> wrote in message
news:NWEKf.1247$ha4.139@newssvr31.news.prodigy.com ...
>> I've got a HTML page that has a form. When submitted, the form writes
>> to an Excel file. The problem is that the user is told that the file
>> already exists, do they want to overwrite it?
>>
>> I want it to work without them being prompted (i.e it just overwrites
>> it without asking). Is this possible?
>
> Given a solution, how is the user protected against a similar, hostile web
> page that overwrites his own excel spreadsheets?
<snip>
By very harsh internet filtration software. :-)
--
Neil

Neil Monk 02-21-2006 07:29 PM
Re: ActiveX / Excel help...
 

"Neil Monk" <neil.monk02@greenyonder.co.uk> wrote in message
news:eHJKf.29827$Q22.7849@fe1.news.blueyonder.co.u k...
>
> "Jose" <teacherjh@aol.nojunk.com> wrote in message
> news:NWEKf.1247$ha4.139@newssvr31.news.prodigy.com ...
>>> I've got a HTML page that has a form. When submitted, the form writes
>>> to an Excel file. The problem is that the user is told that the file
>>> already exists, do they want to overwrite it?
>>>
>>> I want it to work without them being prompted (i.e it just overwrites
>>> it without asking). Is this possible?
>>
>> Given a solution, how is the user protected against a similar, hostile
>> web page that overwrites his own excel spreadsheets?
> <snip>
> By very harsh internet filtration software. :-)

I'm the OP btw, I'm just at home now!
--
Neil


All times are GMT. The time now is 03:05 PM.

Powered by vBulletin®. Copyright ©2000 - 2013, vBulletin Solutions, Inc.
SEO by vBSEO ©2010, Crawlability, Inc.