Re: $$Excel-Macros$$ Need a code to update the non existing data

[Ganesh N]

Hi Ravinder sir,

The Prj code mostly will repeat (week on week the Prj code will be same
only date and value will change) . So I need to check the date and
respective prj code so it wont be duplicate. If I already updated for
current week I need a msg else it should update. Can you please help me on
that ?

Thanks & Regards,
Ganesh N


On Sun, Apr 27, 2014 at 11:20 AM, ravinder negi  wrote:

> hi, please visit below link for your solution, please advise if anything
> else required.
>
> http://excelvbasupport.com/forum/showthread.php?tid=15
>
> Note I have checked only code number.
>
>
> On Sat, Apr 26, 2014 at 7:20 PM, Ganesh N  wrote:
>
>> Hi Team,
>>
>> I need to update the data in second sheet. before that i want to check
>> the data is already updated or not if already updated i need a msg else the
>> data needs to be update (I want to check the date and prj code, becoz week
>> on week prj and date will change. so i dont want to make a duplicate ). I
>> wrote coding for update the data. I need a code to check the condition.
>> Kindly help me on that.
>>
>> Please find the attachment for your reference.
>>
>> Thanks & Regards,
>> Ganesh N
>>
>> --
>> 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 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't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to excel-macros+unsubscr...@googlegroups.com.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> Visit this group at http://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>  --
> 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 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't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
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 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't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ please help for consolidate in excel

[Ganesh N]

Hi Yadav,

you can also use this. Just put the data files in separate folder and put
the path in cell "J2".

Thanks & Regards,
Ganesh N


On Sun, Apr 27, 2014 at 11:16 AM, Vaibhav Joshi  wrote:

> Hi,
>
> You can try this excellent codes share by Ashish earlier this month:
>
> Sub merge()
>
> Dim fld As Object, fil As Object, fso As Object, fldpath
> With Application.FileDialog(msoFileDialogFolderPicker)
> .Title = "Choose the folder"
> .Show
> End With
> On Error Resume Next
> fldpath = 
> Application.FileDialog(msoFileDialogFolderPicker).SelectedItems(1)
> & "\"
> If fldpath = False Then
> MsgBox "Folder Not Selected"
> Exit Sub
> End If
>
> Set fso = CreateObject("scripting.filesystemobject")
> Set fld = fso.getfolder(fldpath)
> Application.DisplayAlerts = False
> Application.ScreenUpdating = False
> For Each fil In fld.Files
> If Right(fil.Name, 4) = ".xls" And fil.Name <> ThisWorkbook.Name
> Then Call import_data(fil.Path)
> Next
> Application.DisplayAlerts = True
> Application.ScreenUpdating = True
>
> End Sub
>
>
>
> Sub import_data(filename As String)
> Dim wkb As Workbook
> Dim lastrow As Long
> lastrow = ThisWorkbook.Sheets("Sheet1").Range("a65356").End(xlUp).Row
> + 1
> Set wkb = Workbooks.Open(filename)
> wkb.Sheets("Summary Sheet").Range("e2:j2").Copy
> Destination:=ThisWorkbook.Sheets("Sheet1").Range("a" & lastrow)
> wkb.Sheets("Summary Sheet").Range("b13:f13").Copy
> Destination:=ThisWorkbook.Sheets("Sheet1").Range("g" & lastrow)
> wkb.Close
>
> End Sub
>
> Thanks
>
>
> On Sun, Apr 27, 2014 at 9:44 AM, Jitendra Yadav wrote:
>
>> Hi All,
>>
>> I have some data for date wise but I want all excel file in one sheet
>> through macro.
>>
>>
>>
>> Example.
>>
>>
>>
>>
>> Regards,
>> Jitendra//9650449202
>>
>> --
>> 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 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't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE  : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to excel-macros+unsubscr...@googlegroups.com.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> Visit this group at http://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>  --
> 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 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't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
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 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't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Ac

Re: $$Excel-Macros$$ Need a code to update the non existing data

[ravinder negi]

hi, please visit below link for your solution, please advise if anything
else required.

http://excelvbasupport.com/forum/showthread.php?tid=15

Note I have checked only code number.


On Sat, Apr 26, 2014 at 7:20 PM, Ganesh N  wrote:

> Hi Team,
>
> I need to update the data in second sheet. before that i want to check the
> data is already updated or not if already updated i need a msg else the
> data needs to be update (I want to check the date and prj code, becoz week
> on week prj and date will change. so i dont want to make a duplicate ). I
> wrote coding for update the data. I need a code to check the condition.
> Kindly help me on that.
>
> Please find the attachment for your reference.
>
> Thanks & Regards,
> Ganesh N
>
> --
> 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 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't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
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 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't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ Need a code to update the non existing data

[Ganesh N]

Hi Team,

Any update on my request ?

Thanks & Regards,
Ganesh N


On Sun, Apr 27, 2014 at 7:50 AM, Ganesh N  wrote:

> Hi Team,
>
> I need to update the data in second sheet. before that i want to check the
> data is already updated or not if already updated i need a msg else the
> data needs to be update (I want to check the date and prj code, becoz week
> on week prj and date will change. so i dont want to make a duplicate ). I
> wrote coding for update the data. I need a code to check the condition.
> Kindly help me on that.
>
> Please find the attachment for your reference.
>
> Thanks & Regards,
> Ganesh N
>
> --
> 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 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't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
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 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't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ please help for consolidate in excel

[Vaibhav Joshi]

Hi,

You can try this excellent codes share by Ashish earlier this month:

Sub merge()

Dim fld As Object, fil As Object, fso As Object, fldpath
With Application.FileDialog(msoFileDialogFolderPicker)
.Title = "Choose the folder"
.Show
End With
On Error Resume Next
fldpath = Application.FileDialog(msoFileDialogFolderPicker).SelectedItems(1)
& "\"
If fldpath = False Then
MsgBox "Folder Not Selected"
Exit Sub
End If

Set fso = CreateObject("scripting.filesystemobject")
Set fld = fso.getfolder(fldpath)
Application.DisplayAlerts = False
Application.ScreenUpdating = False
For Each fil In fld.Files
If Right(fil.Name, 4) = ".xls" And fil.Name <> ThisWorkbook.Name
Then Call import_data(fil.Path)
Next
Application.DisplayAlerts = True
Application.ScreenUpdating = True

End Sub



Sub import_data(filename As String)
Dim wkb As Workbook
Dim lastrow As Long
lastrow = ThisWorkbook.Sheets("Sheet1").Range("a65356").End(xlUp).Row +
1
Set wkb = Workbooks.Open(filename)
wkb.Sheets("Summary Sheet").Range("e2:j2").Copy
Destination:=ThisWorkbook.Sheets("Sheet1").Range("a" & lastrow)
wkb.Sheets("Summary Sheet").Range("b13:f13").Copy
Destination:=ThisWorkbook.Sheets("Sheet1").Range("g" & lastrow)
wkb.Close

End Sub

Thanks


On Sun, Apr 27, 2014 at 9:44 AM, Jitendra Yadav wrote:

> Hi All,
>
> I have some data for date wise but I want all excel file in one sheet
> through macro.
>
>
>
> Example.
>
>
>
>
> Regards,
> Jitendra//9650449202
>
> --
> 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 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't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE  : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
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 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't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ please help for consolidate in excel

[Jitendra Yadav]

Hi All,

I have some data for date wise but I want all excel file in one sheet
through macro.


  
Example.


 

Regards,
Jitendra//9650449202

-- 
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 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't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


1.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet


2.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet


example.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

$$Excel-Macros$$ Need a code to update the non existing data

[Ganesh N]

Hi Team,

I need to update the data in second sheet. before that i want to check the
data is already updated or not if already updated i need a msg else the
data needs to be update (I want to check the date and prj code, becoz week
on week prj and date will change. so i dont want to make a duplicate ). I
wrote coding for update the data. I need a code to check the condition.
Kindly help me on that.

Please find the attachment for your reference.

Thanks & Regards,
Ganesh N

-- 
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 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't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


Data to be update.xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12

Re: $$Excel-Macros$$ Need new Workbook create using Macros

[kapil Gupta]

Hi 

   Thanks Sir, Thats great.


Regards,
Kapil Gupta

On Tuesday, April 22, 2014 11:32:48 AM UTC+5:30, Abhi wrote:
>
> Dear Kapil,
>
> Please see the attached.
>
> This will create workbooks, paste filtered data and save them as per the 
> name column (Col G).
>
> *Keep in mind the following:*
>
> a) The new excel files will be created in the same folder* where you have 
> saved this file*. So, when you download this, save it in a folder where 
> you can locate it.
>
> b) If destination files are already in that folder (means if you have run 
> the macro once), *the code will NOT overwrite them*. You will have to *remove 
> the files manually* before you re-run the macro, else there will be 
> errors.
>
> Hope this helps.  
>
> Abhishek
>
>
> On Mon, Apr 21, 2014 at 8:48 PM, kapil Gupta 
> > wrote:
>
>> Hi,
>>
>>Kindly solve this query.  
>> 1.  I have attached one sheet all data in sheet according by name
>> 2 need create new workbook using macros according by name wise..  Means 
>> Name is A then should be Create workbook A and other is B then create other 
>> workbook Name is B.  and data also Assign in name sheet.  I have attached 
>> the example 
>>
>> Regards,
>> Kapil
>>
>> -- 
>> 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 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't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security 
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>  
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and 
>> members are not responsible for any loss.
>> --- 
>> You received this message because you are subscribed to the Google Groups 
>> "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it, send an 
>> email to excel-macros...@googlegroups.com .
>> To post to this group, send email to excel-...@googlegroups.com
>> .
>> Visit this group at http://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>

-- 
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 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't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ shortcut keys to increase efficiency of daily work in Excel

[ravinder negi]

please ignore previous link use below link updated...sorry for any
inconvenience
http://www.excelvbasupport.com/forum/forumdisplay.php?fid=7



On Sat, Apr 26, 2014 at 8:44 AM, ravinder negi
wrote:

> just visit below link;--
> http://excelvbasupport.com/forum/newthread.php?fid=7&processed=1
>
> Thanks & Regards
> Ravinder Negi
>
>  --
> 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 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't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
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 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't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ shortcut keys to increase efficiency of daily work in Excel

[ravinder negi]

just visit below link;--
http://excelvbasupport.com/forum/newthread.php?fid=7&processed=1

Thanks & Regards
Ravinder Negi

-- 
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 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't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ hi ayush ji

[ashish saini]

please include me in your group pls

-- 
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 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't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ Re: Help Required - Gantt Chart

[AAR VEE]

Go here

https://myexcelschool.wordpress.com/category/excel/




On Wednesday, January 20, 2010 10:48:24 AM UTC+5:30, pmnitie wrote:
>
>
>
> Hi
>
> am working scheduling problem in excel. i would like to know...is there 
> any way i can get the chart for the datas in Gantt Chart format.
> It will be greatful if somebody helps me out with this problem. sample 
> excel file is attached for reference...
>
> Thanks, waiting for the reply...
>
> Regards
> Maniyan
>  

-- 
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 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't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ Login & password in excel

[amar takale]

Dear Vabs

This is fabulous work!
I think this must be flashing on the front page! :D

Thank you very much for all of your efforts on this. I sincerely appreciate it.

Best regards and wishing you a fine day.

Amar




On Sat, Apr 26, 2014 at 2:17 PM, Vaibhav Joshi  wrote:
> Hi
>
> This will work..
>
> Cheers!!
>
>
> On Sat, Apr 26, 2014 at 12:40 PM, amar takale  wrote:
>>
>> Dear Vabs
>>
>> Thanks for explanation of issue.
>>
>> Means that error show always in excel 2003 & 2007.we can not do
>> anything to remove error window of  "object doesn't support this
>> property or method".Bcos now all things done by you as per my
>> requirement but small issue of this error window.
>>
>> Regards
>> Amar
>>
>>
>> On Sat, Apr 26, 2014 at 11:54 AM, Vaibhav Joshi  wrote:
>> > PROPERTY ISSUE IS DUE TO EXCEL 2003 & 2007 ISSUE.
>> >
>> > REFER ATTACHMENT.
>> >
>> >
>> > On Sat, Apr 26, 2014 at 11:46 AM, Vaibhav Joshi  wrote:
>> >>
>> >> Hi
>> >>
>> >> PFA this is with masking your password.
>> >>
>> >> Thx
>> >>
>> >>
>> >> On Sat, Apr 26, 2014 at 11:17 AM, amar takale 
>> >> wrote:
>> >>>
>> >>> Dear Vabs
>> >>>
>> >>> Again some thing small issue accrued,pls see screen shot.
>> >>>
>> >>> Regards
>> >>> Amar
>> >>>
>> >>> On Sat, Apr 26, 2014 at 11:02 AM, Vabs  wrote:
>> >>> > Hi
>> >>> >
>> >>> > Pls check this..
>> >>> >
>> >>> > Thanks
>> >>> >
>> >>> >
>> >>> > On Sat, Apr 26, 2014 at 10:54 AM, amar takale 
>> >>> > wrote:
>> >>> >>
>> >>> >> Dear Vabs
>> >>> >>
>> >>> >> There are problem of password,it show wrong password.Pls can you
>> >>> >> see
>> >>> >> sheet.
>> >>> >>
>> >>> >> Regards
>> >>> >> Amar
>> >>> >>
>> >>> >> On Fri, Apr 25, 2014 at 9:23 PM, Vabs  wrote:
>> >>> >> > Thanks!!!
>> >>> >> >
>> >>> >> > PFA
>> >>> >> >
>> >>> >> > Cheers!!
>> >>> >> >
>> >>> >> >
>> >>> >> > On Fri, Apr 25, 2014 at 7:06 PM, amar takale
>> >>> >> > 
>> >>> >> > wrote:
>> >>> >> >>
>> >>> >> >> Dear Vaibhav
>> >>> >> >>
>> >>> >> >> Mind Freaking !!! Awesome!!!
>> >>> >> >>
>> >>> >> >> Perfect,You are done it………
>> >>> >> >>
>> >>> >> >> I am really thankful for its wonderful Coding.
>> >>> >> >>
>> >>> >> >> One thing small issue that if I login sheet & save it & close
>> >>> >> >> sheet.When again open that sheet then Login & Password (AMAR &
>> >>> >> >> AMAR)
>> >>> >> >> show everyone who open this sheet.I think it will show invisible
>> >>> >> >> (Login & Password) when second time open sheet.every second user
>> >>> >> >> must
>> >>> >> >> to login & put password then show Reports sheet.
>> >>> >> >>
>> >>> >> >> Regards
>> >>> >> >> Amar
>> >>> >> >>
>> >>> >> >>
>> >>> >> >>
>> >>> >> >> Regards
>> >>> >> >>
>> >>> >> >> Amar
>> >>> >> >>
>> >>> >> >>
>> >>> >> >>
>> >>> >> >>
>> >>> >> >> On Wed, Apr 23, 2014 at 8:57 PM, Vaibhav Joshi 
>> >>> >> >> wrote:
>> >>> >> >> > Hi
>> >>> >> >> >
>> >>> >> >> > PFA, i have done changes as per basic requirements
>> >>> >> >> >
>> >>> >> >> > Cheers!
>> >>> >> >> >
>> >>> >> >> >
>> >>> >> >> > On Wed, Apr 23, 2014 at 5:41 PM, amar takale
>> >>> >> >> > 
>> >>> >> >> > wrote:
>> >>> >> >> >>
>> >>> >> >> >> Dear abhishek
>> >>> >> >> >>
>> >>> >> >> >> Thanks for reply i want to wish proceed with this discussion
>> >>> >> >> >> but
>> >>> >> >> >> in
>> >>> >> >> >> our office chat window is blocked. So i cant chat with
>> >>> >> >> >> you.but I
>> >>> >> >> >> am
>> >>> >> >> >> very pleased with your
>> >>> >> >> >> Efforts for work.Thanks very much friend,I will try it again
>> >>> >> >> >> on
>> >>> >> >> >> Google.
>> >>> >> >> >>
>> >>> >> >> >> If I got any solution for that issue then i will send file
>> >>> >> >> >> for
>> >>> >> >> >> you
>> >>> >> >> >> on
>> >>> >> >> >> our Excel forum.
>> >>> >> >> >>
>> >>> >> >> >> All Excel team experts pls give me idea for above matter
>> >>> >> >> >> issue.
>> >>> >> >> >>
>> >>> >> >> >> Regards
>> >>> >> >> >> Amar
>> >>> >> >> >>
>> >>> >> >> >>
>> >>> >> >> >>
>> >>> >> >> >>
>> >>> >> >> >> On Wed, Apr 23, 2014 at 5:19 PM, Abhishek Jain
>> >>> >> >> >> 
>> >>> >> >> >> wrote:
>> >>> >> >> >> > You can change the login names and password in the VBA code
>> >>> >> >> >> > of
>> >>> >> >> >> > the
>> >>> >> >> >> > form
>> >>> >> >> >> > /
>> >>> >> >> >> > sheet. I am not sure how to do this with hyperlinks.
>> >>> >> >> >> >
>> >>> >> >> >> > You may contact me via chat if you wish to proceed with
>> >>> >> >> >> > this
>> >>> >> >> >> > or
>> >>> >> >> >> > need
>> >>> >> >> >> > to
>> >>> >> >> >> > discuss anything further.
>> >>> >> >> >> >
>> >>> >> >> >> > Regards, Abhishek
>> >>> >> >> >> >
>> >>> >> >> >> >
>> >>> >> >> >> > On Wed, Apr 23, 2014 at 5:13 PM, amar takale
>> >>> >> >> >> > 
>> >>> >> >> >> > wrote:
>> >>> >> >> >> >>
>> >>> >> >> >> >> Dear Abhishek
>> >>> >> >> >> >>
>> >>> >> >> >> >> Thanks good one solution of my issue but can we go through
>> >>> >> >> >> >> my
>> >>> >> >> >> >> discussion.And also How can we change Login & password of
>> >>> >> >> >> >> sheet
>> >>> >> >> >> >> which

Re: $$Excel-Macros$$ How to share Code/Macro ?

[ǝɹohsiʞ ʞ ʌ d]

Please go through the below link:

http://velin-georgiev-blog.appspot.com/blog/fully-automated-excel-reporting-by-using-windows-task-scheduler-vba-and-simple-vba-functions-library/



On Sat, Apr 26, 2014 at 3:06 PM, Ravinder wrote:

> Pls visit below link for solution
>
>
>
> *http://excelvbasupport.com/forum/showthread.php?tid=8
> *
>
>
>
>
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Suyog Kulkarni
> *Sent:* Saturday, April 26, 2014 2:40 PM
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ How to share Code/Macro ?
>
>
>
> Hello All,
>
> Kindly refer attached file, I've created macro but I want to share this
> macro to other users. Following are my difficulties.
>
> 1. How can I secure the code ? Kindly add password 12345 for this file.
> 2. To run the code I need to keep this file open but which I don't want
> normal user to do ? This macro should run automatically on any pc.
> 3. Can I add "Any additional button" which would be appear along with the
> exiting toolbar of excel ? so that normal use will only click that button
> without headache ?
>
> Kindly advice me.
>
> With Regards,
> Suyog
>
> --
> 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 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't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>
> --
> 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 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't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
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 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't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit 

RE: $$Excel-Macros$$ How to share Code/Macro ?

[Ravinder]

Pls visit below link for solution

 

http://excelvbasupport.com/forum/showthread.php?tid=8

 

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On 
Behalf Of Suyog Kulkarni
Sent: Saturday, April 26, 2014 2:40 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ How to share Code/Macro ?

 

Hello All,

Kindly refer attached file, I've created macro but I want to share this macro 
to other users. Following are my difficulties.

1. How can I secure the code ? Kindly add password 12345 for this file. 
2. To run the code I need to keep this file open but which I don't want normal 
user to do ? This macro should run automatically on any pc.
3. Can I add "Any additional button" which would be appear along with the 
exiting toolbar of excel ? so that normal use will only click that button 
without headache ?

Kindly advice me. 

With Regards,
Suyog

-- 
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 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't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
 
NOTE : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

-- 
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 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't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ How to share Code/Macro ?

[Suyog Kulkarni]

Hello All,

Kindly refer attached file, I've created macro but I want to share this 
macro to other users. Following are my difficulties.

1. How can I secure the code ? Kindly add password 12345 for this file. 
2. To run the code I need to keep this file open but which I don't want 
normal user to do ? This macro should run automatically on any pc.
3. Can I add "Any additional button" which would be appear along with the 
exiting toolbar of excel ? so that normal use will only click that button 
without headache ?

Kindly advice me. 

With Regards,
Suyog

-- 
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 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't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


Rw.xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12

$$Excel-Macros$$ Please Visit below link for All Shortcuts including Excel

[Ravinder]

 

Please visit this link for All Shortcuts Keys including Excel
 

 

 

-- 
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 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't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ Login & password in excel

[amar takale]

Dear Vabs

Thanks for explanation of issue.

Means that error show always in excel 2003 & 2007.we can not do
anything to remove error window of  "object doesn't support this
property or method".Bcos now all things done by you as per my
requirement but small issue of this error window.

Regards
Amar


On Sat, Apr 26, 2014 at 11:54 AM, Vaibhav Joshi  wrote:
> PROPERTY ISSUE IS DUE TO EXCEL 2003 & 2007 ISSUE.
>
> REFER ATTACHMENT.
>
>
> On Sat, Apr 26, 2014 at 11:46 AM, Vaibhav Joshi  wrote:
>>
>> Hi
>>
>> PFA this is with masking your password.
>>
>> Thx
>>
>>
>> On Sat, Apr 26, 2014 at 11:17 AM, amar takale 
>> wrote:
>>>
>>> Dear Vabs
>>>
>>> Again some thing small issue accrued,pls see screen shot.
>>>
>>> Regards
>>> Amar
>>>
>>> On Sat, Apr 26, 2014 at 11:02 AM, Vabs  wrote:
>>> > Hi
>>> >
>>> > Pls check this..
>>> >
>>> > Thanks
>>> >
>>> >
>>> > On Sat, Apr 26, 2014 at 10:54 AM, amar takale 
>>> > wrote:
>>> >>
>>> >> Dear Vabs
>>> >>
>>> >> There are problem of password,it show wrong password.Pls can you see
>>> >> sheet.
>>> >>
>>> >> Regards
>>> >> Amar
>>> >>
>>> >> On Fri, Apr 25, 2014 at 9:23 PM, Vabs  wrote:
>>> >> > Thanks!!!
>>> >> >
>>> >> > PFA
>>> >> >
>>> >> > Cheers!!
>>> >> >
>>> >> >
>>> >> > On Fri, Apr 25, 2014 at 7:06 PM, amar takale 
>>> >> > wrote:
>>> >> >>
>>> >> >> Dear Vaibhav
>>> >> >>
>>> >> >> Mind Freaking !!! Awesome!!!
>>> >> >>
>>> >> >> Perfect,You are done it………
>>> >> >>
>>> >> >> I am really thankful for its wonderful Coding.
>>> >> >>
>>> >> >> One thing small issue that if I login sheet & save it & close
>>> >> >> sheet.When again open that sheet then Login & Password (AMAR &
>>> >> >> AMAR)
>>> >> >> show everyone who open this sheet.I think it will show invisible
>>> >> >> (Login & Password) when second time open sheet.every second user
>>> >> >> must
>>> >> >> to login & put password then show Reports sheet.
>>> >> >>
>>> >> >> Regards
>>> >> >> Amar
>>> >> >>
>>> >> >>
>>> >> >>
>>> >> >> Regards
>>> >> >>
>>> >> >> Amar
>>> >> >>
>>> >> >>
>>> >> >>
>>> >> >>
>>> >> >> On Wed, Apr 23, 2014 at 8:57 PM, Vaibhav Joshi  wrote:
>>> >> >> > Hi
>>> >> >> >
>>> >> >> > PFA, i have done changes as per basic requirements
>>> >> >> >
>>> >> >> > Cheers!
>>> >> >> >
>>> >> >> >
>>> >> >> > On Wed, Apr 23, 2014 at 5:41 PM, amar takale
>>> >> >> > 
>>> >> >> > wrote:
>>> >> >> >>
>>> >> >> >> Dear abhishek
>>> >> >> >>
>>> >> >> >> Thanks for reply i want to wish proceed with this discussion but
>>> >> >> >> in
>>> >> >> >> our office chat window is blocked. So i cant chat with you.but I
>>> >> >> >> am
>>> >> >> >> very pleased with your
>>> >> >> >> Efforts for work.Thanks very much friend,I will try it again on
>>> >> >> >> Google.
>>> >> >> >>
>>> >> >> >> If I got any solution for that issue then i will send file for
>>> >> >> >> you
>>> >> >> >> on
>>> >> >> >> our Excel forum.
>>> >> >> >>
>>> >> >> >> All Excel team experts pls give me idea for above matter issue.
>>> >> >> >>
>>> >> >> >> Regards
>>> >> >> >> Amar
>>> >> >> >>
>>> >> >> >>
>>> >> >> >>
>>> >> >> >>
>>> >> >> >> On Wed, Apr 23, 2014 at 5:19 PM, Abhishek Jain
>>> >> >> >> 
>>> >> >> >> wrote:
>>> >> >> >> > You can change the login names and password in the VBA code of
>>> >> >> >> > the
>>> >> >> >> > form
>>> >> >> >> > /
>>> >> >> >> > sheet. I am not sure how to do this with hyperlinks.
>>> >> >> >> >
>>> >> >> >> > You may contact me via chat if you wish to proceed with this
>>> >> >> >> > or
>>> >> >> >> > need
>>> >> >> >> > to
>>> >> >> >> > discuss anything further.
>>> >> >> >> >
>>> >> >> >> > Regards, Abhishek
>>> >> >> >> >
>>> >> >> >> >
>>> >> >> >> > On Wed, Apr 23, 2014 at 5:13 PM, amar takale
>>> >> >> >> > 
>>> >> >> >> > wrote:
>>> >> >> >> >>
>>> >> >> >> >> Dear Abhishek
>>> >> >> >> >>
>>> >> >> >> >> Thanks good one solution of my issue but can we go through my
>>> >> >> >> >> discussion.And also How can we change Login & password of
>>> >> >> >> >> sheet
>>> >> >> >> >> which
>>> >> >> >> >> one you sent.
>>> >> >> >> >>
>>> >> >> >> >> Pls give me solution as per my requirement (VBA OR Hyperlink)
>>> >> >> >> >> then
>>> >> >> >> >> that great work for me.
>>> >> >> >> >>
>>> >> >> >> >> Thanks again for help
>>> >> >> >> >>
>>> >> >> >> >> Regards
>>> >> >> >> >> Amar
>>> >> >> >> >>
>>> >> >> >> >> On Thu, Apr 17, 2014 at 1:07 PM, Prafull Jadhav
>>> >> >> >> >>  wrote:
>>> >> >> >> >> > Dear Abhishek Sir,
>>> >> >> >> >> >
>>> >> >> >> >> > Great.
>>> >> >> >> >> >
>>> >> >> >> >> >
>>> >> >> >> >> > Regards,
>>> >> >> >> >> > Prafull Jadhav
>>> >> >> >> >> > 9920553518
>>> >> >> >> >> >
>>> >> >> >> >> >
>>> >> >> >> >> > On 17 April 2014 12:09, Abhishek Jain
>>> >> >> >> >> > 
>>> >> >> >> >> > wrote:
>>> >> >> >> >> >>
>>> >> >> >> >> >> Dear Amar,
>>> >> >> >> >> >>
>>> >> >> >> >> >> Please see the attached file. I hope this works for you.
>>> >> >> >> >> >>
>>> >> >> >> >> >> You may login by using any of the following credentials
>>> >> >> >> >> >> (both
>>> >