J
JLatham
I need help helping someone. They are using Excel on a Mac and apparently I
know even less than I thought I did about programming in VBA on that
platform (which was pretty much nothing - no experience with it at all).
Can anyone point me to some code snippets or help regarding these areas:
#1: Using Application.GetOpenFilename() on that platform? User gets Error
1004 when trying it the Windows way.
#2: Once I've got a file path/name, how to open it for read? The file is
actually a text file, one field of a record per row, with several rows making
up one record. To be specific, trying to read a QIF file - Intuit Quickbooks
format. Like a .csv file, it's basically just sequential ASCII data.
#3: proper code to do the equivalent of
filebuffer=Freefile()
Do While Not EOF(#filebuffer)
Line Input #filebuffer, OneLineFromFile
.....process that text data
Loop
and of course, How to properly close the text file.
This whole exercise is making me feel quite inadequate!
know even less than I thought I did about programming in VBA on that
platform (which was pretty much nothing - no experience with it at all).
Can anyone point me to some code snippets or help regarding these areas:
#1: Using Application.GetOpenFilename() on that platform? User gets Error
1004 when trying it the Windows way.
#2: Once I've got a file path/name, how to open it for read? The file is
actually a text file, one field of a record per row, with several rows making
up one record. To be specific, trying to read a QIF file - Intuit Quickbooks
format. Like a .csv file, it's basically just sequential ASCII data.
#3: proper code to do the equivalent of
filebuffer=Freefile()
Do While Not EOF(#filebuffer)
Line Input #filebuffer, OneLineFromFile
.....process that text data
Loop
and of course, How to properly close the text file.
This whole exercise is making me feel quite inadequate!