 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / January 2008Macro Recorder
I have a very basic question( I think). When you are recording a Macro how do you stop and then restart where you left off? For example I have a repetitive task that moves columns from one spreadsheet to another. The problem is that there are about 40 columns I am required to move. As I record the macro can it be stopped and then restarted if I have to close Excel and return later? I can't find the answer to my question documented anywhere. Thank You, Greg You can stop it, but when you start again it will create a new subprocedure, you can go in and copy/paste the second after the first leaving out the 1st end sub and the second one sub x  Signature-John Please rate when your question is answered to help us and others know what is helpful. > I have a very basic question( I think). When you are recording a Macro how > do you stop and then restart where you left off? For example I have a [quoted text clipped - 5 lines] > Thank You, > Greg No but you can cut and paste the contents of two macros together after you record them. > I have a very basic question( I think). When you are recording a Macro how > do you stop and then restart where you left off? For example I have a [quoted text clipped - 5 lines] > Thank You, > Greg Why not tell us EXACTLY what you are trying to do. Which columns, etc and, as always, post your efforts for comments. SignatureDon Guillett Microsoft MVP Excel SalesAid Software dguillett1@austin.rr.com >I have a very basic question( I think). When you are recording a Macro how > do you stop and then restart where you left off? For example I have a [quoted text clipped - 5 lines] > Thank You, > Greg Are you sure you dont want to make the macro using relative references? >I have a very basic question( I think). When you are recording a Macro how > do you stop and then restart where you left off? For example I have a [quoted text clipped - 5 lines] > Thank You, > Greg Thank You all for responding. I can see how to use the copy/cut/paste option... Don, A little more background. Each Month I receive a 3 CDs with Spreadsheets from one of our communications service providers. We update an access database with the information from the CDs through the Access import function. However we only choose the fields necessary for our Database from the CDs. We actually concatenate the CD information from the CDs before we update the DB and only do one import. Jay, How will relative referencing help me? And what happens when our service provider adds or deletes columns from the spreadsheets? Right now with this macro I will have to change the macro(subprocedure) Once again thank you all for your comments. Greg > Are you sure you dont want to make the macro using relative references? > >I have a very basic question( I think). When you are recording a Macro how [quoted text clipped - 6 lines] > > Thank You, > > Greg Is there some reason you can't post your macro(s) for comments? SignatureDon Guillett Microsoft MVP Excel SalesAid Software dguillett1@austin.rr.com > Thank You all for responding. I can see how to use the copy/cut/paste > option... [quoted text clipped - 27 lines] >> > Thank You, >> > Greg Don, No reason not to post except the fact I have never completed the recording. When I complete I will post. Thanks to all again, Greg > Is there some reason you can't post your macro(s) for comments? > [quoted text clipped - 29 lines] > >> > Thank You, > >> > Greg |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.