Re: Is it possible to export each row of data to a seperate work book

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

From: Stacey (psalm40_at_bellsouth.net)
Date: 05/14/04 

Date: Fri, 14 May 2004 17:25:39 -0400

Dick,

    I can't thank you enough for all of the time you have spent with helping
me!

When I put the new code in it still skips all of the code that fills in
myform and then saves it. It just keeps looping.

I even tried putting the code in the address.xls file and running it from
that file. It still does the same thing. I think I am doing something wrong.
When I open the original address.xls file it tells me I need to open it as
read only and asks if I want to open it as read only and I click no. Would
this be the cause of the looping.

The row in the address that conatins my name is L, if that makes any
difference on what cell the macro is using when I enter my name?

Thanks Again!!

Stacey
"Dick Kusleika" <dickk@paragonUNMUNGEconstructioninc.com> wrote in message
news:epKR$2eOEHA.3944@tk2msftngp13.phx.gbl...
> Stacey
>
> Not hard. Is that what you were autofiltering on?
>
> Dim sName as String
>
> sName = InputBox("Enter your name")
>
> If sName = "False" Then
> Exit Sub
> End If
>
> For Each cell In Rng.Cells
> If cell.Value = sName Then
> 'Do other stuff in the loop
> End If
> Next cell
>
>
> --
> Dick Kusleika
> MVP - Excel
> Excel Blog - Daily Dose of Excel
> www.dicks-blog.com
>
> "Stacey" <psalm40@bellsouth.net> wrote in message
> news:3eSoc.8455$z41.5225@bignews1.bellsouth.net...
> > Dick,
> >
> > I am using Office 2003.
> >
> > How hard would it be to Prompt the user for Their name and then use an
if
> > /Then statement to only look at the rows that had their name in that Row
> of
> > data?
> >
> > Thanks again for your help!!!
> >
> > Stacey
> >
> > "Dick Kusleika" <dickk@paragonUNMUNGEconstructioninc.com> wrote in
message
> > news:eBkOHQTOEHA.3596@tk2msftngp13.phx.gbl...
> > > Stacey
> > >
> > > > It skips all of the rows, it doesn't matter if they are hidden
or
> > > > visible it skips them all. Until I remove the autofilter, then it
will
> > > start
> > > > working again.
> > > >
> > >
> > > Hmmm. It works for me. What version of Excel are you using?
> > >
> > > --
> > > Dick Kusleika
> > > MVP - Excel
> > > Excel Blog - Daily Dose of Excel
> > > www.dicks-blog.com
> > >
> > >
> >
> >
>
>

Relevant Pages

  • Re: Is it possible to export each row of data to a seperate work book
    ... Excel Blog - Daily Dose of Excel ... Stacey wrote: ... > "Dick Kusleika" wrote in message ... >> Dim sName as String ...
    (microsoft.public.excel.programming)
  • Re: Need code to copy from "code modules"
    ... See Chip Pearson's page Coding for the VBE ... HTH, ... My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm ... > I am looking for (looping) code to copy the contents of the ...
    (microsoft.public.excel.programming)
  • Re: Access Freezes
    ... Your Resource For Help With Access, Excel And Word Applications ... Need a month calendar or 7 day calendar? ... > The subroutine takes some time, ... > I have a progressbar that works while the subroutine is looping. ...
    (comp.databases.ms-access)
  • Re: Export DataSet to Excel
    ... > should be faster to copy all of your data rows in one go to excel. ... > it is finished as it seems to take up a lot of processing power. ... >> I'm looping through my datarows, adding them one by one to the file. ... seems to open when i open excel whilst ...
    (microsoft.public.excel.programming)
  • Re: Export DataSet to Excel
    ... should be faster to copy all of your data rows in one go to excel. ... On My PC I am able to run a number of instances of Excel at the same time - ... > I'm looping through my datarows, adding them one by one to the file. ... seems to open when i open excel whilst ...
    (microsoft.public.excel.programming)