Excel COM Automation PROBLEM in browser -
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. But when I deployed it in a server and pressing a button from a browser, an unknown javascript message alert appeared with no message indicated, hence the excel application failed to load from a client pc. Is there anything I can do about this? is there any authentication needed in a server or client to load excel application properly?.. thank you guys for your assistance..
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.
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
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
[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!
reading data from an excel file (in vb.net) -
Hi,
I'm trying to read data from a close excel file in vb.net 2003.
I can't find any specific functions to read the number of colums and rows there are, loop them, and read the values.
I tried looking in the object browser and on msdn, but I can't find anything useful.
Can th
Excel and Internet Explorer OLE function -
Hi folks,
I created a litte Excel VBA Program. The end user has to open a browser, go to a website. then he clicks on a button in the webpage in order to download some files in XLS format.
Some users have a problem with OLE functions:
Instead of having a message box asking him &qu
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
[2005] Problems with Excel 2007 Automation -
I want to create an Excel file in the server. Everything is fine when i tried my web application at Visual Studio, but when i tried to run from client side the process bar in the browser stuck (hang) at around 50%.
Code:
Excel.ApplicationClass oAppClass = null;
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
Internet Explorer Automation Help!! -
Hi, I am new to developing in .net
I am trying to get my Windows App to by selecting the correct user on my application to launch Internet Explorer and Login to a particular page.
What is the best way to go about doing this? I need to be able to open Internet Explorer, and the
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
Workbooks.Open -
I'm creating a CSV file, writing it out and then deploying Excel to open the file. I'm doing this over a browser-based intranet running VB ActiveX controls launched via ASP.
The problem is I know my syntax is right because I've been looking at web examples all day; however, when
Web Browser form & Excel Reference -- Error -
I have a MDI project where all forms are MDI children.
In this project I have web browser form.
I recently tried to reference Excel so I could use the
Excel object (in a different form) but when I did this I
received a "Procedure declaration does not match description of ev
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
Question about IE automation -
I'm new here.
Hello, everybody.
I tried to use WebBrowser Control to be a web browser,
and do some automation with it.
Navigating webpages, retriving form data, sending data to form,
pressing the button, selecting options in select... are OK, but
when the webpage has a scr
Microsoft Web Browser Control & Excel -
Configuration: Win XP, IE 6.0, VbB .NET 2003, MS Office 2003
I am developing a win application. It display a excel file in Microsoft Web Browser Control, a COM componenet. I do it as following:
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventAr
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
Problem with macros in Excel 2000 -
I developed an Excel 2003 spreadsheet with an embedded worksheet form button with an assigned macro written in VBA. The Excel file is hosted on a web server. User will open the Excel file from a web page via IE browser.
After deploying, we got some issues from users that it throws t
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