|
Write code to Write Code
Morning. I have been searching the threads and have not been able to find an answer to my current conundrum so I thought it best to throw it at the forum. I have a procedure which is copying worksheets and pasting them into new workbooks and then cutting all links etc. But what I want to do is add modules and / or part of the code within the modules to this copy and paste procedure. Can this be done? Any advice greatly appreciated. Kristan -- Kstalker ------------------------------------------------------------------------ Kstalker's Profile: http://www.excelforum.com/member.php...o&userid=24699 View this thread: http://www.excelforum.com/showthread...hreadid=488015 |
Write code to Write Code
Hi Kristan,
See Chip Pearson's page on Programming to the VBE: http://www.cpearson.com/excel/vbe.htm --- Regards, Norman "Kstalker" wrote in message ... Morning. I have been searching the threads and have not been able to find an answer to my current conundrum so I thought it best to throw it at the forum. I have a procedure which is copying worksheets and pasting them into new workbooks and then cutting all links etc. But what I want to do is add modules and / or part of the code within the modules to this copy and paste procedure. Can this be done? Any advice greatly appreciated. Kristan -- Kstalker ------------------------------------------------------------------------ Kstalker's Profile: http://www.excelforum.com/member.php...o&userid=24699 View this thread: http://www.excelforum.com/showthread...hreadid=488015 |
Write code to Write Code
Thanks Norm. Just what i was after. Regards Krista -- Kstalke ----------------------------------------------------------------------- Kstalker's Profile: http://www.excelforum.com/member.php...fo&userid=2469 View this thread: http://www.excelforum.com/showthread.php?threadid=48801 |
Write code to Write Code
norman:
"Microsoft Visual Basic For Applications Extensibility 5.3". why won't this say checked for me when after i exit excel? the other libraries do. -- Gary "Norman Jones" wrote in message ... Hi Kristan, See Chip Pearson's page on Programming to the VBE: http://www.cpearson.com/excel/vbe.htm --- Regards, Norman "Kstalker" wrote in message ... Morning. I have been searching the threads and have not been able to find an answer to my current conundrum so I thought it best to throw it at the forum. I have a procedure which is copying worksheets and pasting them into new workbooks and then cutting all links etc. But what I want to do is add modules and / or part of the code within the modules to this copy and paste procedure. Can this be done? Any advice greatly appreciated. Kristan -- Kstalker ------------------------------------------------------------------------ Kstalker's Profile: http://www.excelforum.com/member.php...o&userid=24699 View this thread: http://www.excelforum.com/showthread...hreadid=488015 |
Write code to Write Code
Hi Gary,
I have never experienced this problem. After setting the reference for the given project, are you saving the workbook? --- Regards, Norman "Gary Keramidas" <GKeramidasATmsn.com wrote in message ... norman: "Microsoft Visual Basic For Applications Extensibility 5.3". why won't this say checked for me when after i exit excel? the other libraries do. -- Gary "Norman Jones" wrote in message ... Hi Kristan, See Chip Pearson's page on Programming to the VBE: http://www.cpearson.com/excel/vbe.htm --- Regards, Norman "Kstalker" wrote in message ... Morning. I have been searching the threads and have not been able to find an answer to my current conundrum so I thought it best to throw it at the forum. I have a procedure which is copying worksheets and pasting them into new workbooks and then cutting all links etc. But what I want to do is add modules and / or part of the code within the modules to this copy and paste procedure. Can this be done? Any advice greatly appreciated. Kristan -- Kstalker ------------------------------------------------------------------------ Kstalker's Profile: http://www.excelforum.com/member.php...o&userid=24699 View this thread: http://www.excelforum.com/showthread...hreadid=488015 |
Write code to Write Code
yep, but it only saves it for that workbook, not for all excel workbooks.
why isn't it available to excel instead of just the saved workbook? -- Gary "Norman Jones" wrote in message ... Hi Gary, I have never experienced this problem. After setting the reference for the given project, are you saving the workbook? --- Regards, Norman "Gary Keramidas" <GKeramidasATmsn.com wrote in message ... norman: "Microsoft Visual Basic For Applications Extensibility 5.3". why won't this say checked for me when after i exit excel? the other libraries do. -- Gary "Norman Jones" wrote in message ... Hi Kristan, See Chip Pearson's page on Programming to the VBE: http://www.cpearson.com/excel/vbe.htm --- Regards, Norman "Kstalker" wrote in message ... Morning. I have been searching the threads and have not been able to find an answer to my current conundrum so I thought it best to throw it at the forum. I have a procedure which is copying worksheets and pasting them into new workbooks and then cutting all links etc. But what I want to do is add modules and / or part of the code within the modules to this copy and paste procedure. Can this be done? Any advice greatly appreciated. Kristan -- Kstalker ------------------------------------------------------------------------ Kstalker's Profile: http://www.excelforum.com/member.php...o&userid=24699 View this thread: http://www.excelforum.com/showthread...hreadid=488015 |
Write code to Write Code
Hi Gary,
References are set for each project; there is not a global setting. If you want certain references to be available to all (new) workbooks, add these references to the workbook template file. --- Regards, Norman "Gary Keramidas" <GKeramidasATmsn.com wrote in message ... yep, but it only saves it for that workbook, not for all excel workbooks. why isn't it available to excel instead of just the saved workbook? -- Gary "Norman Jones" wrote in message ... Hi Gary, I have never experienced this problem. After setting the reference for the given project, are you saving the workbook? --- Regards, Norman "Gary Keramidas" <GKeramidasATmsn.com wrote in message ... norman: "Microsoft Visual Basic For Applications Extensibility 5.3". why won't this say checked for me when after i exit excel? the other libraries do. -- Gary "Norman Jones" wrote in message ... Hi Kristan, See Chip Pearson's page on Programming to the VBE: http://www.cpearson.com/excel/vbe.htm --- Regards, Norman "Kstalker" wrote in message ... Morning. I have been searching the threads and have not been able to find an answer to my current conundrum so I thought it best to throw it at the forum. I have a procedure which is copying worksheets and pasting them into new workbooks and then cutting all links etc. But what I want to do is add modules and / or part of the code within the modules to this copy and paste procedure. Can this be done? Any advice greatly appreciated. Kristan -- Kstalker ------------------------------------------------------------------------ Kstalker's Profile: http://www.excelforum.com/member.php...o&userid=24699 View this thread: http://www.excelforum.com/showthread...hreadid=488015 |
| All times are GMT +1. The time now is 05:15 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com