Posts by dietherdeyv

    I think I've found what was wrong. Try this




    Your code needed to save the presentation - pptDoc

    Code
    1. pptDoc
    Code
    1. pptDoc

    THANK YOU SO MUCH FOR THIS, SIR! I kinda get it working.


    This automatically saves the file to a path made by the user.

    My only problem now is after the saveas, the file is not opened.


    Any help on how can I open the newly saveas file?

    Hi! I want to open a pptx file and save as it directly with a dialog box or a prompt shows up allowing the user to choose a location to save it and what file name.


    I do not want to open the pptx file so I added the .visible false and it does not work. other than that, removing that line of code, I can't still save as my pptx file


    I tried this code but to no luck


    Any help will be appreciated! Thank you.

    Try:

    This is a nice work!!! But I really want to make my data look like this:
    :( :( :(

    Try:

    I wanted it to look like this but I cannot find a way to code it. Please help :(

    Try:

    Is it possible sir that it won't delete the entire row?

    Just the row starting from G to J?

    This will work fine for me sir royUK :)


    Can you help me with my other problem sir? huhu

    I want to remove the rows from the right side data that has no MATCH and NO MATCH values

    You need to create a proper template with the extension .xltm. These files cannot be overwritten and you save a workbook created from them


    How to use Excel Templates

    so from this line;

    Workbooks.Open ThisWorkbook.Path & "\" & "DATACOMPARE\Report.xlsx"


    I will just make a xltm file and change it to;

    Workbooks.Open ThisWorkbook.Path & "\" & "DATACOMPARE\Report.xltm"


    am i right sir? :)

    Try:

    This works like a charm! THANK YOU SO MUCH! :love::saint:

    Hello.


    I have a host excel workbook which contains all the VBA Codes. When I click a button there, it must compare two workbook's data and generate a report file.


    Workbook Data 1 contains this:


    Workbook Data 2 contains this:


    ID 1 must only be compared to ID 1 and so on thus generating a report file:


    The Workbook Data 2 offsets and adjusts its placement in the row if they have NO MATCH.

    Then ALIGNS to the Workbook Data 1 if the ROW of data are all the SAME with a REMARKS on the last column as MATCH.


    I have tried making this code and this is as far as I have gone to:

    In this code, I tried pasting the data of two workbooks to one workbook but I can't seem to know how to compare them from there.

    Please help anyone. Thank you.