Export Worksheet Data Problem
 

The first row is blank and shows all "" correctly. The 2nd row shows the data
correctly also, but stops on the 2nd row.

I'm using and trying to get Chip's code to work and it will not go past the
2nd row. I have 42 rows of data and 12 columns. I'm using his export code
from: http://www.cpearson.com/excel/imptext.htm#Export

I have data in rows 3-42, with some blank rows and in columns A-I with some
blank columns. I also have a few buttons, but do not expect/need those
exported.

I'm using this to export setups, and then reimport then into the same
worksheet. Any help would be appreciated.

Export Worksheet Data Problem
 

David,

The code works as expected for me. Do you have the SelectionOnly parameter
set to True? If so, you MUST select the entire range of data you want to
export. Otherwise, it will export only the active cell. If you want to
export the entire worksheet, make sure SelectionOnly is False.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
www.cpearson.com
(email address is on the web site)



"David" wrote in message
...
The first row is blank and shows all "" correctly. The 2nd row shows the
data
correctly also, but stops on the 2nd row.

I'm using and trying to get Chip's code to work and it will not go past
the
2nd row. I have 42 rows of data and 12 columns. I'm using his export code
from: http://www.cpearson.com/excel/imptext.htm#Export

I have data in rows 3-42, with some blank rows and in columns A-I with
some
blank columns. I also have a few buttons, but do not expect/need those
exported.

I'm using this to export setups, and then reimport then into the same
worksheet. Any help would be appreciated.

Export Worksheet Data Problem
 

It was set to true, I set to False.
I tried the entire spreadsheet option, only did the first two rows again.
I tried just selected and it only did the first cell.
I "selected" all the cells with data (A1:L42) and tried both again with the
same result, but I did the selection manaually.
Should I put the selection in the code?
Could I send you my worksheet?
Let me know and thank you much for your assistance.

David

"Chip Pearson" wrote:

David,

The code works as expected for me. Do you have the SelectionOnly parameter
set to True? If so, you MUST select the entire range of data you want to
export. Otherwise, it will export only the active cell. If you want to
export the entire worksheet, make sure SelectionOnly is False.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
www.cpearson.com
(email address is on the web site)



"David" wrote in message
...
The first row is blank and shows all "" correctly. The 2nd row shows the
data
correctly also, but stops on the 2nd row.

I'm using and trying to get Chip's code to work and it will not go past
the
2nd row. I have 42 rows of data and 12 columns. I'm using his export code
from: http://www.cpearson.com/excel/imptext.htm#Export

I have data in rows 3-42, with some blank rows and in columns A-I with
some
blank columns. I also have a few buttons, but do not expect/need those
exported.

I'm using this to export setups, and then reimport then into the same
worksheet. Any help would be appreciated.

Export Worksheet Data Problem
 

Send the workbook to and I'll have a look at it.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
www.cpearson.com
(email address is on the web site)


"David" wrote in message
...
It was set to true, I set to False.
I tried the entire spreadsheet option, only did the first two rows again.
I tried just selected and it only did the first cell.
I "selected" all the cells with data (A1:L42) and tried both again with
the
same result, but I did the selection manaually.
Should I put the selection in the code?
Could I send you my worksheet?
Let me know and thank you much for your assistance.

David

"Chip Pearson" wrote:

David,

The code works as expected for me. Do you have the SelectionOnly
parameter
set to True? If so, you MUST select the entire range of data you want to
export. Otherwise, it will export only the active cell. If you want to
export the entire worksheet, make sure SelectionOnly is False.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
www.cpearson.com
(email address is on the web site)



"David" wrote in message
...
The first row is blank and shows all "" correctly. The 2nd row shows
the
data
correctly also, but stops on the 2nd row.

I'm using and trying to get Chip's code to work and it will not go past
the
2nd row. I have 42 rows of data and 12 columns. I'm using his export
code
from: http://www.cpearson.com/excel/imptext.htm#Export

I have data in rows 3-42, with some blank rows and in columns A-I with
some
blank columns. I also have a few buttons, but do not expect/need those
exported.

I'm using this to export setups, and then reimport then into the same
worksheet. Any help would be appreciated.

Export Worksheet Data Problem
 

I think I figured it out...the next row has cells with formulas in it.

"Chip Pearson" wrote:

David,

The code works as expected for me. Do you have the SelectionOnly parameter
set to True? If so, you MUST select the entire range of data you want to
export. Otherwise, it will export only the active cell. If you want to
export the entire worksheet, make sure SelectionOnly is False.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
www.cpearson.com
(email address is on the web site)



"David" wrote in message
...
The first row is blank and shows all "" correctly. The 2nd row shows the
data
correctly also, but stops on the 2nd row.

I'm using and trying to get Chip's code to work and it will not go past
the
2nd row. I have 42 rows of data and 12 columns. I'm using his export code
from: http://www.cpearson.com/excel/imptext.htm#Export

I have data in rows 3-42, with some blank rows and in columns A-I with
some
blank columns. I also have a few buttons, but do not expect/need those
exported.

I'm using this to export setups, and then reimport then into the same
worksheet. Any help would be appreciated.