Quite awhile ago I located the perfect solution on this site by using a
button (I believe) to first choose a file (not knowing the file name) and
then the file would open using a macro which parsed the file as needed.
Unfortunately my hard drive recently took a vacation and never returned. I
have search the site again hoping to find something similar to recreate this
solution but with no success.
The problem: I receive data files often which I need to open in Excel and
automatically parse to the required positions. I would click this button,
choose the file I wished to open and the macro would do the rest. I have
recreated the macro and am looking for the rest of the puzzle.
Thank you for your help.

Jan,
You mean Application.GetOpenFilename ?

NickHK

"Jan" wrote in message
...
Quite awhile ago I located the perfect solution on this site by using a
button (I believe) to first choose a file (not knowing the file name) and
then the file would open using a macro which parsed the file as needed.
Unfortunately my hard drive recently took a vacation and never returned. I
have search the site again hoping to find something similar to recreate
this
solution but with no success.
The problem: I receive data files often which I need to open in Excel and
automatically parse to the required positions. I would click this button,
choose the file I wished to open and the macro would do the rest. I have
recreated the macro and am looking for the rest of the puzzle.
Thank you for your help.

I humbly admit I look for and apply solutions to make my job more efficient.
I understand enough to be dangerous (thankfully only for myself). After I
found and implemented the solution a few years ago, I honestly don't remember
what function was used as I haven't had to do much 'personal problem solving'
in Excel since. I know there are two parts. One was changing a bit of code in
the macro itself, similar - but not exactly - to the post of 2/7/06 Importing
files, and the second part was creating a new Excel file with a lone radio
button which when clicked, would call the macro and open the file of my
choosing into a new workbook. I really do appreciate all the Community Groups
as they have pointed me in the right direction many times.
Thank you for your patience.

"NickHK" wrote:

Jan,
You mean Application.GetOpenFilename ?

NickHK

"Jan" wrote in message
...
Quite awhile ago I located the perfect solution on this site by using a
button (I believe) to first choose a file (not knowing the file name) and
then the file would open using a macro which parsed the file as needed.
Unfortunately my hard drive recently took a vacation and never returned. I
have search the site again hoping to find something similar to recreate
this
solution but with no success.
The problem: I receive data files often which I need to open in Excel and
automatically parse to the required positions. I would click this button,
choose the file I wished to open and the macro would do the rest. I have
recreated the macro and am looking for the rest of the puzzle.
Thank you for your help.

I have recreated the Excel file radio button which points to the macro
successfully. I'm now working on getting the macro to allow me to select a
file. I will work with the Application.GetOpenFilename function, as that
seems to be what I need to add at the beginning of my macro code.
Thank you again for your help.

"Jan" wrote:

I humbly admit I look for and apply solutions to make my job more efficient.
I understand enough to be dangerous (thankfully only for myself). After I
found and implemented the solution a few years ago, I honestly don't remember
what function was used as I haven't had to do much 'personal problem solving'
in Excel since. I know there are two parts. One was changing a bit of code in
the macro itself, similar - but not exactly - to the post of 2/7/06 Importing
files, and the second part was creating a new Excel file with a lone radio
button which when clicked, would call the macro and open the file of my
choosing into a new workbook. I really do appreciate all the Community Groups
as they have pointed me in the right direction many times.
Thank you for your patience.

"NickHK" wrote:

Jan,
You mean Application.GetOpenFilename ?

NickHK

"Jan" wrote in message
...
Quite awhile ago I located the perfect solution on this site by using a
button (I believe) to first choose a file (not knowing the file name) and
then the file would open using a macro which parsed the file as needed.
Unfortunately my hard drive recently took a vacation and never returned. I
have search the site again hoping to find something similar to recreate
this
solution but with no success.
The problem: I receive data files often which I need to open in Excel and
automatically parse to the required positions. I would click this button,
choose the file I wished to open and the macro would do the rest. I have
recreated the macro and am looking for the rest of the puzzle.
Thank you for your help.

Jan,
You are aware that you can record a macro to obtain code for most actions.
Whilst not great code, it gives you concept of what will be required.
Add a .GetOpenFile and use that filename in the Workbooks.Open.

Post back with your basic code if you still have problems.

NickHK

"Jan" wrote in message
...
I have recreated the Excel file radio button which points to the macro
successfully. I'm now working on getting the macro to allow me to select a
file. I will work with the Application.GetOpenFilename function, as that
seems to be what I need to add at the beginning of my macro code.
Thank you again for your help.

"Jan" wrote:

I humbly admit I look for and apply solutions to make my job more
efficient.
I understand enough to be dangerous (thankfully only for myself). After
I
found and implemented the solution a few years ago, I honestly don't
remember
what function was used as I haven't had to do much 'personal problem
solving'
in Excel since. I know there are two parts. One was changing a bit of
code in
the macro itself, similar - but not exactly - to the post of 2/7/06
Importing
files, and the second part was creating a new Excel file with a lone
radio
button which when clicked, would call the macro and open the file of my
choosing into a new workbook. I really do appreciate all the Community
Groups
as they have pointed me in the right direction many times.
Thank you for your patience.

"NickHK" wrote:

Jan,
You mean Application.GetOpenFilename ?

NickHK

"Jan" wrote in message
...
Quite awhile ago I located the perfect solution on this site by
using a
button (I believe) to first choose a file (not knowing the file
name) and
then the file would open using a macro which parsed the file as
needed.
Unfortunately my hard drive recently took a vacation and never
returned. I
have search the site again hoping to find something similar to
recreate
this
solution but with no success.
The problem: I receive data files often which I need to open in
Excel and
automatically parse to the required positions. I would click this
button,
choose the file I wished to open and the macro would do the rest. I
have
recreated the macro and am looking for the rest of the puzzle.
Thank you for your help.