ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Create a macro to select items from an existing list .... (https://www.excelbanter.com/excel-programming/320198-create-macro-select-items-existing-list.html)

Marc

Create a macro to select items from an existing list ....
 
...... and copy them to a text file which will used in IntelligentApps.

I have managed to select the data from the list but when I try to save the
copied items to a text file, the debugger states no object found.

Help please!

Marc

Tom Ogilvy

Create a macro to select items from an existing list ....
 
copy the items to a single sheet workbook and then save that as a text file.

--
Regards,
Tom Ogilvy


"Marc" wrote in message
...
..... and copy them to a text file which will used in IntelligentApps.

I have managed to select the data from the list but when I try to save the
copied items to a text file, the debugger states no object found.

Help please!

Marc




Bob Phillips[_6_]

Create a macro to select items from an existing list ....
 
.... show the code.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Marc" wrote in message
...
..... and copy them to a text file which will used in IntelligentApps.

I have managed to select the data from the list but when I try to save the
copied items to a text file, the debugger states no object found.

Help please!

Marc




Marc

Create a macro to select items from an existing list ....
 
Thanks - how simple but it worked! Thanks.

"Tom Ogilvy" wrote:

copy the items to a single sheet workbook and then save that as a text file.

--
Regards,
Tom Ogilvy


"Marc" wrote in message
...
..... and copy them to a text file which will used in IntelligentApps.

I have managed to select the data from the list but when I try to save the
copied items to a text file, the debugger states no object found.

Help please!

Marc






All times are GMT +1. The time now is 02:06 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com