Using Excel in VB -
I've built an active-X component that uses the "MS Excel runtime library" to read from and write to different Exceldocuments.
So far so good...the question is how I gets it to work on a Server that do not have MS Excel installed.
To make it work on my own server I've just installed Excel, but there must be some dll.s or other files that I just can include in my installationprogram/package so that it can work properly without having to install the whole Excel-program.
Any suggestions? thanks!
/Fredrik
Excel won't go away -
I have a slight problem with my application.
When I export to my Excel 97 database through VB6, I can't open the Workbook again because VB6 never let it go. I have all the required items in the code (i.e. Excel.close False/True, Excel.Quit, and Set Excel = Nothing), but it still won't
Create stand alone Excel session from code -
Hi,
I open an Excel file from VB into Excel. Is there a way to then 'disconnect' my program from Excel so that, if my app closes or has a problem or the user wishes to perform other functions, Excel is unaffected.
Excel Application not closing -
Can anyone help?
I have an app that outputs to Excel. However, it sometimes appears to close the Excel Object when it has finished.
However, there is still an excel.exe process listed in task manager, which has to be manually terminated before Excel will successfully work properl
Excel Object Crashes non-XP systems -
I am creating an Excel object in my VB6 app. My development machine has Excel 10 (XP), and so I set a reference to "Mcirosoft Excel 10 Library" and then do this:
Dim xl As Excel.Application
Private Sub Form_Load()
Set xl = New Excel.Application
xl.Workbooks.O
2 Instances of Excel Object using 2 VB Projects @ same time -
Hi,
I am using VB 6.0 to automate some reports in excel. For every report there is a new VB project/VB executable.
My Program does following;
Creating a reference to Excel.Application object
Opening an excel template
Putting data in excel worksheets
Saving excel
loading Excel -
Hi
Im trying to load Ms Excel on clicking a picture. It seems to be getting something going on click but the Excel Application never gets loaded. Below is my code which seems okey for me. But sure something is wrong. Can somebody check it out for me pls. The reference is there o
Export to Spreadsheet, w/o Excel -
I see a few tutorials pertaining to exporting data into an Excel spreadsheet. Looks straightforward, however I do not own Excel. I use Open Office (hey, it's free). I'm able to open Excel spreadsheet within Open Office Calc. However when I write my code, and I goto reference Excel,
Kill Excel -
Hi All,
can anyone tell me if it is possible to call a function from VBA that will kill all open occurences of Excel. I have an app that opens Excel and outputs data, however I am being left with the odd open excel process in the task manager even after Excel has been closed.
I w
Loading in Excel Worksheet -
I have seen examples of declaring Excel Worksheets etc..
e.g.
Dim xlApp as Excel.Application
dim xlWorksht as Excel.Worksheet
etc..
But when I try this there is not Excel class
What do I need to include or do to make this appear.
Thanks
Export to Excel Help Needed -
I am developing in Excel using VBA - but will use Visual Basic 6 later. I am using MSAccess tables as a backend and select statements to return data in Excel VBA. I need a way to export to Excel from VBA in Excel or VB code. Can you show me an example? Thanks in advance.
Excel formatting in VB -
Need some help guys, how do I programmaticly format column 2 and 4 in an excel worksheet to be a number without a decimal place?
I am using the following objects..
Dim xlApp As New Excel.ApplicationClass()
Dim xlSheet As Excel.Worksheet
Dim xlBook As Excel.Workbook
Many t
Hook Excel ActiveX -
I have an 3rd party ActiveX written specifically for Excel which links a Server to Excel. The ActiveX updates certain row/columns based on user designation.
I would prefer NOT to use Excel or have Excel open, but bring this data into my own application for data manipulation.
QUE
simple Excel Load question -
Hi
Im trying to load Ms Excel on clicking a picture. It seems to be getting something going on click but the Excel Application never gets loaded. Below is my code which seems okey for me. But sure something is wrong. Can somebody check it out for me pls. The reference is there okey.
VBand Excel -
I'm using excel file format to save the contents of the grid
but Excel isrunning at the background even after the application is exited
viz.
I declared as 'xl' as excel.application
and 'ws' as excel.workbook
after all the processing is done
I did
ws.close
xl.quit
These state
keeping a toolbar on top of excel at all times -
Hello everyone,
I have a form that acts as a toolbar for Excel. You control excel by using the buttons on the form. I was wondering, is it possible to always keep the form on top of the excel application, so that when the user clicks on excel, or enters data into the excel sheet,
Excel Problem! -
im having a problem in running the excel in vb... i used the macro for generating the excel in vb... this is my problem... i run the vb and press the command button that contains the excel code and the excel appears and run properly and after it, i close the excel after generating the
Excel Workbook File Reading from WebForm -
Hi
I need to be able to read an excel document from my vb.net aspx page.
I have searched around the internet and it seems i need to create an Excel.Application object
I have set a reference to the com excel 11 object
however i am having no luck as it says Excel.Application is not
Referencing older version of Excel -
Hi all,
I am developing a WinForms app that will be accessing Excel. The problem is that i have a Excel 2003, and the client has Excel 2002, and I dont have a reference to any older versions of Excel. The only COM components i have for Excel are:
Microsoft Excel 11.0 Object Lib
help:- vb <-> excel -
i've no idea of using excel as database in place of access....pleace help me with some code on how to read and write data from a grid to excel using ado.....
also ..i've to use some functions on excel like cell color change, cell font change, cell border, INSERT PIC FROm VB PICTUR
OLE Excel Usage -
Hello,
I have to integrate a Excel Environment in VB Application, & be able to create & update different instances of one or more excel files.
Can I use OLE Container for this. How can we add the worksheet control to the tool box? I just want to try both these ways of w
always keeping a form (toolbar) on top of excel -
Hello everyone,
I have a form that acts as a toolbar for Excel. You control excel by using the buttons on the form. I was wondering, is it possible to always keep the form on top of the excel application, so that when the user clicks on excel, or enters data into the excel sheet, t
Excel RESOLVED -
Is there a way to get the names of the work sheets of an EXCEL workbook without using an EXCEL Object? I don't want EXCEL having to exist on a machine to be requirement.
VB5 nd Excel 97 -
Have added a reference to Excel 8 to a project, which during execution loads data and creates an insistance of an Excel Worksheet
Two problems
1) When using the application generator asks for a reference to EXCEL8.OLB, (where do l find this).
2) When the operator uses the FILE-&
VB .Net & Excel Reporting -
I have created some Excel templates and an EXE that opens them, get data from a DB, writes it and saves it. It works great on my machine because Excel is installed on it.
I need to move the code to a production server where excel is not running, what are my options? I am making us
Using Excel -
Hello,
Just a quick question. How can I use excel with my VB Application ? I have an excel file but I dont know how to incorporate it with my VB apps. I know how to do it with MS Access but with Excel I can't. May I ask for your suggestions and help on this one, quite need the info.
Maybe Simple Excel Question(s) (RESOLVED) -
I automate excel from my app. I do not want the user to be able to close excel by clicking on the 'x'. How can I prevent that?
Also is there a way to eliminate all toolbars from Excel. Just a boarder and cells.
Kinf of advanced thing on Excel -
I am using this:
On Error Resume Next
Set e1 = Nothing
Set e1 = GetObject(, "Excel.Application")
If Err Then
'Excel isn't open so...
Set e1 = New Excel.Application
I am using this to get an instance of Excel. When Excel is opened and I execute that co
exe program that includes excel sheet does the user have..... -
I have a quick question, I am making a program which calls an excel sheet located on a cd, eventually I will convert the stuff on excel to java : ) but until then its on to excel and back to the question. Does the user have to have microsoft excel inorder to run the program, since it u
Excel.EXe Object -
oXL.Quit
Set oXL = Nothing
Should do the trick. Are you sure you are opening only one instance of Excel? Sometimes people have both:
Set oXL = New Excel.Application
set oXL = CreateObject("Excel.Application")
or something similar and they actually open two instan
Killing Process [constraint of timestamp] -
I have a Class file deployed on Win2000 Server in form of a DLL which generates Excel Report.
Many clients can generate the excel report concurrently. Sometimes one or two of the Excel process gets hang up.
I need an application in VB which only checks for the process "Excel
Populating Excel -
Iam trying to populate an Excel sheet using the COM MS Excel Lib10.0 using the following code:
Excel.Application a = new Excel.Application();
Excel.Workbook wb = a.Open ("C:\book1.xls");
Excel.Worksheet ws = wb.Worksheets.Item (1);
ws. Cells [2, 1].value = "YOUR
Excel just won't die -
hello,
I'm starting excel using:
Set xlsApp = New Excel.Application
With xlsApp
.Visible = True
.Workbooks.Add
I'm trying to end it with this:
xlsApp.Quit
Set xlsApp = Nothing
Excel disap
how to create progress bar in Excel -
I did some search before about this problem. They are using ProgressBar1, but when I put it in my Excel macro, it just doesn't recognize it.
Is there some setting I should do before I use ProgressBar1 in the Excel sheet? Or how do I show the progress bar when I run the code in the
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
Excel sheet will not open after running my vb6 code -
Hello,
I am running VB6 code where I handle some Excel files. After closing my VB6 program, my Excel file won't open - I have to go to the Task Manager to close EXCEl EXE. Obviously, I am not closing my Excel session correctly. What is the correct way to release Excel ?
Thank you
Exporting Excel application to another Excel file -
Hello,
I'm somewhat of a novice to VB, and I have a question...I am trying to export a formula-driven Excel chart into another Excel document with no formulas (i.e. values only). Furthermore, I would like to be able to automatically generate the filename AND sheet name of the export
Excel Tip For Newbies -
There are Alot of questions posted about how to do certain things with Excel.
One of the best ways to find out how to do automation with Excel is to record a macro, and look at the code Excel Generates.
just my 1.99345 cents worth.
implement VB on Excel -
hi !
i want to know where i can find information for implemt VB on Excel .
for example :
1. how i connect to the excel file ?
2.how i import the data ?
3.write to the Excel .
4.refer to specific sheet in the *.xls file .
.
.
......
I know how to work with SQl but
Exporting to Excel (No MS Excel on Server) -
I am binding a dataset to my GridView. I want to Export it to Excel. Server does not have MS Excel and we cannot install it. All the Client Machines will have MS Excel. How to start about it? Any Article to start with?
Thanks
Starting minimized Excel -
Hello
I have a written a VB app that processes data and then dumps the data to excel. The app starts excel with:
Set Excel = GetObject("", "excel.application")
these functions start excel as a seperate application(in case I already have a session of excel r