Hello excel-world, im interested to implement something but im not sure if it would be possible and would like your intake on it. here is my scenario: i will have two validation cells which will be shown as List that I will pick from. those are my condition that i would like to meet and ommit my list from a database. I have a list of...
I developped a VSTO SE Excel 2003 add in. When launching and debuging the add in from visual studio, it works well. But when I try to deploy it from my own install it never works. To sum up, here is my install process: the files are copied at the right location I register the addin: HKEY_CURRENT_USER\Software\Microsoft\Office\Excel\Ad...
Excel sheet is subtitled but need now to do a count of the items in each grouping so need to find subtilted rows by using a macro and count the number of items in each grouped section (column a) placing the count value in the relevant subtitled row in Column A. no idea where to start can anyone help. Running the subtilteld function aga...
I need a macro to do this please - any know where i can find one? Find a column with specified text and then search rows for zero enries and delete whole row if zero found ...
I have an excel add-in that keeps coming back when I start excel, even though I've removed it from the last open instance of excel (yes I checked the processes in task manager). The critter even shows up when I start excel in safe mode. Anybody else had this? ...
in excel 2003 row,column addresses are specified like A,1 and C,12 but in excel 2007 this format changed to integers like 1,1 and 3,12 is there any built in support for converting old address to new one or is there any custom algorithm to convert these values. thanks in advance ...
Greetings one and all - a christmas puzzle for anyone still looking at this site...This works but if i decide to cancel the process (ie not save a file and stop the process at this stage) it doesn't svae the file but the following marco (filltolastrow2) is still activated how can I stop this happening? Public Sub SaveaCopyIncomeSheet() ...
I am trying to dynamically get the range of cells in Excel using VS 2005 vb.net. This works oRange = oSheet.Range(oSheet.Cells("A1"), ("U281")).Select, but "U281" will not always be the last cell in the range. So how would I dynamically get the last cell with data in it with the same format as U281. Thanks, Lora ...
Is there a way to hide Excel windows from a user - to prevent acidental closing it. ...
I have a calculator built in Excel 2003 in which you select options from a drop-down menu, data is then gathered and calculated returning your total cost to produce that package of items. What I'd like is to cycle through all the combinations of this drop-down and automatically return the total unit cost to another cell. I have already...
I'm trying to replicate a formula from an Excel worksheet onto an ASP page, but having copied the formula over I'm getting different results (in fact an error because the ASP ends up trying to square root a negative number). Surely Excel handles operator precedence the same as classic ASP? The formula I'm trying to replicate is a simpl...
Hi, I have a C# class library project for an automation add-in for which I have created a Visual Studio set-up project. When I run the installer, I want the add-in to appear in the Excel automation add-in list (Tools-->Addins-->Automation Addin) so that I can directly include it in my Excel application. How do I go about it? I created...
There appear to be a number of suggestions to do this, non of which appear to work. Effectively, I'm wanting to change a text value in an Excel sheet to a number (this is a cell that has been set as a number stored as text, and has a green diamond next to it). This webpage details how to resolve the issue in Excel, through the UI, and ...
There's a PrintOut method in Excel that prints stuff. It accepts a printer name as a parameter, and that printer name is not just a system printer name, but a combination of both system printer name and port to which the printer is connected. .PrintOut ActivePrinter:="MyPrinter" & " on " & "Ne00:" If you only provide a system name, Ex...
The worksheets have hundreds of rows with account numbers in column A, an account description in column B and totals in column C. I want to copy the rows from all 3 worksheets into a single 4th worksheet but where duplicate account numbers are found, I want there just to be one with the totals aggregated into column C of that row and the...
I realize that generally speaking I'm quite a bit of a newb, but here's what I'm trying to do: I have a sheet in Excel with all the details of the participants in a conference I'm organising. I want to send them all a letter with their personal programme. Using MailMerge (MS Office 2003), I can easily import their address-info into a ba...
Hi, I have an excel sheet with TextBoxes and some text in it.(There are around 60 text boxes) My requirement is that i need to assign an hyperlink to a cell which links to a particular TextBox specified in the hyperlink, but i am unable to give link to a TextBox , it is only allowing me to give link to a cell reference but not to a Text...
Ok, 2nd attempt at writing a Stack Overflow Question, so forgive me if this seems familiar. I am rewriting an Excel Macro that was built over a 2 1/2 year period, frankenstein style (added to piecemeal). One of the things I need to do is load the data into an array once and only once for data accuracy and speed. For my skill level I...
Hi, I am having a problem getting pastespecial to work. Here is my code: osheet.Range("C2").Copy(.Range("C3:C" & endRow)) '**end of data osheet.Range("C:C").Select() osheet.Range("C:C").PasteSpecial(Paste:=Excel.XlPasteType.xlPasteValues, _ Operation:=Excel.XlPasteSpecialOperation.xlPasteSpecialOperationNone, _ SkipBlanks:=Fal...
Hi, i am looking for a 3rd party utility pack sort of library for .Net to handle excel merging with formating, formulas, charts and etc. which does its job well and if possible fast. ...