A button to generate a file with specified field value

[nihalbuddy09]

Hi All,

I have created a button object called “Comments”; by using Add Actions ->External->Launch action and under the ‘Filename’ entered the excel file path, and I can able to see the excel file after one click on the button BUT instead of entire data I have a requirement to view the excel file based on “Region” field value selection (i.e. if I enter Region as ‘AS’, the excel file should be open with data that is related to that particular region only and rest of the regions data should not display).

Please help me out on this requirement so that I can be able to create a button accordingly.

Thank you,

Nihal

[nihalbuddy09]

Hi Sinan,

Thank you for your time and help in this process, until this point your inputs are helpful to me with out Macros.

Further I have some more work to do, if required I will request your help again.

Thanks again and have a great day!

Nihal

[sinanozdemir]

You are welcome. No problem at any time and I will do my best to help you out.

Have a great day too.