Excel automation problem -
Hi guys.
My english is not very well, i'm an italian boy
I have a program that use an Excel.Application object to populate an Excel worksheet. If i debug from Visual Basic or if I excute the program manually from "My computer" the exceution is ok. But I have to schedule the execution in a SQL Server DTS. In this case, command createobject("Excel.Application") raise this exeption:
The server process could not be started because the configured identity is incorrect. Check the username and password.
In a DTS, any eternal program is executed by the System user.
My OS is Windows Server 2003
Can you help me?
Thanks!
Macros that run macros from other programs -
So my company has developed a couple automation macros in Excel already and I'm developing some automation macros for PPT. Is there any way for me to code my PPT macros to utilize some of the Excel macros? For instance one of the Excel macros aggregates data then pastes it into the ope
OLE Automation and Excel... please -
Hi,
I'm new to OLE Automation. Can anyone show me how to:
1. Open an existing Excel file
2. Insert an empty row
3. Enter data in that row from my VB app.
4. Save the modified excel file
As always, thanks
Excel Automation Error! -
I am coding for Excel Automation in a .NET App . And there was the stuck telling me that " Old format or invalid Type Library. Line: Microsoft.Office.Interop.Excel".
I am using Excel XP and .NET Dev Environment 7.7.3308
Microsoft Visual C# .NET 69586-335-0000007-18357.
open excel workbook - ole automation -
How do I open an excel workbook using OLE automation.Although using Getobject and createobject, I am able to start instances of Excel apllcn., I have not been able to figure a way of opening an excel workbook.. say important.xls as parameter.
Any ideas
VB Automation - How to check if VB Automation possible -
I created a programme that vb automation to autocad and excel.
However my question is if my programme is being used in a computer which dont have either one of autocad or excel. What will happen when i try to contact that software ?
How can I create a query line to ask the computer
Excel automation stopped working -
For no reason that I can tell, all of my programs that use Excel automation now give "automation error", with various large negative numbers as the error number.
I have re-installed both MS Office and Visual Studio (the "fix previous installation" re-install in b
Library not Registered x Excel -
Hi,
I am trying to open an excel file using the Excel Automation, but although I have created the reference for the Excel 9.0 type library (using office 2000 and vb 6) I get the following error message after this line of code:
Set m_objExcel = New Excel.Application
Error Mes
Excel COM Automation PROBLEM in browser -
Hi guys,
I dont know if im in a right section to discuss my problem. Apoligize to all of you if ever..
I have this excel COM automation I created which will load an excel application when clicking a button from a browser. It executed properly when my web browser is in localhost.
[2005] MS Excel Automation -
Is there any walkthrough about MS Excel Automation in MS Visual Studio 2005?
I already use Automation in Excel using MSVS2003 but it takes aroung 10min to fill a worksheet w/ more than 1,000 rows from a dataset.
It is very slow because I insert text to cells 1-by-1, is there a way to
Excel automation / Naming Workbooks -
How do you name a workbook using Excel automation without using GetSaveAsFilename, or any of the save methods? The Workbooks.Name property is read only so I am hoping there is another way.
Thanks!!
Automation Of Excel/word Question -
If users here have office installed on their computers.. do I need to distribute any additional files if I add automation of excel or word to my app?
Dde Died -
Dear all~~
I am planning a DDE project, create a VB6 program communicate with excel and a PHP program. But some posts in this forum mentioned "DDE DIED" and replaced by OLE or Excel Automation?
Is OLE or Excel Automation more simple and powerful than DDE?
Thanks in advan
Excel Automation Anybody -
We are using OLE Automation. The Excel object does not get destroyed after the application has finished. This probably is happening due to the large amt of data being printed bcos if some less data is printed then everything wrks fine. Pls help us with some explanation or solution
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.
Automation Error Suggestions -
Can anyone suggest a fix to my automation error. I have writen a small application that records values to excel and when recorded, they are displayed on a form which is opened by clicking a command button. I am getting automation error -2147427851 - i'm assuming - if I click the button
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.
Automation -
How do you grab an existing instance of Internet Explorer for automation. I can create a new instance and control with no problem. Trying to GetObject(,"InternetExplorer.Application") results in error 429. I can grab existing word and excel applications with no problem.
Internet Explorer 5.5 -
Hi
I would like to know if IE 5.5 is an Automation compliant software?
Would it be possible to control its object through Automation coding jus like those office applications ( Excel,Access,Word ) ?
Thanks for the help!
problem exporting to excel... please help me.... -
Hi all,
I have create a program using VB6, I used Win XP & Office XP. The problem is when I used it in Win 98 & Office XP I can't export my data from VB to excel. Here is the source code:
Dim excApp as Excel.Application
Private Sub Form_Load()
set excApp = new Excel
Automation error opening an excel file -
I am trying to open an excel file using the following code:
Dim ExcelApp As Excel.Application
Set ExcelApp = New Excel.Application
ExcelApp.Workbooks.Open ("C:\ViaBancoPricingGrid.xls")
But I keep getting the following error:
Error #-2147417851: A
How to get earlier Excel Object Libraries etc. -
Hi,
I have written a VB6 application that uses Excel as an automation server. I have distributed this app to some other systems - it works fine except on a system that has Excel 2000 installed (all other systems have Excel 2003 installed). I guess that I need to reference the Exc
Excel Automation – Excel Attaches itself to my Excel Object! -
xlApp.IgnoreRemoteRequests = True (This is the solution to the problem below!)
http://www.xtremevbtalk.com/showthre...013#post997013
---
Hello All!
I am using Office Automation in one of my applications in order to read/write to an excel spreadsheet from a VB.Net applicat
[resolved] Automation error 430 -
I get run-time error 430 which is an automation error, this only happens on one machine and about 20 others are happy to run the offending programs without fault.
From debuging a program running Excel VBA I found that the error was directly caused when trying to create a record set,
[02/03] Enumerate and take control of MS Excel -
i'm writing some automated scripts for my firm that utilize excel macros to set up spreadsheets and control MS Publisher templates. the ms office side of the scripting is 100% done, and all that is left to do is automate the generation of thousands of reports based on these .xls and .p
excel automation via VB6 -
I have a vb application that runs Excel(macro) invisible to the user.
When I try and quit the excel app I get a excel dialogue box prompting whether I want to "Save Changes" at this stage I have already saved my work.
Can anybody tell me how to get rid of this Dialogue
help meee. excel object library -
i had vb 6 and excel 2000 installed in my machine.. found no excel object library in references.. then installed excel-97.. now found excel object lib 5 and 9..
my code goes like that
Dim objWrkSht As New Worksheet
dim X As Integer
Set objExcel = CreateObject("Excel.Applicat
another deployment problem -
hi,
i'm using vb.NET 2003, CR XI and Excel 2003 as database. I'm connecting vb.net with excel using automation. And to connect Crystal reports and Excel, i'm using DAO. My project is working fine. Problem is in Deployment. mine is Windows XP. I deployed the project and try to install
Automating Excel with VB6 -
Quickie... i got the whole automation thing going on BUT... when i load up the excel program from my program, it puts Excel on top of my program. I have to go to the taskbar and click on my program to bring it to the front.. Is there anyway to open up excel visibly (.visable = true) bu
Arrange date in excel using ole automation method -
hello,
iam trying this over a month, could anyone help me?
In the database dates are not arranged in an order.
Iam using excel sheet in ole automation method.
But I want to display the dates in an order in an excel sheet.
How to display the dates in an order.
If it is similar dat
Iterating Excel Instances -
I'm trying to use Automation in VBA to access a specific instance of Excel. I've been using the GetObject method to access Excel. However, it will only return the Excel object that was running first. Is it possible to iterate through all Excel instances so that I may find the specif
automation error in win 98 -
i've coded a program that will generate an excel format in windows XP platform.. But when I run it in windows 98 there is an "automation erro".Is there any patches I can use to solve this prolem?
Check instance -
I am automating word and excel using VB6. I am having a problem when i already have an instance of word or excel open and I start my automation. I need to check and see if word or excel are already open and if they are prompt the user to shut them down. Any help would be appreciated
VB.NET and excel -
Hi,
Basically someone told me that i can use automation to pull excel charts into VB. Can anyone help?
I haven't uses this before and would appreciate any help given
OLE using Excel objects -
The object of my code is to utilize Excel
objects to graph my data on a form.
Plus, I can change the title of the graph by
double clicking the title just like I can do
in Excel.
My question is:
1. Which method is the best? Using ole automation or other methods?
2. If OLE
Drawing Excel chart by automation -
I'm programming in VB and have an array with values, which shall be used for drawing a chart on a Excel sheet by automation.
The following code lines are functioning, but I would like to do it without first putting the values into cells on a sheet. Is it possible to do it easier and
Different Versions of Excel -
A few years ago, I came up with an ingenious solution to the problem of cross-tabulated reporting within Microsoft Access 97. As most of you will be aware, the cross-tab reporting function in Access 97 is fine, but if the number of columns increases by itself, you're left with unforma
Unload Excel Problem -
Dear all,
I have an VB app that use Excel OLE Automation. My program just open a text file, and save it in Excel format, then quit.
Dim xlApp as Object
Set xlApp = Createobject('Excel.Application')
...
' Open and save here.......
...
xlApp.Quit
set xlApp = Nothing
Howeve
Excel Automation Using Visual Basic 6 -
I have been trying to control Excel 2002 from within Visual Basic 6. I am working in VB6 and not in excel's VBA. I have had a liittle success opening and writing contents to a excel cells. Now I would like to get the contents of the highlighted cell and read it back into VB 6. I would
visual basic to excel on xp but not win 98 -
i have developed one application in visual basic to save datagrid data to excel 2000.
when i run an application on windows 98 to save my data to excel -2000 , i am getting "Automation Error". (Excel.application is not getting initialiezed, reason is not known)
But when i r
open mdb and excel with ADO -
Hi All
How can i open mdb files and excel
with ADO (i dont want to pen excel with
Automation)
Thanks
Efrat