I'm not familiar with macros at all! (unfortunatlly, not even the basics..)
I need a button that will export a table to excel. The table is stored in a container (if it is possible to the macro to recognaize which table is activated and should be exported, else the table will stand alone).
In addition to the export, I need the excel to be saved in a specific folder (NOT just opend).
And last, I want that only authorized users will be able to activate the button, OR that only authorized users will be able to export ALL fileds, and others will be able to export just specific fields.
I attached a QV where I tried to export a table wuth a macro (button) but somehow I couldn't make it to work.
then have an excel sheet for example in which you specify the NTNAME and a Flag (1 or 0) 1 means the button is visible and 0 means the button is not visible and this is controlled in the Layout Tab of the button (conditional visibility)
I'm looking to add to the macro a script that will check if a user is in a specific Active Directory Group - If so, the macro will continue and the user will be able to export the object to excel (with the script you sent me). If not - the user won't be able to export (If we can through an error message to the user it will be great).
I'm trying to do that instead of making the button invisible for a non authorized users.
I'm having the same issue when I click the button to export to Excel it opens the window "edit module" instead of exporting to excel. Which security setting did you change to get this to work? Thanks in advance.