o
k
q
u
e
s
t
i
o
n
s
.
c
o
m

Return Excel sheet from Server to client -

Hello,

I am trying to show a report (in Ms-Excel format) in the client-side - but have the excel file in the server. I have a DLL that opens the Excel file and returns the same to the client. The problem is that the report is opened in the Server instead of in the client. Can anyone suggest a way to get out of this tricky situation?

Many thanx in advance
psdprasad

 

Return Excel sheet from Server to client -
Hello, I am trying to show a report (in Ms-Excel format) in the client-side - but have the excel file in the server. I have a DLL that opens the Excel file and returns the same to the client. The problem is that the report is opened in the Server instead of in the client. Can anyone

Excel from ASP -
Hi, I was wondering if it is possible to create an instance of Excel client-side, and from there, populate the excel sheet with some values. I need to be able to view a report i am creating in Excel on the client. I can do it on the server, but have failed to do it on the client.

Excel sheet thru ASP(Resolved) -
hi i want to create an excel sheet thru ASP. on server when the sheet create it will be downloaded by client... is it possible shich component/dll use ??? any tip thanks

Excel Spreadsheet Size -
I just got, via FTP, 4 Excel spreadsheets from one of my clients. Each file has four sheets in them. Three of the sheets only have a heading and the word NONE in the top cell. The other sheet has data from C1 to K40. Its size is 1,853MB - If I copy the data from that sheet t

Import Excel sheet to sql server using Vb6.0 -
Hi, I want to import excel sheet into sql server 2000 through vb 6.0 application. Is there any way so that i can directly import entire sheet to sql server / table. plz help me and if possible plz send me code as well.

An Excel Quickie -
Whilst either opening a new or existing excel sheet to add in data, it always defaults to sheet 4 (1 sheet after the amount of sheets in the xls.), ie when I create a new excel spreadsheet there are by default 3 sheets, so when I add a sheet and enter data it is on sheet 4, anyone know

Populating Combo Box from Excel sheet -
Hi, I am wondering if it possible to populate Combobox from Excel sheet. Excel file is available in c:\data\Database.xls Excel Sheet name: Component_List data is available in A2 to A15 of Excel sheet. Only problem is user should be able to add data after A15 also; but th

Startup Dialog Box -
I'm currently opening a excel sheet with a simple VBscript. However excel returns with a window which says remote data not accessible and would I allow excel to open the application. I would like to automate the process to when the sheet opens and the dilaog box appears it return back

no of rows one excel sheet could accomodate -
Plz any one help me in this regard ... I need to save data from my SQL server table to en excel file ... Now i need to know how many records could be accomodated in one worksheet ... If records get more than 1 sheet will it automatically move to 2nd work sheet or we have to control it

Writing data in multiple sheet in excel using VB6.0 -
In VB6.0 i am writing data from SQL Server to an excel file. I ve an excel file template in which i have to write the data obtained from the SQL Server. In this tempalte file there are three sheets. I was able to write data successfully in the first sheet. Now wen i start writting

how to write data into an excel sheet. -
Hi! With our firiends' help i am successfully reading the data into an excel sheet. but here i am facing some problems. (1) for every new excel sheet the range is to be set(in excel sheet: intsert->name->define->"selected range" .till now it is being d

writing to Excel -
I am trying to write to an Excel sheet some information. on sheet 1 I would like names on sheet 2 I would like addressess How can I save information on sheet2, sheet3, and so on. I used this but it only goes up to sheet 3 and I need more than 3 sheets: < Dim app As New Exc

HELP to export data in excel from sql server table -
Dear friends I m using vb.net 2008. I have created an application in which data is needed to be exported from sql server 2005 to excel sheet. i do not know that how can i export data from the sql server table to the excel sheet. Plz help me. Thanks in advance Shiv

Open Excel into a form in VB6.0 -
Hello, first I want to open an Excel-sheet with data into a form in VB. My questions are: --> How must I do that?? Must I add some components to do that or something like that? --> and then how I open an Excel-sheet in that component? --> and finally, how I

edit values in Excel via VB.NET -
hi, i have an excel sheet that uses my vb.net library. I want to write values into the excel sheet directly from VB.NET. I know how to open a completely new Excel sheet from VB.NET and write to it but how do I write into a excel sheet that is already open? Thanks for your help

Excel a C++programmer needs help -
Ok a mate of mine has asked for help, I can code this simply in C++ but have no idea how to do this in excel. I have two sheets in excel, I want to enter a value of 0 in a cell and have that cell return its left most row value to the other sheet at a specified cell. C++would say for(

Using a excel sheet in a form -
Hi. I want to use an excel sheet in a form and read the edited values in the sheet. First I inserted an "insertable object" Microsoft Excel Woksheet. However i can't access the values that the custumer puts in my sheet. I want to use something like: Var1=Sheet.Cells(1,1

Working with MS Excel Sheet Object in VB6... -
Hi, actually i want to put all of the records of db as : Select From table Where abc=xyz Now in Excel Sheet it will Put Results.... is it possible to generate MS EXCEL Work Sheet ? what ever is there is any other way to do that also... becuase i need it to be printable also...

Excel Function Help -
I have a Excel workBook with 2 sheets. Sheet 1 contains 2 columns. And the data is like the below. Activity code Status P1 In Progress P2 Completed P3 In Progress P1 completed P2 in progress P3 Yet to start Activity codes will repeat here. Sheet 2 contai

.close method for an excel sheet -
Hello what happens when you apply the .close method on an excel sheet does it remove all reference to the pointer of the excel sheet and does it also leave the excel sheet in not visible mode?

Accessing an excel sheet remotely -
VB studs, I want to write VBA code that will open an excel sheet chose an entry of the list created on this sheet and also click a button on this sheet. Should be easy, but I can't figure it out. Thanks in Advance, VO

Read Excel sheet and export data to SQL-server -
Hi group, I'm very new at ASP stuff and I enherited an ASP application, oh happy day. It uses VBScript to talk to a SQL-server. Can anybody advise me on the following: I need to read (once a day) a big Excel sheet and export the data on it to several tables in my SQL-server data

query result in variable or xla sheet -
Hi guys, I have created a simple xla which shoving me some data from our SQL server. Everything works fine, but I would like to set the destination from ordinary excel sheet range to somewhere else, xla sheet, variable, etc. At the moment the macro shoving me exchange rate of sever

Excel Sheet is Hidden. -
I am writing to an excel sheet behind the scenes. When I send the sheet to a user and they open it, they open excel but the sheet is for some reason hidden. Is there some code I could use in my save that would make the sheet open in normal mode when the user opens the file? thanks,

embedded excel sheet in vb -
Hi, I need the user to be able to edit a spreadsheet without all the excel menu commands at the top. I figured the best way to do this was to embed the required sheet into a form. However, when I do this, vb seems to resize the ole container based on the size of the first sheet in

Who Excel's in VB -
Hi Everybody, I need to capture some financial data from an Excel Sheet (which also has some formulas)... and put them into a SQL Server Database using VB.... The Excel data does not has any header... and also has formulas linked with other worksheets in the same workbook.... A samp

SQL Server to Excel -
I need to be able to return a recordset from an SQL Server then output that recordset to Excel. I can currently do this, but there is a problem. What ever version of Excel that I reference in my application, that version must also be on the client computer. The problem is that our u

How did Microsoft make Excel -
Hey, Does anyone know the framework for how Microsoft designed Excel? My understanding is that Excel documents are ActiveX documents. That makes the Excel program the ActiveX document server, right. Then, Excel also integrates VBA for running macros etc. That's easy enough.

Winsock Massager With Server -
I have written a massager program with a server and a client, the server acts as the 2nd client. There are a few things wrong with it, mainly there can only be one client, and when either the client or the server closes the other program goes to Winsock.State 8(I think) and can't conne

Limit cell length in excel thru ASP/VBScript -
Hi, I export some data on excel sheet and then use the same to import the updated data. Now I need to put certain validations on excel sheet. Certain cell on Excel should not accept the data more than 20 characters. I have added validations in ASP when I read the excel while impor

OLE Excel -
Question with OLE Control when using excel (linked to a seperate file): I have 1 excel file that had 5 sheets in it... i need 5 ole objects on 1 form, 1 for each sheet in my excel workbook.. the problem is i dont know how to make the ole object show a particular sheet.. they all sh

Select Excel files and import to SQL server 2008 express table -
Hi, Does anyone has a sample code that do like, Open and select excel file and select the exact excel sheet to import then connect to SQL server 2008 and append all the data from the certain sheet to the SQL table? Thanks.

help in vb excel sheet -
i insert an object in tool bar called excel sheet i put in the middle of my form here's my problem i want to load my excel document "book.xls" inside the sheet in the middle of the form. i see a code in internet but the code are always call the microsoft excel. how to put my

how to dispose excel -
in the VB program, i want bring up a excel sheet ( visible = true) and fill in some items, let user to print the excel. however, i don know how to dispose excel , if i use ... ... oExcel.Visible = True ... ... ... oExcel.Quit() System.Runtime.InteropServices.Marshal.Releas

Sending Mail (Excel Sheet) -
Hi all, Am in need to send a excel sheet as attachment through mail, Already i worked in mailMessage object. But From the excel sheet itself, the user will send the activesheet as attachment.. i thought of creating an ADDIN and insert in the sheet. Any other ideas .. its vb

how to dispose excel in this case -
in the VB program, i want bring up a excel sheet ( visible = true) and fill in some items, let user to print the excel. however, i don know how to dispose excel , if i use ... ... oExcel.Visible = True ... ... ... oExcel.Quit() System.Runtime.InteropServices.Marshal.Releas

Excel Sheet Into VB6 -
Is it possible to open an Excel spreadsheet from VB6 and extract certain fields from that spread sheet. We want to send, by e mail, to all our customers a spreadsheet which contains all their unique particulars, name address etc. if anything has changed they make the changes in the sp

excel displays unicode characters when open from web server -
Hi, I have an excel sheet uploaded to IIS server. When I try to open this excel sheet from browser it displays unicode or junk characters... Word and pdf opens fine... any help.. Thanks

How to validate cell value from sheet 2 sheet [Excel] -
Hi Am new to excel and want to know how to validate a particluar text contain in a cell in one sheet and want the result in other sheet. For ex in sheet 1 i have somelist like bug cleared bug cleared cleared bug bug cleared from this above range i want the ouput (How

excel sheet name -
I know how to use the Response.ContentType = "application/vnd.ms-excel" in an ASP page to display a <table> in an excel spreadsheet. My problem is that the name of the sheet is the name of my ASP page. How can I change the name of the excel sheet?