>
> Congratulations Prince ji..
>
Regards
Priyanka
>
> On Saturday, February 2, 2013 11:49:07 AM UTC+5:30, Ayush Jain wrote:
>>
>>
>> Dear members,
>>
>> Prince Kumar has been selected as 'Most Helpful Member' for the month of
>> Jan'13. He has posted 103 posts last month and helped forum mem
Dear Rajan,
If there are more than 4 table range data then there no problem about excel
size increase? And also can we expand range whatever we need,there is no
issue?
Regards
Amar
On Sat, Feb 9, 2013 at 10:42 AM, amar takale wrote:
> Dear Rajan,
> This is Excellent, mind blowing trick,I like it
Dear Rajan,
This is Excellent, mind blowing trick,I like it very..much & I
used it in my future Excel work.
Thanks alot
**
Regards Amar
On Fri, Feb 8, 2013 at 9:29 PM, Shekhar wrote:
> A good trick Rajan, Thanks for your post.
>
>
> Thanks and regards,
> Shekhar
>
> --
> Are you =E
Dear Shankar,
This is also mind blowing solution,In my mind never thought its will work
properly,rajan trick also fantastic.I ask you one question in VBA
range isG:Z ,it
is fixed range? or We expand this range.I try to expand it & also Data
table Expand automatically. Then why it is G:Z.If range da
Hi Santosh,
instead of trying for institutes i think u should try to get IGNOU's BCA
programs Data Base Management System book this will provide every think
with practical example of Access what ever you want to learn in Access
Regards
Prince
On Saturday, February 9, 2013 3:30:30 AM UTC+5:30,
Sub choose_file()
Dim flname As String
Dim fd As FileDialog, fl As Variant
Set fd = Application.FileDialog(msoFileDialogFilePicker)
With fd
.AllowMultiSelect = False
.Title = "Please choose the file"
' .Filters.Add "Excel Files", "*.xls*", 1
.Show
see if it help , i did it by CF
On Fri, Feb 8, 2013 at 9:04 AM, Kenil Gala wrote:
> Hi group,
> I have a small IF related query.
>
> i want an answer for two logical tests at a same time. Pls chk my file
> attached.
>
> Thanks in adv.
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And
=IF(AND(A7>A6,A7>A5),"Green",IF(AND(A7 wrote:
> Hi group,
> I have a small IF related query.
>
> i want an answer for two logical tests at a same time. Pls chk my file
> attached.
>
> Thanks in adv.
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,
Hi group,
I have a small IF related query.
i want an answer for two logical tests at a same time. Pls chk my file attached.
Thanks in adv.
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://w
A good trick Rajan, Thanks for your post.
Thanks and regards,
Shekhar
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thr
So.. you're saying that you want the macro to open a dialog box so the user can
browse to a folder?
If so,
look into the help screens for FileDialog
the dialog type you want to get the name of a folder is:
msoFileDialogFolderPicker
Paul
-
“Do all the good
Looks great and interesting.
Interested to know if you have a used a macro or some formula. If possible,
Pl. explain so that we can learn.
On Fri, Feb 8, 2013 at 8:42 PM, rajan verma wrote:
> see if it helps
>
>
> On Fri, Feb 8, 2013 at 5:19 AM, amar takale wrote:
>
>> Dear All,
>> Pls suggest a
neeraj, very bad subject and query explaination
On Fri, Feb 8, 2013 at 2:17 AM, neeraj chauhan
wrote:
> thanks sir,
>
> its working thanks again
>
>
> On Fri, Feb 8, 2013 at 2:16 PM, NOORAIN ANSARI
> wrote:
>
>> Dear Neeraj,
>>
>> You can use..
>>
>> =EDATE(A2,6)
>>
>> or
>>
>> =DATE(YEAR(A2),MO
Hi Amar,
Please find attached file which meets your requirements. Please let us know
if it works fine.
Thanks and regards,
Shekhar
On Friday, February 8, 2013 5:49:52 PM UTC+5:30, amar takale wrote:
>
> Dear All,
> Pls suggest any Solution for this work. I think it is hard & confusing
> work
Hi Chandra Shekar,
Here again you need to be specific, whether you need the path of
particular FILE or FOLDER.
Thanks and regards,
Shekhar
On Friday, February 8, 2013 8:16:37 PM UTC+5:30, Chandru wrote:
>
> Hi,
>
> Thanks for your reply. not any path it should be user friendly like user
> s
"the path of the folder"?
which folder would that be?
any in particular?
If you want the folder for the excel file that has the VBA,
The path is: ThisWorkbook.Path
the file name is: ThisWorkbook.Name
The path and file name is: ThisWorkbook.FullName
If you're wanting some other folder, you're g
Hi Vijay,
could you Please change the code. File name should come like this
"KAM Tracker [tab name]"
Regards,
Santhosh
On Fri, Feb 1, 2013 at 11:30 PM, vijayajith VA wrote:
> Hi Sandhosh.
>
> Sub Splitsht()
>
> ChDir "C:\Documents and Settings\user\Desktop\folder"
>
> Dim wrksht As Worksheet
Hi,
Is there any way to get path of the folder using VBA?
Thanks in advance.
Regards,
Chandra Shekar B
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM
Hi Paul
Thanks for the code, even though my explanation is not so clear you give
the right code for me.
With regards & thanks
Rajesh
On Friday, February 8, 2013 5:59:19 PM UTC+5:30, Paul Schreiner wrote:
>
> What you've described is confusing.
> But, let me explain how to loop through sheets
What you've described is confusing.
But, let me explain how to loop through sheets and execute a macro for each
sheet:
Assuming you want to process ALL sheets in the workbook:
Sub Process_All_Sheets()
For Sht = 1 to Sheets.Count
sheets(sht).select
Execute_Changes
Next Sht
End Sub
Dear All,
Pls suggest any Solution for this work. I think it is hard & confusing work
but it is possible?
Guide me,Appreciate the help
Regards
Amar
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
http
Dear All,
There is possible to extract Price Data from Website then on that data
chart will update automatically.
Regards
Amar
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/
thanks sir,
its working thanks again
On Fri, Feb 8, 2013 at 2:16 PM, NOORAIN ANSARI wrote:
> Dear Neeraj,
>
> You can use..
>
> =EDATE(A2,6)
>
> or
>
> =DATE(YEAR(A2),MONTH(A2)+6,DAY(A2))
>
>
>
> On Fri, Feb 8, 2013 at 1:35 PM, neeraj chauhan > wrote:
>
>> Dear Experts,
>>
>> kindly find the at
Dear Neeraj,
You can use..
=EDATE(A2,6)
or
=DATE(YEAR(A2),MONTH(A2)+6,DAY(A2))
On Fri, Feb 8, 2013 at 1:35 PM, neeraj chauhan
wrote:
> Dear Experts,
>
> kindly find the attached sheet i want the add the 6 or 7 months in
> particular date.
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Exc
24 matches
Mail list logo
