Posts by ROMIL

    hello experts.!!!:)

    i am looking for a little help,
    i have a code that save the activesheet as dbf.

    the activesheet has multiple columns and each column/ field has different text/font formats (ie date , number , text, etc.)


    but in the dbf file so saved, all the fields are saved as text.

    how to get the dbf saved in correct formats.??


    The criteria of the output table should be as following

    filed name type width/NO OF CHARACTERS decimals
    date DATE 8 0
    text TEXT / CHARACTERS 3 0
    numeric_decimal_2digit NUMERIC 10 2
    numeric_decimal_0digit NUMERIC 10 0
    logical LOGICAL 1 0



    i am attaching the file with sample data and codes activesheet_to_dbf.xlsm

    HELLO ALL..!!:heelloo:
    GREETINGS OF THE DAY.


    I HAVE A FOLDER WHERE THE FOLLOWING FILES AND SUB-FOLDER ARE PRESENT
    1) A FOLDER NAMED "raw folder" IN WHICH I HAVE AROUND 11 PDF FILES.
    2) AN EXCEL FILE WITH THE VBA CODES TO MERE PDF FILES LOCATED IN ABOVE MENTIONED FOLDER ("raw folder")


    THE CODES GIVEN BELOW CREATES A NEW PDF FILE NAMED "outputFile.pdf" WITHIN THE PARENT FOLDER.
    FOR THIS
    1) I HAVE INSTALLED PDF-CREATOR (Downloaded from http://sourceforge.net/projects/pdfcreator/)
    2) I HAVE CHECKED "PDFCreator_COM" IN TOOL > REFERENCES


    THE CODES ARE WORKING CORRECTLY FOR THE FIRST TIME WITH ALL 11 PDF MERGED TO ONE PDF
    BUT WHEN I RUN THE CODES FOR SECOND TIME IT DOESN'T MERGE ALL THE 11 FILE BUT ONLY THE 1ST PDF FILE IS RETURNED AS OUTPUTFILE
    WHEN I RUN THE CODES FOR THE THIRD TIME , THE CODES ARE WORKING CORRECTLY .
    AND SO ON


    PLEASE HELP ME OUT TO FIGURE IT OUT



    HERE IS THE VBA CODE



    Thank in advance. :)

    Re: editable listbox


    hi Cytop..
    thanks for the reply..


    actually i am looking for something like this..


    when a row in the list box is selected then

    • text-box value pops up with the selected row value.
    • the text-box re-sizes (width = column width and height= row height of listbox)
    • the text box moves to the selected row and fits there so that it seems that the text box is the part of list box itself
    • now when the text box value is changed the respective value in the row also changes.
    • when down or up key for text box is pressed the list-box selection changes



    here is what i have tried...

    Re: editable listbox


    hello Cytop.
    thanks for a quick reply..


    Actually I am new to VBA & i am not able to run the codes given by Andy Pope properly.
    Can you make a sample workbook for the same and post it...



    Thanks in Advance..

    Re: Information Extract


    hello farhadj.


    I have done something different as demanded by you. But hope your requirement will be met.



    Try the attached workbook.



    after getting the filtered data(department wise) .. select any name in column A... And the entire detail respective to that name will appear to the right of the column..

    Re: find minium value


    hello...


    The Click Button in the workbook that i attached is basically a shape(object)... and i have assigned a macro to the shape..

    Hello all..


    I have a table in sheet-1 with 3 columns (c,d,e)
    now i have inserted a code in sheet-1 so that when i select any cell in range(E5:E3000) userform-1 activates



    The useform has 2 textboxs.
    i need todays date in textbox-1 and selection.offset(0,-2).value in textbox-2
    ie if cell E5 is selected then textbox 2 should have value of cell C5



    i want the auto filled userform to popup when cell in range(E5:E3000) is selected.



    Please find the attachment


    thanks..

    hello all..


    I am looking for an macro to calculate the items required to make some dishes as per their respective recipes and quantity i want to make.



    i have a sheet (say sheet "recipe") which contains the recipes of around 500 dishes.
    i have another sheet in which i have a table(table-1 with 2 columns )
    i fill rows of table-1 with dish name and its quantity that i want to make for a particular day
    the table-1 may have up-to 150 entries .


    i need a macro to calculate the items required to make those dishes as per the entries in table-1.


    please find the attached sample workbook.

    hello all


    I have some dates in column"A", and numbers in Column"B"
    in column"c" i want to have a values of column"A" and Column"B" separated by "/"



    for eg:


    column"A" = 12-12-2012
    Column"B" = 987
    required result in column "C" = (12-12-2012/987)



    I m using this formula in cell C1 ="("&A1&"/"&B1&")"
    which gives[TABLE="width: 73"]

    [tr]


    [TD="width: 73"](41255/987)
    [/TD]

    [/tr]


    [/TABLE]





    can anyone figure this out...



    thanks in advance.....



    forum.ozgrid.com/index.php?attachment/50246/