Open unknown file name

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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
> news:[email protected]...
> > 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" <[email protected]> wrote in message
> > news:[email protected]...
> > > 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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
> > > news:[email protected]...
> > > > 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.
> > >
> > >
> > >