Microsoft Excel

• Microsoft Excel Questions

• • Compare & Delete in Excel

    Dave,What you gave me works!I have had only one issue and it was when I had something duplicate inCo...

    By smittydotbat

  • I found this great little site

    I found this great little site. I signed up two weeks ago and got 2 Disney tickets and this week the...

    By ifoundthisgreatlittlesite

  • remote query & date range?

    Hi,I'm using Excel 2003 to query a SQL 2000 database. The table I'm queryinghas a date field...

    By linnkubler

  • Progress Bar

    Is there any way to modify the following code so that theprogress bar will update itself according t...

    By karen

  • No change event on control toolbox combo box when ...

    Of the three combo boxes available I generally prefer the simple DataValidation drop down list. But ...

    By donwiss

• • Populate a column with a month end data

    Hello,I am using Excel 2002 and I am wondering if this is possible. I get a dailyreport from our mai...

    By alexmartinez, 1 Comments

  • popluating a list box without having duplicates

    I have a list box that i want to populate from an Excel list. The listwould look something like this...

    By thesquirrel_gmail_com, 2 Comments

  • This application is about to initialize controls t...

    If you step through the code, what is the code line that generates the msg ?"ric.payne@principa.net"...

    By gocush, 1 Comments

  • mscmctl2.ocx ... calendar and date picker sometime...

    Scenario=======excel 2002 spreadsheet has calender control and date and time pickerfrom mscmctl2.ocx...

    By thisisnotme_hotmail_com_nospam, 1 Comments

  • No calculation on new machine

    I run XP Home with Office 2002I have just installed my programs to a new machine.Excel is behaving d...

    By robinchapple, 2 Comments

• Microsoft Excel: is the Category's subject.It's has 396 questions,this is No.20 pages.
• ASP.NET Vb calling webservice
• Anyone have any examples of calling a web service from ASP.NET?ex. returning string values OR returning a XML document from thewebservice.*** Sent via Developersdex http://www.codecomments.com ***Don't just participate in USENET...get rewarded for it!...
• larry, Sun, 14 Mar 2010 16:23:00 GMT, 342 bytes, 1 Answer
• asp.net Office Automation - in or out of process
• When I use Office Automation in an asp.net application, are the Officelibraries invoked in or out of process?Thanks...
• davidlaub, Sun, 14 Mar 2010 14:59:00 GMT, 135 bytes, 4 Answer
• Mean of standard deviations across columns?
• Domenic,Thanks. The only issue is that the columns are not contiguous.I'm just wondering if there's a way to take an mean of a mean ofcolumns, without calculating a separate column. Subtotal seems to workfor groups of columns only.ModelerGirlModelerGirl's Profile: http://www.mcse.ms/...
• modelergirl, Sun, 14 Mar 2010 13:27:00 GMT, 608 bytes
• accounting software template in excel 2000?
• I want to know whether is any accounting software template in excel 2000, forindian small business...
• seshadri, Sun, 14 Mar 2010 13:15:00 GMT, 106 bytes, 1 Answer
• I get an error when sending sheet via email
• I am running office 2000. I recently updated Outlook to Outlook2003. Now,none of the other applications can email. When I click the icon I get anerror that the email application can not be found. I was able to send anexcel sheet as an attachment, but I need to be able to send as the messagebody....
• marty, Sun, 14 Mar 2010 12:39:00 GMT, 367 bytes, 1 Answer
• Populate 2-column ListBox with 2 non-contiguous columns
• Hi guysI would like to populate a 2-column ListBox with 2 non-contiguouscolumns. I know how to do this by looping through the two columnarrays, but am wondering if there's a way of assigning each columnarray to the ListBox.Column [or other] property (without looping).Thanks in advancePaul Ma...
• paulmartin, Sun, 14 Mar 2010 05:31:00 GMT, 364 bytes, 2 Answer
• Scaling the x-axis
• Lines: 1Xref: number1.nntp.ash.giganews.com microsoft.public.excel:35024Using a line chart, is it possible to have scaling appart from theY-axis to the x-axis, regardless the kategory-values of the x axis?For example the values of x to establish some points are 5, 15, 30 etc.is it possible to pu...
• dinos, Sun, 14 Mar 2010 00:08:00 GMT, 488 bytes, 2 Answer
• Side-by-Side worksheets
• I have two different worksheets (same workbook) displaying side-by-side inthe Excel window. Is it possible for one of the worksheets not to displaythe minimize and maximize window buttons?Thanks...
• sheldon, Sat, 13 Mar 2010 20:27:00 GMT, 218 bytes, 7 Answer
• button
• how can i check if a button already exists in a certain sheet on opening ofa file?...
• luc, Fri, 12 Mar 2010 17:30:00 GMT, 94 bytes, 1 Answer
• Populate a ComboBox
• I used the code shown below to populate a combobox in a Word UserForm.It basically cycles through each record and loads the value of field1, 2 or 3 into the combobox depending on a user selection.Is there a way to use the combobox '.List" method to populate the listall at once vice cycling t...
• gregmaxey, Fri, 12 Mar 2010 12:14:00 GMT, 1,270 bytes, 3 Answer
• I get two copies of pictures in the loop instead of one - why?
• Hi,I have a sheet where I in Worksheet_Activate copy all chartobjects and pastethem as pictures and then hide the chartobjects. This make the users notable to ruin the references in the charts.Problem: I get two copies of pictures...why?She sheet1 had to have a couple of charts. Code:Sub CopyCha...
• mariahigh, Fri, 12 Mar 2010 02:40:00 GMT, 915 bytes, 3 Answer
• Upgrading to Office 2003
• I meant DAO will run in that version - I think that is what the originalquestion was.Regards,Tom Ogilvy"Jamie Collins" <jamiecollins@xsmail.com> wrote in messagenews:2ed66b75.0408182315.f988883@posting.google.co m...> "Tom Ogilvy" <twogilvy@msn.com> wrote ...>> Depends what...
• tomogilvy, Thurs, 11 Mar 2010 23:31:00 GMT, 788 bytes
• Dialer wont start
• The following code works fine under WindowsME but will not run in WindowsXP.The message I am getting when the code is run is "Cannot start Dialer.exe"The message has an OK option only and whae clicked will not stop the codefrom running. The only course of action is to close down Excel via the Ta...
• pat, Thurs, 11 Mar 2010 23:29:00 GMT, 865 bytes
• Outlook and Excel
• I need expert help. This code searches four lines in the body of theemail, and copies it to excel by column. I would like to add two morecolumns where the date email was received and email subject are alsoincluded.Sub bodyStrip(msg As Outlook.MailItem)Dim sBody As StringDim aFields As VariantDim...
• praetorian_prefect_2004_yahoo_com, Thurs, 11 Mar 2010 21:13:00 GMT, 839 bytes, 2 Answer
• No Blanks
• Can someone please help me to make this formula=SUMA(SI(S!D4:D1000=S!G4:G1000,1,0))not to count blanksThanks in AdvanceAnthony...
• antonyo, Thurs, 11 Mar 2010 19:40:00 GMT, 158 bytes, 5 Answer
• MSFlexGrid
• Has anyone here worked with MSFlexGrids in a macro that is to be ran onmore then one computer? I've found that i have to manually add theflex grid on each computer i put it on, does anyone have any ideas ofhow I might be able to fix it?thanks,jake...
• jake, Thurs, 11 Mar 2010 05:39:00 GMT, 283 bytes
• Populate a cell from a text box.
• Hi all,No doubt a simple question!I have a vb form into which the user types a value.Various calculations happen in the vb code which produces a string.I want to place that string into a cell on a worksheet. Does anybodyknow how to do it?Thanks!Message posted from http://www.mcse.ms/...
• unknown_user, Thurs, 11 Mar 2010 02:52:00 GMT, 394 bytes, 2 Answer
• Instert Rows Based on Cell Value
• Hello,I could really use a hand on this one.I have multiple lines of different products ordered by differentpeople. In each row in excel it shows the product that was ordered aswell as the quantity and some other information.What I need to do is expand each row based on the quantity value.Essent...
• derekrap, Wed, 10 Mar 2010 21:16:00 GMT, 1,215 bytes
• Button caption identification
• Hello!After creating 5 buttons on a sheet with form I am wrote a macro anddepending on the button I trigger a sort. What variable containg thebutton name or caption?Thank's ahead...
• bobby, Wed, 10 Mar 2010 18:43:00 GMT, 206 bytes
• Signaling the presence of a password
• Hey there,Is there a way to find out, from inside a workbook,if that workbook is password-protected or not.Why....?I have created a workbook with some specific functions inthe buttonbar that should only be available to users thathave their workbook protected by a password, if not thanthese butto...
• geertnauta, Wed, 10 Mar 2010 14:23:00 GMT, 483 bytes, 1 Answer
• «««1011121314151617181920