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 codes and press the button again to generate the excel but the problem is, after the first time i run it... it doesnt generate the excel, the only thing that is happening is the excel window appears (doesnt show the sheet or the workbook) and the excel will close...
can someone give an answer to solve this problem??? thanks!
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 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
Excel won't go away after using Selection -
Hello,
I've got a problem with Excel which is really winding me up.
I've worked through quite a few similar problem reports in the forums but to no avail ...
The problem is that the following piece of code will leave an excel process running until the application is closed (i.e.
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.
Trying to use excel w/vb adding reference -
Hi,
I'm trying to use excel with vb. I would like to import a set of test points and then use it to control some of my equipment in the lab at work.
I read another thread that said you had to first click on it in the references under the project menu. The problem is I don't see any
Controlling Excel with VB -
Hi Guys
I am having a problem trying to write some data to Excel using VB to control the excel application through an Excel.Application object.
In fact the problem only appears when the my program is running under W98.
The problem is that the program uses Excel to export some
Automating Excel from VB -
Hi,
We are facing some problem while automating excel application with Visual Basic. We are addressing the problem below and want to share your expertise to overcome the problem.
The requirement was: We need to write to an existing excel file (different sheets) programmatically
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
create and edit file in excel from VB.Net -
Hello, people!
I need to ask for help. I am wirting a programme that would read the data from a text file, manipulate it and then put it into an excel file.
I have been digging through google for a while now and I just can't find any sort of explanation for my problem.
The VB.
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
VB6 / Crystal Reports / Excel problem..Help! -
Hi,
I'm a beginner here, but I've inherited an application I'm having a problem with. Thought maybe someone could give me some guidance. Application uses this:
CrystalReport1.Destination = crptToFile
CrystalReport1.PrintFileType = crptExcel50
Everything worked OK until user PC'
Visual Basic vs Excell 8 library -
I create a Visual Basic program who reads and writes within an Excel file.
The Visual program instances the Excel Object.
I use Excel to manage the data and the VB program to calculate and to write the result within the Excel file.
The calculation is mathematical and use an Access f
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
Losing Excel format ;-( -
Hi,
Is there any way of locking the excel object created thru VB.I am facing a strange problem.If an excel object is open and when data is written to excel thru vb the formatting is lost.
Thanks,
Vyvi.
Printing Excel doc from vbscript -
I am currently working on script that will allow the printing of the word/excel document on 2 different printer at particular time of the day. However, the problem is that
how can I do it using the Excel.Application Com object as MS-Excel is not installed on the machine. Can someon
Exporting Data from Access Database to Excel Worksheet -
Hi,
I have one query regarding exporting data from Msaccess to Excel workbook using Visual basic
Problem Definition:
We have got some data in the MSAccess Database. Now we want to display this data on the Excel worksheet. For displaying these data on the Excel
(Resolved)Connection to Excel (Version problem) -
I am doing an export application from Excel to a SQL database.
The excel file is a download from SAP .
My connection string for the Excel worksheet
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\mcs\currentexport.xls;Extended Properties="";Excel 8.0;HDR=Yes;MAXSCAN
Extracting fields from Excel -
I am trying to access a field in excel that will determine if something passes or fails(which I have a field in excel that tells me if it does). After I find the ones that fail I am wanting to open the folders that corolate with the one that fails and pull out the data that tells me wh
Excel.exe Process -
I am using an Excel application in my program like I have many times before. This time however I want to leave the workbook open for the user. Here lies the problem, when I am done in the program with Excel I set the Excel.Application and Excel.Workbook objects to nothing, but even aft
Excel and Datagrid problem -
Hi,
I am loading excel sheet in a datagrid and the data is somehow not showing up properly. My connection and datatable is working ok. The first row of the excel is somehow giving weird data.
I am pasting the excel sheet (only to rows) as against what is showing up in the datagr
** SORTED ** Exporting straight to Excel -
Is it possible to export straight from an ASP application to an Excel document. All the data is stored in SQL and I can link to the database through Excel no problem.
I just want to click a button on my site, which then opens, updates my excel sheet?
Opening Excel Problem -
Hiii
I am using the following code to open up a Excel worksheet
(I have included the excel type library in the project references )
But still it doesnt open the file. It doesnt give an error messages also.
Dim xlTmp As Excel.Application
Set xlTmp = New Excel.Applicatio
Excel Reference Problem -
Seems like a lot of people want to automate excel thesedays.....
Anyway. I'm having problems with my Excel reference working in my program. I've added the COM reference to my project, and Imported Microsoft.Office.Interop.Excel and Microsoft.Office.Core at the beginning of my code
Excel crashes -
Hi all
I have Windows XP SP2 and Excel 97.
I have an excel application that was built in NT and Excel 97.
When i try to open that application in XP SP2 it dispalys an error msg "Excel has encountered a problem and needs to close sorry for the inconveninence caused" and i
Excel - Object Problem -
I use this Code to open a new ExcelApp. It all works
fine. But if I try to call this procedure twice an error
is produced. Tha Cause is that the first excel.exe is still
listed in the Taskmanager.
Dim xl As New Excel.Application
Set xl = Excel.Application
.
.
.
xl.Workbooks
detect excel version for an addin -
Hi i have used the built in addin template of vb and i have created an excel addin .My problem is that in the developing machine i have installed excel 11 and i want that plugin to run at excel 10 ,9 how could i make it so?
thnks
embedded Excel window -
I have an OLE window in a form. I have opened a CSV file in the window , which opens an Excel Sheet in my OLE window. The problem is the Excel window is longer and wider than my defined OLE window. I would like to make the Excel window fill the OLE window without going over. How ca
Integration with excel - Please help!!! -
I'm tearing my hair out over this. The following code opens a file within excel and moves to a specified sheet:-
excel.Application.Visible = True
excel.Application.Workbooks.Open ("d:\cats\aut2002\cats.xls")
excel.Application.Worksheets(named(0)).Select
The problem is
excel reference problem -
I made a sub to export some recordset stuff to an excel file. to do this i added the reference to MS Excel 11.0 since I have office 2003 installed.
In the code I use excel like this:
Dim xlApp As Excel.Application
Dim xlBook As Excel.Workbook
Dim xlSheet As Excel.Worksheet
Se
Export to Excel File Type -
Can anyone help us out please.......
We want to save a file as an Excel File Format. The problem
we have here is we don't have MS Excel installed. Without
having Excel we would like to create a File that is of Excel File Type. So that we can open this file directly using some
VB 6 and Excel 2002 -
Hello...quick question:
Is there a way to code an excel object so it is not utlized when clicking on an excel workbook?
I am probably wording that incorrectly, so let me tell you what my problem is:
I created an app that creates/fils out an excel report for me. It does this in
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
I think I know the answer -
I'll bet you 100 to 1 I know this one! I've had the same problem and just found the answer an hour ago! In work I've got megamemory and at home just 64.My program crashed after the 1st pass through excel at home; at work 4 times. The problem is if you create excel as an object and clos
[2005] Accessing excel checkboxes -
Hello everyone,
I am having a problem with VB and Excel -- by problem, I mean I haven't the slightest idea of how to do something. Using Visual Basic .Net 2005, I have accessed a Database, and I have read from it. There are several true/false values, and with those values, I need to
Exporting data from MSAccess to Excel workbook using Visual basic -
Hi:
I have a query regarding exporting data from MSAccess to Excel workbook using Visual basic.
Problem Definition:
We have got some data in the MSAccess Database. Now we want to display this data on the Excel worksheet. For displaying these data on the Excel w
trying to write to an Open Excel spreadsheet -
Hi all. In my VB project, I've managed to capture a recordset from a SQL query and export it to Excel, opening a new Excel workbook on the fly. I've discovered Excel macros and it has made life wonderful for this project.
My problem is that I have a loop created, which grabs new na
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
if we can convert our msflexgrids to excel -
I have a problem on printing grids. When I search the forum I saw that there are a lot of person dealing with the same problem . And if it is so difficult, is it possible to convert our grids to excel file format. Anyway there is no printing problem in excel.
Excel Macro VB -
Hi
i have the following problem:
I need a macro for checking a excel-file and read all lines out into a new .txt file. The cells should be checked if there is a free space in the cell and these should be deleted.
I am using Excel 97 and hope here is somebody who can help me w
.Net and Office calculate wrong -
Hi,
There is a big problem in how all Microsoft products handles substractions. When you subtract two values the outcome is wrong.
This problem is found in VB6, .NET2001 and VS2005 as well in Excel.
Try this in Excel:
=79,8-84,2 and =79,7-84,1 both should give -4,4 but they give