2 more questions on excel and vba
 

I have a mess in a workbook that was sent to me in a chopped up manner
and I was expected to put it back into something usable.
this is a massive excel sheet.At least to me
over 1 million lines of data.

I do databases not excel so this has been a learning exp.

I am cutting it in 256column X30 rows at a time and pasting into a new
sheet.

anyway I get 1004 errors after about 8 loops of this trying to cut and
paste this much data.
Someone said save during your work and this will help.

ok I forgot to ask how do I do a save like this in vba?

Application.ActiveWorkbook.Save()
didn't work. I am not sure how to do a save like this.

second thing the data now looks like this

COL B
10/26/2011
9:28
9:40

I need to find the date and copy it from its current B1 to A1
how do I look thru a column of data and find just dates?


thanks again for any help with this

2 more questions on excel and vba
 

If the workbook has already been saved then... ActiveWorkbook.Save
It's in Excel's help file under "save".
(the newer excel help files are poorly done, so you get a mulligan <g)
--
Jim Cone
Portland, Oregon USA .
http://www.contextures.com/excel-sort-addin.html .
(a look at the Special Sort excel add-in (30 ways to sort)



"sparks"
wrote in message
...
I have a mess in a workbook that was sent to me in a chopped up manner
and I was expected to put it back into something usable.
this is a massive excel sheet.At least to me
over 1 million lines of data.

I do databases not excel so this has been a learning exp.

I am cutting it in 256column X30 rows at a time and pasting into a new
sheet.

anyway I get 1004 errors after about 8 loops of this trying to cut and
paste this much data.
Someone said save during your work and this will help.

ok I forgot to ask how do I do a save like this in vba?

Application.ActiveWorkbook.Save()
didn't work. I am not sure how to do a save like this.

second thing the data now looks like this

COL B
10/26/2011
9:28
9:40

I need to find the date and copy it from its current B1 to A1
how do I look thru a column of data and find just dates?


thanks again for any help with this

2 more questions on excel and vba
 

Jim,
the newer excel help files are poorly done<<<
Not just the Help files that are poorly done today.
Nothing today is done the way it used to be.
Cimjet
"Jim Cone" wrote in message
...
If the workbook has already been saved then... ActiveWorkbook.Save
It's in Excel's help file under "save".
(the newer excel help files are poorly done, so you get a mulligan <g)
--
Jim Cone
Portland, Oregon USA .
http://www.contextures.com/excel-sort-addin.html .
(a look at the Special Sort excel add-in (30 ways to sort)



"sparks"
wrote in message
...
I have a mess in a workbook that was sent to me in a chopped up manner
and I was expected to put it back into something usable.
this is a massive excel sheet.At least to me
over 1 million lines of data.

I do databases not excel so this has been a learning exp.

I am cutting it in 256column X30 rows at a time and pasting into a new
sheet.

anyway I get 1004 errors after about 8 loops of this trying to cut and
paste this much data.
Someone said save during your work and this will help.

ok I forgot to ask how do I do a save like this in vba?

Application.ActiveWorkbook.Save()
didn't work. I am not sure how to do a save like this.

second thing the data now looks like this

COL B
10/26/2011
9:28
9:40

I need to find the date and copy it from its current B1 to A1
how do I look thru a column of data and find just dates?


thanks again for any help with this

2 more questions on excel and vba
 

Still have not come up with a way to find a date in a column of data.
I am trying to find a date in col B:# and copy it to col A:#
is there a way to find a date in a column of dates and times?


On Wed, 26 Oct 2011 14:29:20 -0500, sparks wrote:

COL B
10/26/2011
9:28
9:40

2 more questions on excel and vba
 

Ok I got it.
I was trying to find something like isdate or something.
I just looked for */* in the cell and it works :)



On Wed, 02 Nov 2011 11:37:54 -0500, sparks wrote:

Still have not come up with a way to find a date in a column of data.
I am trying to find a date in col B:# and copy it to col A:#
is there a way to find a date in a column of dates and times?


On Wed, 26 Oct 2011 14:29:20 -0500, sparks wrote:

COL B
10/26/2011
9:28
9:40