How to run macro file

Help Studio
, ,
1

image
image1630×860 75.4 KB

I have 3 sheets in macro (3,4,5)

Each sheet is having Update and Export Button (1 ,2)

So first i want to update the data in the sheet and export it so how can i do it

image
image692×558 15.9 KB

I have used this activity but in this it is only Updating the data but not exporting

So, is there any solution for this

Forum Engagement Daily Reports
2

Hi @Gokul_Murali

Probably the name of the subroutine (macro) that is assigned to the button of export as csv file is different.

Best case scenario combine both the subroutine to call one after another or just execute the macro activity one more time with method name for export. You can check that in

  • Right-click the button and select Assign Macro. This will open the Assign Macro dialog box. This is where you can spot the name of sub assign to this button.

Hope this helps :slight_smile:

3

image
image542×520 11.7 KB

I have try to sub assign it to the second button and add 2 execute macro activity with the same name but its not exporting the data

I have assigned like below

image
image672×560 33 KB

4

Hi @Gokul_Murali

Can i take a look into the VBA code. Can you able to share the macro.

You don’t need to write it 2nd time with same name in execute macro because for export I think in the 2nd execute macro you need to write CSVPremium as macro name. If that is the underlying macro for your Export to CSV.

Hope this helps :slight_smile:

5

Is it a private sub or public sub?
If private, try with invoke vba instead of execute macro.

6

@Gokul_Murali hi
Reinstall the exe package for this add ins
It will solve the problem

Also check manually once if you click are you able to export?

Is there any specific error coming during macro execution ?