Silicon Investor (SI) -- The First Internet Community

STOCKTALK

We've detected that you're using an ad content blocking browser plug-in or feature. Ads provide a critical source of revenue to the continued operation of Silicon Investor. We ask that you disable ad blocking while on Silicon Investor in the best interests of our community. If you are not using an ad blocker but are still receiving this message, make sure your browser's tracking protection is set to the 'standard' level.

Pastimes : Computer Learning -- Ignore unavailable to you. Want to Upgrade?

To: Tigress who wrote (14694)	1/9/2001 1:09:07 AM
From: mr.mark	Read Replies (2) \| Respond to of 110652

hi tig i see that you're getting some excel assistance. that's terrific. i've had this tutorial bookmarked and pull it out every now and then. perhaps it may have some answers for you. usd.edu good luck :) mark

To: Tigress who wrote (14694)	1/9/2001 7:06:47 AM
From: thecow	Respond to of 110652

Tigress When writing in Excel () with a properly written macro to convert it to readable text in Notepad (*) what determines which DELIMITED should be used? They all seem to fit the description, so I'm somewhat confused I'm not an expert in Excel so I'm not sure about the answer to this question. I've only worked a little with Excel 97 and no nada about macros. I do know in 97 if you have spreadsheet info in .txt form (try copying some excel data and paste into notepad to get the idea) the data is pasted in tab delimited. To import back into excel open excel and open the txt file with the file/open menu command. That will bring up a wizard to guide you through the process. Hope this is fairly clear. Got to go to work so I'll try to get back to you later today to follow up. Here's a pic of the wizard. home.midsouth.rr.com tc

To: Tigress who wrote (14694)	1/9/2001 9:32:56 AM
From: PMS Witch	Respond to of 110652

Excel reading text stuff ... I use a macro to read two text files, one a simple list of dates, and the other containing several columns of numbers separated by commas. Maybe this will help. Sub Macro1() ' ' Macro1 Macro ' Macro recorded 4/26/99 by The Witch ' ' Keyboard Shortcut: Ctrl+A ' ' Range("A10").Select Workbooks.OpenText FileName:="F:\progress\DATELIST.DAT", Origin:=xlWindows, _ StartRow:=1, DataType:=xlDelimited, TextQualifier:=xlDoubleQuote, _ ConsecutiveDelimiter:=False, Tab:=True, Semicolon:=False, Comma:=True, _ Space:=False, Other:=False, FieldInfo:=Array(Array(1, 1)) Selection.CurrentRegion.Select Selection.Cut ActiveWorkbook.Close Range("A11").Select ActiveSheet.Paste Range("B10").Select Workbooks.OpenText FileName:="F:\progress\TABLE.DAT", Origin:=xlWindows, _ StartRow:=1, DataType:=xlDelimited, TextQualifier:=xlDoubleQuote, _ ConsecutiveDelimiter:=False, Tab:=True, Semicolon:=False, Comma:=True, _ Space:=False, Other:=False, FieldInfo:=Array(Array(1, 1), Array(2, 1), Array( _ 3, 1), Array(4, 1), Array(5, 1), Array(6, 1), Array(7, 1), Array(8, 1), Array(9, 1), Array(10 _ , 1), Array(11, 1), Array(12, 1), Array(13, 1)) Selection.CurrentRegion.Select Selection.Cut ActiveWorkbook.Close Range("B11").Select ActiveSheet.Paste End Sub Cheers, PW.