Thanks Ivan - That looks like it will do the trick!
As a separate but related question, do you know of a way to write code from one vba project to another? I work with a lot of .xla's to process .xls and .txt files in my work, and some of the data processing can get fairly complicated...
Hi,
I am having difficulty adding code to a commandbutton and wondered if anyone has a solution for how to do this.
Brief description:
I create a worksheet on an open workbook by code (from a remote xla). I add a button to that worksheet by code. I want to assign event code to that...
Looking further into your code, I am a little confused as to what you are trying to do.
I think you are trying to copy from multiple worksheets in a source workbook and transfer (and transpose) that data into consecutive areas on the same worksheet in a compilation workbook. After you have...
Hi Carl,
The problem isn't in your definition of the pastespecial line. Since you are switching between workbooks, you need to activate the destination workbook before attempting to paste the cell values into the defined range.
You may wish to define a Workbook variable for the destination...
This is either one question or two:
As 2 Questions (excel 2000):
1.) How do I create a command button on a worksheet using code and have it run a macro located in a remote code module (.xla) I know the ActiveSheet.OLEObjects.("cmdButton1").Object.OnAction = "MacroName"...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.