ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Multiple Workbooks Selection.text (https://www.excelbanter.com/excel-programming/369800-multiple-workbooks-selection-text.html)

mpeplow[_30_]

Multiple Workbooks Selection.text
 

Windows("Product Offering and Inventory Update
7-31-2006.csv").Sheets("Sheet1").Range("C" & i).Select
Selection.Text = NewQOH


Help me fix the mess above?! Object does not support property
Depends on how I "phrase" it but I keep getting Error 1004 and 424.

Tnx in advanced.


--
mpeplow
------------------------------------------------------------------------
mpeplow's Profile: http://www.excelforum.com/member.php...o&userid=34812
View this thread: http://www.excelforum.com/showthread...hreadid=569688


Bob Phillips

Multiple Workbooks Selection.text
 
Try using Workbooks not Windows.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"mpeplow" wrote in
message ...

Windows("Product Offering and Inventory Update
7-31-2006.csv").Sheets("Sheet1").Range("C" & i).Select
Selection.Text = NewQOH


Help me fix the mess above?! Object does not support property
Depends on how I "phrase" it but I keep getting Error 1004 and 424.

Tnx in advanced.


--
mpeplow
------------------------------------------------------------------------
mpeplow's Profile:

http://www.excelforum.com/member.php...o&userid=34812
View this thread: http://www.excelforum.com/showthread...hreadid=569688





All times are GMT +1. The time now is 12:14 PM.

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