Re: How to Write into Excel

From: Val Mazur (group51a_at_hotmail.com)
Date: 10/30/04

  • Next message: Val Mazur: "Re: MDAC 2.8 vs MDAC 2.7" 
    Date: Sat, 30 Oct 2004 14:58:58 -0400

    How do you update it? Could you post code here? 

    -- 
Val Mazur
Microsoft MVP
"Stan the Mouse" <StantheMouse@discussions.microsoft.com> wrote in message 
news:EC4E8049-1721-4309-B69D-5A78CE5D33CE@microsoft.com...
> I've found out that the problem is I can not update the "date" into the
> excel, this cause the problem. any idea why?
>
> "Stan the Mouse" wrote:
>
>> I would like to use excel as a database to link up with
>> my web site. is that feasible?
>>
>> it seems that when I replace the Access by Excel, there
>> are always error messages regarding readonly or can not
>> write into the excel file.
>>
>> can anyone help me, please?
>>
>> http://stanleychan.myftp.org/asp/counter1/test-gcount.asp
>> http://stanleychan.myftp.org/asp/counter1/counter.xls
>> The code
>> http://stanleychan.myftp.org/asp/counter1/test-gcount.txt
>>
>> Many Many thanks
>>
  • Next message: Val Mazur: "Re: MDAC 2.8 vs MDAC 2.7"

    Relevant Pages

    • Re: Re: Q. Why do my dates appear as 30/12/1899 ?
      ... Hi Stan, ... You were indeed right: I wasn't passing ... Where are your Excel ... >exactly what the SQL string is, and how you have to fix it. ...
      (microsoft.public.excel.programming)
    • Validating data
      ... I want to make sure users enter a UK post code in a valid format. ... for AN NAA where A=letter and N=number. ... However, that's just one of the accepted formats for post codes, how do I get Excel to do an OR. ...
      (microsoft.public.excel.misc)
    • RE: Insert symbol menu
      ... It was introduced in excel 2002, for 97 and 2000 you can go here to Chip ... look for symbolize ... Peo Sjoblom ... "Stan" wrote: ...
      (microsoft.public.excel.misc)
    • address list
      ... one column in Excel. ... There is a blank row between every entry. ... The line before every tel number is always the Post Code ... The line before the Post Code is always the County ...
      (microsoft.public.excel.misc)
    • Re: Opening Notepad from Code
      ... You can write a text file directly from excel. ... "Stan" wrote in message ... Notepad, paste what is in the memory into it and then swtch back to excel as ...
      (microsoft.public.excel.programming)