RE: Impersonate

Hi Zino,

I've performed some further research, I'm afraid so far the Office
Automation interface only provide file based save approach which restrict
the code in your application have to save the excel object to file
first(Unless you directly save excel object in database).

Sincerely,

Steven Cheng

Microsoft MSDN Online Support Lead


This posting is provided "AS IS" with no warranties, and confers no rights.
--------------------
From: =?Utf-8?B?emlubw==?= <zino@xxxxxxxxxxxxxxx>
Subject: RE: Impersonate
Date: Tue, 12 Feb 2008 06:22:04 -0800


the value to be displayed in the Excel file is saved in the sql table as
varchar(4000).
What I need is something like :

sub Page_Load
dim xl As Excel.Application =New Excel.Application
dim wbs As Excel.Workbooks=xl.Workbooks
dim wb As Excel.Workbook
wb = wbs.Add()

response.Clear()
response.ContentType = "application/vnd.ms-excel"
response.BinaryWrite((New UnicodeEncoding).GetBytes(wb )) ' it is
incorrect
this way, but that's how and what I need... .. (be able to pass the
workbook
directly)

response.End()


.

Relevant Pages

  • Re: Simple column moving code needed
    ... I am actually automating an Excel object from Access. ... Dim xlApp As Excel.Application ... Dim xlColPoint As Excel.Point ... ' Create a new chart. ...
    (microsoft.public.excel.programming)
  • Re: For Each DistListItem and Runtime Error 13
    ... Dim oDistList As Outlook.DistListItem ... and set a Restrict clause on it to filter only items with the MessageClass ... Dim obj As Object ... Dim oItems As Outlook.Items ...
    (microsoft.public.outlook.program_vba)
  • Error Unable to cast COM object of type System.__ComObject
    ... I am starting to get the following error occurring in my Outlook Addin when ... The restrict statement selection parameter is a user defined field ... Dim objList As New Generic.List ... " resetting folder please try again") ...
    (microsoft.public.vsnet.vstools.office)
  • Re: How to get Recurring Appointment dates with VBA?
    ... I wish I had known about Find and Restrict earlier:) ... association of appointments with contacts in the mdb. ... Dim ola As Outlook.AppointmentItem ... Dim oli As Outlook.Items ...
    (microsoft.public.outlook)
  • Re: Tab - Back Tab Question
    ... restricted Tab Macro. ... Dim aTabOrd As Variant ... Dim nTab As Long ... I’m using the below Macro to restrict fields of entry to the Tab only fields ...
    (microsoft.public.excel.misc)