Re: Macro Recorder

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Is there some reason you can't post your macro(s) for comments?

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett1@xxxxxxxxxxxxx
"Greg" <gfjesky@xxxxxxxxxxxxx> wrote in message news:s_ehj.48681$_m.6456@xxxxxxxxxxxxxxxxxxxxxxxxx
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
"Jays" <jayes33@xxxxxxxxxxx> wrote in message
news:e5NocyxUIHA.5404@xxxxxxxxxxxxxxxxxxxxxxx
Are you sure you dont want to make the macro using relative references?
"Greg" <gfjesky@xxxxxxxxxxxxx> wrote in message
news:9h5hj.49345$N67.33382@xxxxxxxxxxxxxxxxxxxxxxxxx
>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
>
>





.

Relevant Pages

  • Re: Where is Macro 64 in OpenVMS 7.3 Distribution?
    ... >We've got a package that requires Macro 64 to build. ... >tell me where I can locate the installation kit, and the PAK for this? ... Macro-64 was distributed on the OpenVMS Freeware V4 CDs. ...
    (comp.os.vms)
  • Re: Lite on cdrw drive question
    ... Greg said this on 10/11/2009 1:04 PM: ... Some cds, it has trouble reading and burning some cd but not all cds. ... Model number is Lite-on LT-ON LTR-24102B ...
    (microsoft.public.windowsxp.hardware)
  • Re: Longest work
    ... Greg wrote: ... I think I remember there was a recording of some really long work by ... Hermann Nitsch that came to over 50 CDs that came out a few years ago, ...
    (rec.music.classical.contemporary)
  • Re: Macro Recorder
    ... Spreadsheets from one of our communications service providers. ... access database with the information from the CDs through the Access import ... As I record the macro can it be stopped and then restarted if I have to ...
    (microsoft.public.excel)
  • Re: Woofy Productions?
    ... "live at Royal Palms Inn" (10 CDs) and some Niehaus CDs. ... All in all the quality is ok considering that these are rare recordings ... sound/production quality. ... Greg M. ...
    (rec.music.bluenote)