Excecl Range Name to import a CSV file
Closed
Rick
-
Jan 19, 2011 at 04:37 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jan 20, 2011 at 07:01 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jan 20, 2011 at 07:01 AM
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.
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:
- Excecl Range Name to import a CSV file
- Windows 10 iso file download 64-bit - Download - Windows
- Import sim contacts - Guide
- Messenger file downloader - Guide
- Dvi file - Guide
- Safari cannot open the page because it is a local file - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Jan 20, 2011 at 07:01 AM
Jan 20, 2011 at 07:01 AM
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 ?
