7 Visitor Messages

  1. View Conversation
    hi sir,
    please help me

    i want to use the formula " sumproductif " ,as " sum if "..
    can it is possible..
    please use the undergiven link for my problem.
    rapidshare.com/files/302276522/querry.xls.html



    waiting for solution..
    as on my personal mail id joshirohit123@rediffmail.com

    thakns
  2. Thanks Richard... yes, I will drop both you & Colin a note when that time comes... as I said to Colin - train tickets are something of an expensive luxury presently !
  3. nein... I just figured I shouldn't "advertise" ;-)
  4. View Conversation
    Hello,
    When you have the time can you take a look at the workbook I uploaded (http://www.excelforum.com/excel-gene...selection.html) and see if what I want to do is possible.
    Thanks,
    elefante
  5. Yes indeed... lasw10 didn't really have the same ring to it...
    And of course I need more problems to solve!!!
  6. Hi

    If you want to do this in just this one file then you can use the FileDailog:

    With Application.FileDialog(msoFileDialogSaveAs)
    .InitialFileName = ActiveSheet.Range("A1").Value
    If .Show=-1 Then ActiveWorkbook.SaveAs .SelectedItems(1)
    End WIth

    which will show whatever value is in A1 as the initial filename. You need to include the Path in the value in A1 or you could set it as the Path of the Activeworkbook or some other specified path if you wish.

    Richard
  7. View Conversation
    Hi Richard,
    You had replied to a post I placed regarding The SaveAs Dialogue. At the time I was focused on "Opening" files, now I want to save them. I had searched for sometime and have had no clear answer. Want I want is to go to the menu bar, hit file, then "Save As" and a cell value of the activesheet will be in the file name field. This would allow for editing of the name. I don't want a seperate dialogue box. Is this something you were willing to help with at the time?

    Thanks,
    Dsexpress
Showing Visitor Messages 1 to 7 of 7
About Richard Schollar

Basic Information


About Richard Schollar
Location:
Hampshire UK
Occupation:
investment Reporting Manager for large global insurer
My Microsoft Office Version:
Excel 2002

Signature


Richard Schollar
Microsoft MVP - Excel

Statistics


Total Posts
Total Posts
1,264
Posts Per Day
0.60
Last Post
Are you a Geek ? Are Pocket Protectors Cool ? 01-05-2011 12:37 PM
Visitor Messages
Total Messages
7
Most Recent Message
11-07-2009 10:06 AM
General Information
Last Activity
09-13-2011 08:32 AM
Join Date
05-23-2006

12 Friends

  1. Bob Phillips Bob Phillips is offline

    Forum Guru

    Bob Phillips
  2. Colin Legg Colin Legg is offline

    Forum Guru

    Colin Legg
  3. daddylonglegs daddylonglegs is offline

    Forum Moderator

    daddylonglegs
  4. Domski Domski is online now

    Forum Guru

    Domski
  5. DonkeyOte DonkeyOte is offline

    Forum Moderator

    DonkeyOte
  6. JONvdHeyden JONvdHeyden is offline

    Forum Contributor

    JONvdHeyden
  7. lecxe lecxe is offline

    Forum Contributor

    lecxe
  8. NBVC NBVC is offline

    Forum Moderator

    NBVC
  9. Roger Govier Roger Govier is offline

    Valued Forum Contributor

    Roger Govier
  10. romperstomper romperstomper is offline

    Forum Moderator

    romperstomper
Showing Friends 1 to 10 of 12
Page 1 of 2 12 LastLast

Search Engine Friendly URLs by vBSEO 3.2.0