Posts by ashu1990

  • Set file path as a cell relate to vlookup

    Re: Set file path as a cell relate to vlookup


    As far i would suggest is to keep the downloaded file into 1 folder and lookup the details you want
    after every file downloaded and replaced into the folders the figures would change automatically if the file name would be same
    and your work would be done for multiple criterias use if(iserror()) function.

  • IE Automation Pdf to save from IE

    Re: IE Automation Pdf to save from IE


    its a pdf object file which is showed in IE what i have to do is to get the pdf file and save it i need help on how would i be able to catch the pdf object details or save the pdf withoyut using send keys

  • help with countif formula

    HI guys,


    i am trying to put a countifs formula in excel but its returing value as "#VALUE!".


    i tried it using single countif then it gives the correct answer.
    the main thing i have to do is calculate 2 fields in it "=COUNTIFS(H:H,"=Mumbai",N11:X52,"=OG")"


    i have a column H where city names are there and column N to X where "OG" is written.


    can any one help me with the formula to count how many "OG" are there in mumbai city.

  • Search User Input String in variants of string - find all in any order contained

    Re: Search User Input String in variants of string - find all in any order contained


    try this


  • Duplicate Select Case code over multiple Excel Cells

    Re: Duplicate Select Case code over multiple Excel Cells


    try this



    increase the cnt number's as desired i have done the modification in your code so that you can understand the basics how to make a loop.
    hope this helps...:wink:

  • Import an excel table in a access file USING OFFICE 2010

    Re: Import an excel table in a access file USING OFFICE 2010


    try this

    Code
    set ran = sheets("INCONTRI").range("A1:I108468")
INSERT INTO INCONTRI([Static_ID], [Stage_ID], [Season], [Number], [Data], [Time], [Status], [Venue_ID], [League]) SELECT * FROM [Excel 12.0;HDR=YES;DATABASE=C:\Users\Admin\Desktop\test xml.xlsm].[ran]


    or try putting [INCONTRI!A1:I108468] instead of [INCONTRI$A1:I108468]


    hope this helps

  • VBA Loop

    Re: VBA Loop


    the code which you have provided will get into different bugs it is not appropriate can you tell what exactly you want to copy and paste.
    as far i understood from this

    Quote


    The code is supposed to go through a column and copy a cell's contents and paste in the next blank cells.


    heres the code for that

    Code
    Sub test()
Dim ran As Range
Set ran = ActiveSheet.UsedRange
For Each cell In ran
If cell = "" Then
cell.Value = cell.Columns.End(xlUp).Value     ''''use the xlup or xldown as per your requirement
End If
Next cell
End Sub


    Hope this helps..

  • Need to loop - Find and delete until all deletions are completed VBA

    Re: Need to loop - Find and delete until all deletions are completed VBA


    its great that you started asking questions which you dont know

    Quote


    One thing just for my understanding.. what is the purpose of "Dim ran As Range" ?


    we have to declare the property for the variable what kind of variable it is?
    i think you better have a macro tutorial which are easily available on the forum as well as on other web sites.
    it will help you achieve the goal.

  • Need to loop - Find and delete until all deletions are completed VBA

    Re: Need to loop - Find and delete until all deletions are completed VBA


    there are 2 possible ways..



    and also this


    Code
    Sub test2()
Dim ran As Range
Set ran = ActiveSheet.UsedRange
yourvalue = InputBox("Please enter value to delete", "Ashish", "Enter Here")
For Each cell In ran
If cell = yourvalue Then
cell.ClearContents ''' or cell.delete
End If
Next cell
End Sub


    Suit your self which one 2 use...