If you have a column of cells that contain this kind of information:
09/01/2008 to 09/30/2008
You could insert a column (or two) and use data|text to columns to parse the
string. You'll be able to specify the format for each date field (mdy), too.
And if you need a macro, you could record one when you do it manually to get the
syntax.
Robert_L_Ross wrote:
>
> Dave,
>
> Thanks...after I posted that and just before I left work I remembered I
> needed to specify the cell value...in this case I didn't need to specify the
> sheet name since I'm looking at the active sheet when the macro runs.
>
> Thanks!
>
> "Dave Peterson" wrote:
>
> > "B3" is the text B3--not what is in some worksheet in cell B3.
> >
> > Message = MsgBox(InStr(1, worksheets("sheet999").range("B3").value, " to "), _
> > vbOKOnly, "test")
> >
> > You may have to include the workbook that that worksheet belongs to, too.
> >
> > Robert_L_Ross wrote:
> > >
> > > I have a unique problem. When I export a report from a program, the dates
> > > are formatted as mm/dd/yyyy:
> > > 09/01/2008
> > >
> > > When other users export the same report from the same program, the dates are
> > > formatted as m/d/yyyy:
> > > 9/1/2008
> > >
> > > I don't know if it's an Excel issue, Windows or even the source program, but
> > > that's not important.
> > >
> > > The export has cell B3 with this value (on my machine):
> > > 09/01/2008 to 09/30/2008
> > >
> > > When I go into a macro with the following line:
> > > Message = MsgBox(InStr(1, "B3", " to "), vbOKOnly, "test")
> > > I get a dialog box with "0"
> > >
> > > This makes no sense...when I use the Find function in the spreadsheet it
> > > works:
> > > =FIND(" to ",B3,1) Returns 11
> > >
> > > I'm trying to find a way in the VB code to account for the different date
> > > formats...if I can find where " to " starts, I can trim the value. I need
> > > the value to determine a name for the file based on it's contents.
> > >
> > > Thanks!!
> >
> > --
> >
> > Dave Peterson
> >
--
Dave Peterson
|
Similar Threads
