Dear Amar,
Use below code with little bit correction in red color
This code has been modify as per Krish's solution.
Hope it will help to you
See attached sheet...
Dim IFileName As Variant
Dim SFileName As Variant
Public Sub Lfile_Name()
IFileName = Application.GetOpenFilename("Excel Files
Hi Kris,
I don't have your code, Can you please forward?
Thanks,
Amar
On 09/02/2012, Kris wrote:
> Hi
>
> Have you tred mine ?
>
>
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need He
Hi
Have you tred mine ?
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don'
Hi Noorain,
I'm getting error ... Can you please try your code and check?
thanks,
Amar
On 08/02/2012, Kasireddy Amarender wrote:
> Thanks Noorain!
>
> Simple and Superb!
>
> On 08/02/2012, NOORAIN ANSARI wrote:
>> Dear Amarender,
>>
>> Please use it..
>>
>> Public Sub Lfile_Name()
>> Dim IFile
Thanks Noorain!
Simple and Superb!
On 08/02/2012, NOORAIN ANSARI wrote:
> Dear Amarender,
>
> Please use it..
>
> Public Sub Lfile_Name()
> Dim IFileName As Variant
> IFileName = Application.GetOpenFilename("Excel Files (*.xls),*.xls")
> MsgBox IFileName
> End Sub
> Public Sub SFile_Name()
> Dim
Dear Amarender,
Please use it..
Public Sub Lfile_Name()
Dim IFileName As Variant
IFileName = Application.GetOpenFilename("Excel Files (*.xls),*.xls")
MsgBox IFileName
End Sub
Public Sub SFile_Name()
Dim SFileName As Variant
SFileName = Application.GetOpenFilename("Excel Files (*.xls),*.xls")
MsgB
Hi Team,
I would like to know if I can use the value of one procedure as input
to the other procedure.
For example:
I have a user form, it has two command buttons, the first one is
requesting for a file location(address/path) and the second does also
requesting another file location (address/pa
