Results 1 to 2 of 2
2002-04-19, 21:10 #1
- Join Date
- Mar 2002
- Austin, TX,USA
- Thanked 0 Times in 0 Posts
RE: Selecting Ranges (VBA, Excel97, etc)
I am new at the VBA part. I have been using spreadsheets for as far back as "SUPERCALC", so I have a pretty good handle on Excel.
I guess I should think this thing out in its' entirity before I squeak. Below is the sub I use to get the text file into a worksheet;
' GetViewFile Macro
' Macro recorded 4/18/2002 by ochalo
' 'Open Dialog box is displayed and
'user selects file to be opened and clicks "OK"
myFile = Application.GetOpenFilename("Text Files,*.txt")
'Opens the selected fine in the current worksheet
This is probably somewhat inelegent to most of you. But it seemed to be a miracle when I figured out how to get the
textfile into a worksheet.
My ultimate goal is to create a list which I can use as a database. Hoping I will be able to move the thing from EXCEL to ACCESS. This should be a pretty good learning experience.
2002-04-23, 05:03 #2
- Join Date
- Dec 2000
- Sacramento, California, USA
- Thanked 1 Time in 1 Post
Re: RE: Selecting Ranges (VBA, Excel97, etc)
Did you have a question relating to this code? If this is related to either of the other threads you started, you can't expect other loungers to figure that out. If you need assistance, please explain what you are trying to do and what isn't working or where you need help. Then someone can try to assist you.Charlotte