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

Conversion of Excel Sheet -

Hi,
I am making an application,in which i have to convert the given master excel sheet to store the data in ms access(.mdb)

Any help!

Mohit

 

Conversion of Excel Sheet -
Hi, I am making an application,in which i have to convert the given master excel sheet to store the data in ms access(.mdb) Any help! Mohit

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

XL to CSV conversion problem -
Hai Friends, I have an excel sheet which has a column in TEXT format the data in that is like 09 03 05 Now i save this document as csv. then all 0's are get lost and it looks like below 9 3 5 I really need 0's infront of each val. Note:- after conversion, apply

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

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

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

How to convert scientific value of excel sheet column to number column in vb -
Hai Experts, I have two columns in excel sheet with scientific value (Eg:5E+11).I want to convert this value into number --like 500000(not specifically this no this is an example) using visual basic Can anyone of u tell me how to do this conversion process? Than

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...

.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

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

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

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

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?

Unprotect sheet VBA Excel -
Hi guys, I want to know how to check is the sheet is protected before unprotecting it. I cannot find the sheet property for this. Any idea?? Macro VBA Excel Thanks

Reading Excel Sheet Names into a Listbox -
I would like to take an excel spreadsheet and put the names of each sheet in a list box so that the user can select a sheet. Is there any way to do this without opening the sheet up? If not...how can I do this at all? I am not certain how to read the names of the sheets out. Th

VB and Excel -
Hi all again, I would like to make a small program so that I learn while doing it. I would like to input a lot of number and information in an excel sheet, and than I would like to access the data (read) from the excel sheet from VB and use it for sums. In other words, the excel

Excel and VB.Net -
Hi I was hoping somebody would be able to help me out with the following problem I am facing. Well basically I have worked with VB.NET Very little and require help with the following. In VB.NET I have a form in which I want to display some spreadsheets that I have created in Excel, s

Displaying data in the excel sheet -
Hi, i want to display the output of the query in the excel sheet. ex: i have location,sueit,floor,room once i give the value for location, sueits, floor and room details should be displayed in the excel sheet or excel control. pl help me regards hiran

import excel sheet: search -
Hi, In my application I want to import from a excel sheet. I wrote some code that imports all the data from the excel sheet into an dataset by using a oledbdataadapter. But I would like to create a dataadapter that selects specific rows in the excel sheet based on a the appearanc

Reading excel worksheets -
I have data to import from a users excel file. In my utility the user says what they are going to import and points me to an xls file Without using the excel object (which means excel has to be installed on the pc) is there any way of reading from a specific sheet in an excel fi

Excel...Returning values -
I have two sheets in Excel. Sheet1 has Social Security Numbers in Column A and there names in Column B. This sheet never changes. Sheet 2 is data that changes daily, but only has SSN's and no names tied to the data. So I want this sheet to grab the cooresponding names from Sheet 1

How to send an email in excel -
Hello, I am new to VBA programming. What I want to do is to write a macro in excel. There is a button in excel sheet, when I click the button, the excel will automatically send an email to all users listed from other sheet in excel. The context in the email is the cont

How to read Excel sheet -
Could any one help me how to read excel sheet. The excel sheet has some column header and the column values under that. How to read the column header and values in an single excel sheet. And also after reading that I have to save the values in Sql 2000 DB. I just want to how to

Excel Sheet Search From VB -
I am writing a program that inputs and exports information to/from excel VIA VB. I would some code in VB that allows me to search for a INSTR Excel Sheet function. For Example, I'd like to search for a sheet in Excel where the sheet has the word "March" in it. I figured i'

Creating Object -
I have a Excel instance from VB, using CreateObject. After populating data into Excel sheet from VB, I have closed the Excel sheet. When I try to invoke Excel instance for the second time, I couldn't populate the data. Everytime I need to close both Excel application and VB applicat

[02/03] Delete all rows in excel sheet, but one, through vb.net -
Hi all, I need to delete all rows in a excel spreedsheet, except for row 1, and do it automatically in vb.net with some code. Basically, the user enters some data in the sheet, I have it insert into a sql DB, then I want to go ahead and delete the values in the excel sheet for

macros...[resolved] -
Lets say I have an excel sheet with a set of macros. Now I do a save as and save this excel sheet with another name. I open this newly saved sheet and I see the macros are there from the other file. But why do they point back to the first file????? Meaning I already have the macros

Excel "Find All" -
What is the code in vb6.0 if i want to find a certain name or surname in excel, in all sheet?? because in Microsoft Excel their is no Find All..You'll manually find it in every sheet of your Excel and takes time to find...so i think if their is a code in VB6.0 that can find it in all s

How do I connect to an excel workbook -
I'm writing a grade averaging program for a public school system and I wanted the results to be printed in an Excel spread sheet with each classes grades in a different sheet. For example Teacher A opens the program clicks a button that opens a new sheet for their first class. The

Excel next row\column with header(Resloved) -
Hello everyone!, A few excel questions... I have no problems with opening excel and adding data to cells. However so far, the only way I've been able to do this is to assign each cell on my vb form to a text box. The only problem is I have an excel sheet with 1000 of names. I was