I have a set of data exports from a reporting suite that I currently run code to copy and paste into other files. These scripts work fine, but obviously these are stored in my personal files so only I can use at present. I am trying to set up an instruction guide for others to be able to run the reports and then the current script by pressing different 'buttons' within the instruction sheet. But no matter what I try I cannot switch the cut and paste to the sheet I need to, it always now cuts cells from the instruction sheet. Could it be because the exported files are not saved in excel, only exported? Or is there some way around this?
Thanks
vba unable to recognise workbook export
-
-
Re: vba unable to recognise workbook export
You wrote 'buttons' - what are they really? ActiveX, form control or a shape? Do they already have a macro assigned to them?
To copy and paste buttons (forms or activeX) you have to select the buttons themselves. To avoid running the code you can right-click on them directly.
I hope I am understanding your question correctly. If not, please enlighten me a bit further.
Regards
Attila -
Re: vba unable to recognise workbook export
The buttons are created from the 'Forms' toolbar with a macro on each one. This macro is to run the various scripts required to copy and paste from data files. At present if we try to run them then they copy and paste from the active instruction sheet. It is not the instruction sheet with buttons that we need to copy, we need to switch to the data export sheet to copy the relevant data, but we can't get it to do this
-
Re: vba unable to recognise workbook export
Could you possibly post the code you have until now or maybe upload a sample workbook with your code? Do you know where it's going wrong?
-
-
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!