Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. 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. #3: proper code to do the equivalent of 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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Problem with handling on error when file is already open | Excel Programming | |||
File Handling | Excel Programming | |||
handling the print to file prompt | Excel Programming | |||
file handling 2 | Excel Programming | |||
file handling | Excel Programming |