Let user select file to open

Hello.

I have a script that imports a csv-file and delimit the inputs with colon.
Today the code is hard coded and I would like the user to be able to select which file to import.
How can I do this?

Current code:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

I don't know how this can be applied to your code up top there as this will actually open the csv as its own workbook, which is what you were asking for.

Originally Posted by Richard Buttrey

Hi

Please Login or Register  to view this content.

It seems to work well until the ....etc code starts.
I have written this way:

Please Login or Register  to view this content.

What is marked in red text is causing a problem since it is hardcoded filename without the extension.
Can I extract the filenamn from the stFName in some way?

/Anders

In the original code:

Please Login or Register  to view this content.

How can I get the filename into the .data-field?
It need to be the same filename as the imported filename.

Anders

Originally Posted by Richard Buttrey

Hi,

In much the same way as before but with an extra variable

Please Login or Register  to view this content.

Yes, I believe it should be this simple but my knowledge is very limited.
I still get an error though. "Application defined or object-defined error"

Please Login or Register  to view this content.

Any thoughts?

There are some differences from the orignial code:

Please Login or Register  to view this content.

Your code:

Please Login or Register  to view this content.

The parameter stfName = Returns only "data". Not data_267798_7267 so there is something wrong there as well.


Attachments
Here is the data file I am trying to import.
data_267798_7267.csv
Here is the xlsm file that imports the file. It is unfortunately in swedish. On the second slide There is a macro button that starts the import. (1.Hämta Data)
Orderhandling.zip