Multiple Workbooks Selection.text

  • Thread starter Thread starter mpeplow
  • Start date Start date
M

mpeplow

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.
 
Try using Workbooks not Windows.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Save As and new workbook new name used in existing code 8
Difference between Selection.Text and Shape.AlternativeText? 5
How to clear contents of multiple cells in Excel simultaneously 1
Fetch data from multiple .csv file paste into single sheet 5
Cell values to an array, then array transpose to another workbook 8
SEARCHING A WORKBOOK ! ! 2
Import multiple csv files into current workbook as separate sheets 3
Import multiple workbooks to current workbook in specified row number 0

Back
Top