Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() Wonder if something like this is possible - 'air' code to show example. -- Dim zz As Range Set zz = Worksheets("Sheet1").Range("S760:CD760") Open "c:\test" for output as #1 print # 1, zz Close 1 Then, Open "c:\test" for input as #1 get # 1, zz Close 1 -- I suspect I may need to do this Dim c as Range Open "c:\test" for output as #1 For Each c In zz print # 1,c.Value Next c Close 1 And Open "c:\test" for input as #1 Do line input # 1, zz Somehow put zz back into the range ??? loop until eof(1) Close 1 -- Thanks - Kirk |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
A save/load txt UserForm | Excel Programming | |||
Save/Load txt files UserForm question | Excel Programming | |||
How to d/load & save web pages w/VBA? | Excel Programming | |||
avoiding Load/Save Dialog | Charts and Charting in Excel | |||
Excel is very slow to load/save the spreadsheet | Excel Programming |