2,270 Topics
I want the vba coding of the formula SUMIFS in MS-Excel 2007, so I can copy the code and paste it in the Module of MS-Excel 2003 to use the formula in this version. [url=http://damdamalakeresort.com/]Damdama Lake[/url]
I have MS EXCEL 2k3 problem: On my previous post I have the NOT the INTERSECTION of 2 sets of data using VLOOKUP() where is the equivalent function of INTERSECTION in Discrete Mathematics. Right now I was looking for forums if Excel has the ability to combine 2 sets of …
Problem: I have a version of 2003 of MS EXCEL for example I have Line A and Line B in the same work sheet the DATA of Line A has a b c d e and f the data of Line B has b and d only if I use …
I dont know where to post it, but this is the reliable help from geeks I've known for several years Problem: I have a version of 2003 of MS EXCEL for example I have Line A and Line B in the same work sheet the DATA of Line A has …
Heyy I have been creating Macros and then adding them to the customized ribbons on excel (2010). The problem I have is that each time I rename the original file (save as) that i created the macros and ribbon in and then click on the ribbon/macro it automatically opens up …
Hey guys i'm trying to figure out how to open a new message window from outlook when i click a button on my form any help greatly aprreciated thanks.
hello,i have an issue with excel 2007 i have 3 column a b c i have made sort for the column a from a-z and i save the sheet and shutdown the computer. the question here how can i sort the column b and c according to colum a or …
I try to export my tables to excel in multiple sheets but i'm having an error state that object variable or with block variable not set. Hope anyone can help me. Here's my code. Private Sub exportexcel_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles exportexcel.Click Dim del_cmd As New …
hi l wanted to ask if it is possible to view multiple MsWord documents in single page (), like what you are able to do with PDF Complete were you are able to open multiple pdfs and they appear in one page/ document as TABS.
I am trying to send Data from text boxes in my windows form to specific cells in excel. I am forgetting to do something because i keep getting this error... Error 1 'ExcelWorkbook1.ThisWorkbook' does not contain a definition for 'textBox1' and no extension method 'textBox1' accepting a first argument of …
Is there a way to remove blank worksheets from an excel report that is generated in SSRS? I've done some research and i could find solutions such as removing blank rows and even entire sheets but only via marcor's in excel, which won't work in my case as the report …
Just wondering if anyone knows how to not save a document after creation when using Microsoft.Office.Interop.Word. Basically i am using mail merge to print off a report from c#, the document get made, values are passed to it no problem and i can then print it without any issues, however, …
I want to delete specific values from a column in excel, without deleting the cells themselves i.e the contents of the cell if the content meets certain conditions. In my case I have a column of almost 0.5M cells & I want to delete the contents from the cells which …
I want to delete the contents from cell if the content of that cell are similar to the content of the previous cell of last column. i.e If the 10th cell of column 'A' & 10th cell of column 'B' have the identical content then I need to clear that …
Hi Guys.. Can any experts in Excel/C# Help me with this one? I think I'm nearly there. Currently I have a DGV on a windows form which pulls data from a Datasource. I want to export the findings to and Excel report template. I've managed to export the data into …
Hi guys, i was wondering if there is a way to link a word document to a picture button in InfoPath 2010? if so how do i go about it? Thanks
Hi, it's me again.. I have this codes wherein I can export the data from the databse to Excel.. I get a **Notice: Undefined variable: aData** on one of the php files.. well two of them actually.. The weird thing is... The other page which I have modified - i …
Hello, I want to re-arrange my existing macros in the excel file. I have a macro which goes to the specified sheet and checks column R if there are commas. If it finds the commas it replaces it to dots. Column R is called Email. But in some of documents …
Hello. I would like to ask for a help. I deal with excel spread sheets and very often I need to amend specific column. The whole steps look like this: Step 1. Find the column name, Step 2. Mark the all populated rows in this column, Step 3. Proceed with …
Hello guys, I would appreciate if you could help my on the below issue. When i used an Excel object in my code, when closing this, the excel.xls applicataion remains opened at the task manager. i am copying below the test code for your reference, which i am using in …
I tried to install Microsoft office 2003 on my computer but I get the error message saying setup cant continue installation source has been corrupted. I've tried updating the maximal parser file as advised by Microsoft website but still have the problem. I'm using windows 7
Hi i am trying to write the contents of textboxes to a spreadsheet. The code i have does work but at the moment i have to specify what cells to write to. What i would like is for the text to get written to a different row each time but …
Hi everyone i have a connection to my sheet like this Dim da As New OleDbDataAdapter("Select * from [EBU 2 LOB$]", con) but i want to use this Dim Sheet1_EBU as string = "EBU 2 LOB$" so that the code will be something like this i think? Dim da As …
Hello, I have an excel where I will select a Currency dropdown (USD,EUR,GBP,SGD). On selecting any one of the currencies, I need to change the currency symbol in multiple cells where the amount is entered. My Drop down column & Amount column looks like this; CELL LABEL CURRENCY B5 Currency …
hi all i am reading excel file from c# into dataset everything working fine but the problem is it takes first row of excel as header's of column and i have "TRANSACTION DATA FOR CDs MANAGED BY TCBILs FOR THE MONTH OF DECEMBER 2012" in first row of excel ant …
Hi everyone, I need suggestions. A little corporate needs to track its data with 2-3 employees making a daily data entry/updating of few records (20-30). Data must be available to other employees. They want to store data in a SQL Server db that has been already implemented. The whole db …
Hi I have a textbox and a button on a html page. On click of button I want to save the value in the textbox to a particular cell of the excel file I have written the following code [code] var ExcelSheet = new ActiveXObject("Excel.Application"); ExcelSheet.Workbooks.Open("D:\\TEST.XLS"); // Make Excel visible …
I just setup a new Dell computer running Windows 7 64-bit copied over the data using Microsoft's Easy Transfer then installed Microsoft Office 2007. However, now when opening an existing Excel 2007 spreadsheet, Excel appears to hang for over a minute before any changes can be made. Are there specific …
hi, I have a sheet name 'rate' and another sheet name "master". rate sheet has data as below EmpCol1 rateCol1 a 1 b 2 c 3 etc... and master has data as empCol2 rateCol2 c a b What i want to do is to get the rateCol1 from rate sheet …
I have lost Excel file password and i don't remember my Excel file password so any one suggest me how to unlock Excel file protection? Can anyone suggest me best Excel password recovery software?
Hi guys I dont know alot about MACs but a charity I help out has asked me to do the following: -I have a rough system in place but it isn't efficient (it has just evolved over time) - I often spend a long time searching for a file and …
Hello all members i forget the password of my excel file which have very imp data. i must have to recover the file. kindly help me out to do so. PLEASE NOTE THAT! The password i usually use is up to 12 characters which includes * and capitalization of characters. …
I have a form that I want to put on the web for online form submission, below is how it ought to work in my mind. I need to know whether this can be a reality and how to do it: Create form in Word. Convert Word form to PDF. …
does anyone know how i can fix the pianoman virus on my computer and get my office documents back
This is an issue that I've discusses many times before, but never with a conclusive solution. I am trying to programmatically change the data range for an existing chart in Excel. My code goes something like this: [CODE] With WS.CharObjects(SelChart).Chart With .SeriesCollection(1) .XValues =DataWS.Range("A1:A101") '<-----ERROR! .Values = DataWS.Range("B1:B101") End With …
Hi I once went for an interview before my previous job it was a practical interview and I was asked to determine and fix a number of problems and I cant for the life of me remember what was the fixes so was wondering if you guys could help: **the …
Hi, I need to generate a dynamic bar graph in excel.The code is in java and related technologies.On my site when a click a button 'generate graph for selected values' i should to get a bar graph in excel.Since the values selected can change and also the data associated with …
> Quoted Text Here Was using the software My Invoices & Estimates when software stopped generating reports needed for accts rec and sales tax. Contacted co several times - their IT staff knows they have a problem - but no fix. Googled the error exceptions multiple times and gave up. …
I use Windows 7 PRO and MS Office 2003. Have had no problems until now. I use automatic updating and the Dec 11th release had 3 relating to office 2003. None will install although all the other updates did. I've tried MS help and they've run and said they fixed …
I want to make macro in Word to find "the" in document and replace it with "THE". Only words which have space before and after "the" should be changed and the in these or words like that should not change. How can I write commands for it in Word. I …
I'd like to create something like this: http://www.million-monkeys.com/tvcyo/ I'd love to use Google docs, but I wouldn't mind plugging it all in by hand. I've done so before when I used this site: http://jquery-datatables-column-filter.googlecode.com/svn/trunk/index.html to create a searchable database. I'm just wondering, however, how would I go about doing that …
I'm still getting my feet wet with Java and I'm not familiar with all the custom libraries that exist; is anyone familiar with a library for working with multiple sheets of a Excel workbook? I need to pull data from a specific worksheet in the book to work with.
hi! i want to open a word document directly from a windows form application running on visual studio 2010! i tried a particular code but it wont work!!! this is the code! [CODE]this.Application.Documents.Open(@"C:\Test\NewDocument.doc");[/CODE] i also imported and used the following header: [CODE]using Microsoft.Office.Interop.Word;[/CODE] it says that the word application does …
Can any tell me ReadOnly Status os Excel Driver... I want to read from and write into Existing Excel Sheet.. Am using ADODB.Connection and ConnectionString as "DRIVER=Microsoft Excel Driver (*.xls);DBQ=FilePath;ReadOnly=1;" in javascript.. Here ReadOnly=1 indicates the connection to be established in read only mode.. If I put ReadOnly=0, then Is …
Help i need to import excel to my listview using adodb or oledb but i dont know how? in vb6 i use adodb and the code is like here Dim lngI as Long Dim lvItem as listItem *'adodb connection goes here...* *'then this code will import all excel data in …
 # INTRODUCTION # This toolsuite will let peolple hide or unhide secret message inside of Microsoft Office 2007 files .just in an intelligent way.Since the newer Office files are basically just zip files containing XML and resources.By zip library,we can extract some xml parts inside of the file.This …
Hello to all, I am working on a spreadsheet/database for my company to track our service calls for the equipment we sell. There are a total of three of us that travel to different locations. I have helped create a database that allows a user to enter information after completeing …
-->>Hi to all, now I was about to document the help file of my applicatiion and I thought "How or what kind of controls will I use to have something like waht Microsoft has in a Word application where I can just write the documentation in in such a way …
Hi all I would like to search a Excel List of names(voters Registration list) by typing a name to see if that person is registered. Can anyone advice me how to do it or provide me with a sample program Many thanks
The End.