Previous Topic Next Topic

Excecl Range Name to import a CSV file

Closed
Rick - 19 Jan 2011 à 16:37
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 20 Jan 2011 à 07:01
Hello,

For those who remember Lotus, it was possible to use file import numbers into a spreadsheet using a range name. For example, Cell A1 is named "Datafile" and the lotus macro would indicate the Path to where "Datafile" was located. The actual name of the file is entered into Cell A1. This allows the user to specify the name of the file to import. My question is, how do I write the code in Excel 2003 (since Excel no longer supports Lotus macros) for the user to enter a file to import?

Thanks in advance.

Related:

1 response

Réponse 1 / 1
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
20 Jan 2011 à 07:01
My exposure to lotus was limited, so I am wondering why not have a dialog box where the user browse to the file to select. Could you post your lotus macro ?