I'm having trouble with the way I designed this little report I'm making. Is it possible to create a variable for a Range object in Excel VBA, for the purposes of applying the formatting to another Range? Here is my example: I'm creating a dictionary from the Microsoft Scripting Runtime library: Dim d as Scripting.Dictionary With t...
I need to use VBA to read rows out of Excel into another application, but if the process dies in the middle, I need to know which rows were read. Is the best way to put something in a column, per row, that says that row was done? Then save it after every row is read? Doesn't seem like a great way. Any help would be great. Thanks eve...
This is for Excel and VBA. Assume that BondClass has been properly defined in a Class Module. I get a #VALUE! when I type "=GetBondPrincipal()" into an Excel cell. Have I done something syntactically wrong or is this just not possible in Excel/VBA? I ask because what I really want to do is this: http://stackoverflow.com/questions/1354046...
Hi, I am generating report in excel sheet(which is coming from Microsoft Access). For 100 records, it can generate the excel sheet in 2 to 3 seconds. But, it takes 10 minutes for more than 2000 records. Is there a solution or is there any other way to generate report in excel sheet? ...
Hello everyone, I am using the following code to create Excel object using VBA. I am using Office 2003. I run the following code in classic ASP. Set myexcel = CreateObject("Excel.Application") Error message is, any permission needed to create Excel object? Computer - default permission settings do not permit the address LocalHost (us...
The following method of course works, but after a certain number of uploads (this is not constant) my client gets the dreaded error: "System.Data.OleDb.OleDbException: Unspecified error" Steps: Client uploads an excel file via a File upload control File is saved to the file system File is opened via the oledb provider and read into a ...
I am trying to write to an Excel 2003 spreadsheet using c# 3.5. However I am unable to get this to function correctly across different country settings. The country settings are either English or German. These two settings have different decimal and thousands settings. Everything works fine unless a user has changed the decimal and thous...
In excel workbook project, how could we detect if the filters on some worksheet are updated? ...
Hi to all, Does anybody know is there any tool that allows to automatically update products' prices and quantities saved in osCommerce DB from table-prices in Excel format? Thanks in advance ...
Hi, I have developed an console application in C# .net which creates a new excel & performs some operations in it [Interop]. I have added Interop.Microsoft.Office.Interop.Excel.dll as reference in my project The code works fine on XP & in Vista too. But if i keep my exe in one of the folder then it gives me excception Retrieving t...
I'm currently on a non-IT project that currently has data which requires some systematic analysis (mathematical formulas). The data is currently stored in Excel but it's a pain to manually enter/massage data in Excel to do the analysis. Would it be better to store the data in MS Access and use Excel to query Access? In other words, st...
I am trying to save a ListObject from a .NET 3.5 Excel 2007 VSTO Workbook to a new sheet (done) and save that new sheet to a new workbook (done) without that workbook requiring the VSTO customization file (!!!!!). Has anyone had any luck with this? The only way I've had any success is just saving as a CSV file but that's not exactly ...
Background I have a client who needs Excel VBA code that produces formula values moved to VB.NET. He is in the business of providing financial analytics, in this case delivered as an Excel add-in. I have translated the VBA into VB.NET code that runs in a separate DLL. The DLL is compiled as a COM Server because, well, Excel-callable .NE...
Can a standalone .exe be created from an excel file which has a few forms and macros? ...
How can I mannually terminate an excel application using OLE Automation? I would like to do this in some exception handling so that an excel process does not remain running if a function throws an error. Currently I use the below code to open excel: Variant excel = Variant::CreateObject("Excel.Application"); ...
I have an embedded Excel (.xls) file in a AutoCAD (.dwg) file. Using VBA (under Excel) I want to extract the path for the file that contains it (the path for AutoCAD file). ...
Hi I am exporting data to excel and try to save to a folder which is in my application...but the excel is saving defaultly in C:\Documents but i wanted to save in E:\Apllication\Reports Here is my code to generate excel sheet If ComDset.Tables(0).Rows.Count > 0 Then Try With Excel .SheetsInNew...
I've created an addin for Excel containing a number of different functions. Now, I need to create a user guide (a set of webpages will suffice) defining what the functions do; their inputs and their outputs. Are there any tools that will help me do this? Has anyone seen any good examples recently, or shall I just mimic Excel Help? ...
I am working on an excel report in CrystalReports, in VS2005. I have a field in the Details section which can have up to 255 characters of text, and I want the height of the row in excel to expand so that the entire text can be seen initially when the report is generated. I set CanGrow=True in the field's properties, and the field does ...
Hi, I have a project to upload the data in many excel workbooks, each containing many worksheets that all have different columns. Fortunately all the workbooks are in the same format. Is there a programmatic way to loop through these worksheets to export it into one flat file in XML or CSV? I have experimented with ETL tools, but all o...