Store FilePath Inside Code

Hello,

I have a macro that pastes data into a file, say File A, from all files in a
specific folder. I'm trying to enhance the macro by having a MessegeBox pop
up before the macro executes that asks whether the uses wants to use a
different folder than the one used previously. If the uses clicks "Yes" on
the MessegeBox, an InputBox pops up that asks the user for the path of the
new file.

The problem is that I if the user clicks "Yes" in the MessegeBox and enters
a new folder in the InputBox, I need to be able to store the path, so that
next time, if the user clicks "No", the macro will know the path to the
previously used folder.

Any help on how to accomplish the above would be greatly appreciated.

Thank You!

Magnivy

http://www.j-walk.com/ss/excel/tips/tip29.htm

can't you write it to a cell, perhaps on a hidden sheet.

--
Regards,
Tom Ogilvy


"Magnivy" wrote:

> Hello,
>
> I have a macro that pastes data into a file, say File A, from all files in a
> specific folder. I'm trying to enhance the macro by having a MessegeBox pop
> up before the macro executes that asks whether the uses wants to use a
> different folder than the one used previously. If the uses clicks "Yes" on
> the MessegeBox, an InputBox pops up that asks the user for the path of the
> new file.
>
> The problem is that I if the user clicks "Yes" in the MessegeBox and enters
> a new folder in the InputBox, I need to be able to store the path, so that
> next time, if the user clicks "No", the macro will know the path to the
> previously used folder.
>
> Any help on how to accomplish the above would be greatly appreciated.
>
> Thank You!
>
> Magnivy

That would work too. I just thought that there might be some easy way to
store the path inside the code that I didnt come across.

Thanks for your help!

Magnivy

"Tom Ogilvy" wrote:

> http://www.j-walk.com/ss/excel/tips/tip29.htm
>
> can't you write it to a cell, perhaps on a hidden sheet.
>
> --
> Regards,
> Tom Ogilvy
>
>
> "Magnivy" wrote:
>
> > Hello,
> >
> > I have a macro that pastes data into a file, say File A, from all files in a
> > specific folder. I'm trying to enhance the macro by having a MessegeBox pop
> > up before the macro executes that asks whether the uses wants to use a
> > different folder than the one used previously. If the uses clicks "Yes" on
> > the MessegeBox, an InputBox pops up that asks the user for the path of the
> > new file.
> >
> > The problem is that I if the user clicks "Yes" in the MessegeBox and enters
> > a new folder in the InputBox, I need to be able to store the path, so that
> > next time, if the user clicks "No", the macro will know the path to the
> > previously used folder.
> >
> > Any help on how to accomplish the above would be greatly appreciated.
> >
> > Thank You!
> >
> > Magnivy

You can modify code with code, but I wouldn't call it easy and if you want
to lock your code, then that isn't an option.

http://www.cpearson.com/excel/vbe.htm

--
Regards,
Tom Ogilvy


"Magnivy" wrote:

> That would work too. I just thought that there might be some easy way to
> store the path inside the code that I didnt come across.
>
> Thanks for your help!
>
> Magnivy
>
> "Tom Ogilvy" wrote:
>
> > http://www.j-walk.com/ss/excel/tips/tip29.htm
> >
> > can't you write it to a cell, perhaps on a hidden sheet.
> >
> > --
> > Regards,
> > Tom Ogilvy
> >
> >
> > "Magnivy" wrote:
> >
> > > Hello,
> > >
> > > I have a macro that pastes data into a file, say File A, from all files in a
> > > specific folder. I'm trying to enhance the macro by having a MessegeBox pop
> > > up before the macro executes that asks whether the uses wants to use a
> > > different folder than the one used previously. If the uses clicks "Yes" on
> > > the MessegeBox, an InputBox pops up that asks the user for the path of the
> > > new file.
> > >
> > > The problem is that I if the user clicks "Yes" in the MessegeBox and enters
> > > a new folder in the InputBox, I need to be able to store the path, so that
> > > next time, if the user clicks "No", the macro will know the path to the
> > > previously used folder.
> > >
> > > Any help on how to accomplish the above would be greatly appreciated.
> > >
> > > Thank You!
> > >
> > > Magnivy