[Solved] Get file path from user & paste in macro variable

[Kprogrammer]

In my macro coding
I am giving 3 urls for file path
1. Url1 - For source file using which I modify data in file 2.
2.Url2 -Destination file
3.Url3- path where destination file is saved

These urls change daily. I have to give path in my macro code.

I want a functionality using which select files and save files.
I can browse files and it's path will be stored in url1 and url2 and url3 variables of macro code

Please suggest how can I achieve this.

[JeJe]

Andrew Pitonyak's AndrewMacro.pdf has an example:

Choosing a File Using the File Dialog

http://www.pitonyak.org/oo.php

[Villeroy]

If you would look at any of the example files I pointed you to, then you would have noticed a working file picker dialog.

[Kprogrammer]

Yes Villeroy.I looked at SheetMerger.ots File it is selecting a folder.
how can i go inside that folder and select file??

[Villeroy]

Well, yes. It is a folder picker. But meanwhile you should be able to find what you need. Or do you believe we know all that shit by heart?

[Kprogrammer]

I am really very sorry if I asked something wrong.
I just wanted to get the exact solution for it.
I am a beginner with open office macro code and knowing too many new and good things from the forum about it which is very interesting and helpful for me.
That's why I am taking time to understand the solution provided by you and all.I am making efforts to understand working of code by reading the documents also.
I would like to thanks everyone who responded to my queries.
Again I am very sorry if I asked something silly , or the way I am responding is wrong. I realized and accepting it too.