I published my excel addins with clickonce on vs2010. It`s prerequisites contains .net framework 4 client,vsto 2010 and installer3.5. Deploying it on win7 works well,when I deploy it on xp,installing no error occured, but it(com) cannot loaded when run excel app. I tried mang mehods,only when I manually installed .net framework 2.0 or ...
I am making a spreadsheet that offers a column for user input. Each worksheet changes based on the month the user has given. If Target.Value = "January" Then ActiveSheet.Range("K7:K44").Value = ActiveSheet.Range("BA7:BA44").Value ElseIf Target.Value = "February" Then ActiveSheet.Range("K7:K44").Value = ActiveSheer.Range("BB7:BB4...
I have a survey from 100 users and I'm trying to calculate some statistics. The relevant fields in my survey look something like this: Gender Interests B1: Male D1: Running, Snowboarding, Mountain Bikes B2: Male D2: Programming, Running, Paintball B3: Female D3: Bowling, Gymnastics B4: Male D...
I need a macro that will copy a column from one worksheet and paste into another spreadsheet on every 5th row. I've tried using snippets of code, but I haven't found one that I can modify to make this work. Driving me crazy. I'm sure this is pretty easy for those who are more advanced with VB code. Anyone willing to help me out would ...
I am using the .Net 4.0 and excel 2003 How can i use an oledb connection to retrieve the cell format of an excel spreadsheet... I specifically want to find out if a cell column (or cell itself) is in a numeric percentage format. I cannot seem to find this information in the GetOleDbSchemaTable method. EX: My web app reads numbers from...
I'm opening an excel worksheet using the Microsoft.Office.Interop.Excel COM interface. I'm trying to adjust the "maximum" value of a scroll bar embedded into a worksheet. I can find the scroll bar with the following: app = new Excel.Application(); wb = app.Workbooks.Open( Path.GetDirectoryName(Application.ExecutablePath)+@"\template...
I am trying to display milliseconds in an Excel macro. I have a column of integers which are simply timestamps in milliseconds (e.g. 28095200 is 7:48:15.200 am), and I want to make a new column next to it which keeps a running average and displays the time in a "hh:mm:ss.000" format. I have tried multiple different routes, but I simply...
I'm using Watir to do some automated testing for a website. This particular test I'm pulling an array of sku numbers from an Excel sheet and then randomly selecting one from the array to use as my test. The number is placed into a search field and it pulls back my product. Here's my problem: I'm pulling the data from Excel and I pri...
My task is to get text to print and display though it is longer than the 409 point row show. The sheet I'm working on is a Destination sheet from a Source sheet that can change often, but generally only 1 of 15 cells present this problem. Cell parameters are fixed so I can't change font or column width. On a spreadsheet I've made a Ma...
Hi, There is a requirement to read multiple Excel "Lists" from one sheet in an Excel file. I need to know if there is an inbuilt method/api to obtain the dimensions of a list or deal with list specific data. At the bare minimum, is there a way of knowing the "headers" of the list and the number of rows contained in the list data? I wan...
I am writing a function to export data to Excel using the Office Interop in VB .NET. I am currently writing the cells directly using the Excel worksheet's Cells() method: worksheet.Cells(rowIndex, colIndex) = data(rowIndex)(colIndex) This is taking a long time for large amounts of data. Is there a faster way to write a lot of data t...
I have 7 columns that have a yes or no in them (N2-T2). I need an equation that will place a 1 in "AI2" if there is a yes in any of the N-T cells. In my previous work with Excel I have only used the colon in an equation if I am adding the cells. Is this correct or does it have more use? I tried the equation below and I get an error; #Va...
We use Excel interop in numerous places in our code, however I have one function which doesn't ever seem to close down the Excel process it uses.. I've simplified the code down, and it just seems like whenever I open a workbook in this function it stays hanging around. I've included the code below, I've made sure every object is defined,...
Hi, I was wondering if anyone knows of a C++ utility that can convert a 1995 .xls file (Microsoft Excel v7.0) into an excel file form 1997 or later. It doesn't need to be free. thanks ...
I have two columns, **COL-A** **COL-B** 1 419 393 2 2199 1513 3 3 3 4 23 20 5 3 3 4 2964 2181 I want to have conditional formatting using color scales between each A1 B1, A2 B2, ... Currently when compared, 419 is g...
I have a macro which runs fine on my machine but when I try to run it on another machine it gives the following error. Microsoft Visual Basic Run-time Error -2147417848 (80010108) Automation Error The Object invoked has disconnected from its clients. ...
Hi, I created a matrix with drill-downs and it doesn't have a subtotal in it. When I export this to excel, it automatically created subtotals both for my columns and rows. It's giving me what I am not seeing in the report preview. Is there a way to suppress this output in excel? ...
I have an excell fill with these data in it : Name1 1 2 3 Name2 1 2 3 4 Name3 1 2 ...... I want to have Names in a cell in front of each row below it like this : 1 Name1 2 Name1 3 Name1 1 Name2 2 Name2 3 Name2 4 Name2 1 Name3 2 Name3 .... is there ...
Hey guys, I am getting a very weird error when using VBA in excel. I am using LotusNotes Automation libraries to loop through a view and write everything to cell. Here is my code (variables of non-interest are removed as I know they are not causing the problem) Public Function TimeCh() Set session = New NotesSession 'create a new se...
What is the best way/library to read Excel 2003 and 2007 files using C#? I need to do some heavy parsing. ...