$$Excel-Macros$$ Use xlsm as backend for html page

[Kat]

Hi guys,

I have a xlsm file in which it has file name, drawing folder name, revision 
and date updated. I was wondering whether could I use xlsm file as backend 
while using html page as front end. I would like to create a html page in 
which it has search, download and upload function where the data will be 
grabbed from the xlsm file. May I know how could I achieve this?

Thanks in advance.

-- 
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 https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ control the macro commands in excel vba

[Kat]

Hi guys,

I have 7 subs in my module. I would like to control that if the 
datelastmodified of excel vba is same as datelastmodified of the master 
file, then don't run the 7 subs. If the datelastmodified of both are not 
same, then run all the subs. What should I put in 'ThisWorkbook' and how do 
I organize my sub? Can anyone help?

Thanks in advance.


Cheers

-- 
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 https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ PasteSpecial method of Range class failed error

[Kat]

Hi all,

I'm getting error for my code. Can anyone help me analyze where is the 
error?

Thanks in advance.


Sub getnew()
Dim Sheet1 As Worksheet
Dim Sheet3 As Worksheet
Dim lastrow As Long
Dim i As Long
Dim erow As Long
Application.ScreenUpdating = False
Application.DisplayStatusBar = False
ActiveSheet.DisplayPageBreaks = False
Set Sheet1 = ThisWorkbook.Sheets("Sheet1")
Set Sheet3 = ThisWorkbook.Sheets("Sheet2")
lastrow = Sheet1.Range("C" & Rows.Count).End(xlUp).Row
Sheet3.Select
Rows("1:1").Select
Selection.AutoFilter
ActiveSheet.Range("A:V").AutoFilter Field:=2, Criteria1:="NEW"
Columns("A:V").Select
Selection.Copy
ThisWorkbook.Activate
Sheets("Sheet1").Select
Range("C2" & lastrow).Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
   :=False, Transpose:=False
Application.CutCopyMode = False
Sheet1.Select
Range("A1:X750001").Select
Selection.Sort Key1:=Range("C2"), Order1:=xlAscending, Key2:=Range("G2") 
_
, Order2:=xlAscending, Header:=xlGuess, OrderCustom:=1, MatchCase:= 
_
False, Orientation:=xlTopToBottom
Application.ScreenUpdating = True
Application.DisplayStatusBar = True
ActiveSheet.DisplayPageBreaks = True
End Sub


-- 
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 https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ Re: overflow error issue

[Kat]

Hi Mandeep, 

I don't know how to use VLookUp function for my situation. I was wondering 
whether would you mind showing me how to use VLookUp function according to 
my code?


Cheers

On Monday, 22 February 2016 20:57:58 UTC+8, Mandeep baluja wrote:
>
> Will you please let me know why you're not using a simple vlookup 
>>> function,index match for the same it would be more faster than this to 
>>> search using find method one by one, while defining the value to integer it 
>>> doesn't matter how many rows of data you have 1 to 5 lac it will work for 
>>> -32,768 
>>> through 32,767 (signed) That's i used long  to run the macro for all rows. 
>>>  Another thing you can use a dictionary object or use array to intesify the 
>>> speed of macro. Don't miss Application.screenupdating = false in every code 
>>> to avoid flickering.
>>>
>>
> Regards, 
> Mandeep baluja 
>  
>  
>

-- 
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 https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ copy paste issue from one sheet to another

[Kat]

Hi Sky,

Thank you very much for your help. 


Cheers

On Monday, 22 February 2016 02:46:46 UTC+8, sk.yadav7186 wrote:
>
> check it...maybe this is helpful...because i m also learner :-)
>
> On Fri, Feb 19, 2016 at 11:43 AM, Kat <kather...@gmail.com > 
> wrote:
>
>> Hi guys,
>>
>> I would like to copy paste entire row from king sheet to queen sheet if 
>> the cells in range "B2:B" has the value of "update" in king sheet. However, 
>> I have copy area and paste area not same size error. May I know how can I 
>> solve this? Can anyone help? Thanks in advance.
>>
>>
>> Cheers
>>
>> -- 
>> 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 https://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>
>
> -- 
> *Sky*
> "Good, Better, Best! 
> Never let it rest, Til your good is better and your better is best." - *St. 
> Jerome*
>

-- 
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 https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ Re: overflow error issue

[Kat]

Hi Mandeep, 

I have defined the variable to long for the whole program and it takes very 
long time for running. Also, for the code below, if I use integer, I will 
get overflow error. If I change variable to long, I will get 
application-defined or object-defined error. Can you help me on this issue?


Sub Compare()
Dim mrow As Range, trow As Long
With Worksheets("main")
Set mrow = .Range("A2", .Range("A" & Rows.Count).End(xlUp))
End With
trow = Worksheets("today").Range("A" & Rows.Count).End(xlUp).Row

With Worksheets("today")
For j = 2 To trow
If mrow.Find(What:=.Range("A" & j).Value, LookIn:=xlValues, 
LookAt:=xlWhole) Is Nothing _
 Then .Range("B" & j).Value = "NEW"
Next j
End With
End Sub


Cheers

On Monday, 22 February 2016 14:37:51 UTC+8, Mandeep baluja wrote:
>
> Define your variable as long !!
>>
>
> Sub dnew()
> Dim i As long
> Dim lrow As long
> lrow = Sheets("to").Range("C" & Rows.Count).End(xlUp).Row
> For i = 2 To lrow
> If Sheets("to").Cells(i, 2).Value = "up" Then
> Sheets("to").Cells(i, 2).Value = ""
> Sheets("to").Cells(i, 1).Value = ""
> End If
> Next i
> End Sub 
> Regards, 
> Mandeep baluja 
> https://www.linkedin.com/messaging/thread/6086488646137958400 
>
>

-- 
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 https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ overflow error issue

[Kat]

Hi guys,

I've issue running the code below. Is there anyone can help? Thanks in 
advance.

Sub dnew()
Dim i As Integer
Dim lrow As Integer
lrow = Sheets("to").Range("C" & Rows.Count).End(xlUp).Row
For i = 2 To lrow
If Sheets("to").Cells(i, 2).Value = "up" Then
Sheets("to").Cells(i, 2).Value = ""
Sheets("to").Cells(i, 1).Value = ""
End If
Next i
End Sub


Cheers

-- 
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 https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ copy paste issue from one sheet to another

[Kat]

Hi guys,

I would like to copy paste entire row from king sheet to queen sheet if the 
cells in range "B2:B" has the value of "update" in king sheet. However, I 
have copy area and paste area not same size error. May I know how can I 
solve this? Can anyone help? Thanks in advance.


Cheers

-- 
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 https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


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

Re: $$Excel-Macros$$ to change cell value in Column A daily

[Kat]

Hi Paul,

Thank you for your reply. Thanks a lot for your suggestion. I've changed to 
use another way for the time being.  

Hope you have a very nice day!

Cheers

On Thursday, 18 February 2016 20:59:51 UTC+8, Paul Schreiner wrote:
>
> "Without opening the file manually"..
> I think there's a way to do that, but from what I understand the technique 
> still requires the excel file with the macro to be open.
>
> Instead, you can write macro that tests for the current date/time and 
> changes the cell when the file is opened.
> (it would then save/close the file)
>
> Then, set up a Scheduled Task on a Windows computer that will run daily 
> and simply open the file at 9:01am.
>
> If you'd like to try this approach, let me know and I can help.
>
> *Paul*
> -
>
>
>
>
>
>
>
> *“Do all the good you can,By all the means you can,In all the ways you 
> can,In all the places you can,At all the times you can,To all the people 
> you can,As long as ever you can.” - John Wesley*
> -----
>
>
> On Wednesday, February 17, 2016 10:39 PM, Kat <kather...@gmail.com 
> > wrote:
>
>
>
> Hi all, 
>
> I have an xlsm sheet and would like to change the cell content in Column A 
> at 9am everyday. If cell value in column A equals to "Yes" today, then it 
> needs to be changed to "No" automatically at 9am tomorrow without opening 
> the file manually. May I know how can I get this done? Please see attached 
> for my code.
>
> Thanks in advance.
> -- 
> 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 https://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 https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ to change cell value in Column A daily

[Kat]

Hi all, 

I have an xlsm sheet and would like to change the cell content in Column A 
at 9am everyday. If cell value in column A equals to "Yes" today, then it 
needs to be changed to "No" automatically at 9am tomorrow without opening 
the file manually. May I know how can I get this done? Please see attached 
for my code.

Thanks in advance.

-- 
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 https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


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

Re: $$Excel-Macros$$ copy new column from sheet 1 and paste to sheet 2

[Kat]

Thank you very much for your help. It's much appreciated.

On Friday, 5 February 2016 23:16:28 UTC+8, era_kar wrote:
>
> Hi,
> I give u the following code you can run and get what u expect. For the 
> next time u have to change the j value(i.e.,column
> value,A=1 B=2 etc) to 6 to 7, and next time this should be 8 to 9.Or if u 
> don't mind in over printing the data,u can put 
> j value = 4 to 33.It is upto u.Here the row is fixed to 15 i.e., i value
>
> Sub FillSheet1To2()
> Dim i, j As Integer
>  For i = 1 To 15
> For j = 4 To 5
>
>  Sheets("sheet2").Cells(i, j).Value = Sheets("sheet1").Cells(i, 
> j).Value
>  
>  Next j
>   Next i
>
> End Sub
>
> -r.Karunanithi.
>
>
> --
> *From:* Kat <kather...@gmail.com >
> *To:* MS EXCEL AND VBA MACROS <excel-...@googlegroups.com > 
> *Sent:* Thursday, February 4, 2016 1:07 PM
> *Subject:* $$Excel-Macros$$ copy new column from sheet 1 and paste to 
> sheet 2
>
> Hi all,
>
> I have a workbook in which the row is fixed (eg. from column A to C) and 
> the user will keep adding new column (eg. from adding data in Column D to E 
> first time, second time adding data in column F to H) in Sheet 1. Everytime 
> when new column is added in Sheet1, I want it to be automatically being 
> copied and pasted into Sheet2 as well starting from Column F. For instance, 
> When user add data in Column D to E first time, then the data being added 
> in Column D to E in Sheet1 will be automatically being copied and pasted in 
> Column F to G in Sheet2. Can anyone help?
>
> Thanks in advanced.
> -- 
> 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 https://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 https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ To insert new row below when the data is unmatched

[Kat]

Hi all, 

I'm trying to insert a new row below the matched data in trial.xlsm and 
copy the unmatched data and write 'New' in column B when the data is found 
unmatched. However, I can't achieve this. I've attached the pp.xlsx file in 
which the Sheet2 in pp.xlsx is the result that I want to achieve. The file 
trial.xlsm is the code that I've written.

Can anyone please help? Thanks in advanced.



-- 
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 https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


pp.xlsx
Description: MS-Excel 2007 spreadsheet


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

Re: $$Excel-Macros$$ compare columns through for loop

[Kat]

It works perfect. Thanks a lot for your help.

On Wednesday, 3 February 2016 15:58:48 UTC+8, era_kar wrote:
>
> Hi,
> I enclose which may solve ur request.
>
>
>
> ------
> *From:* Kat <kather...@gmail.com >
> *To:* MS EXCEL AND VBA MACROS <excel-...@googlegroups.com > 
> *Sent:* Wednesday, February 3, 2016 6:28 AM
> *Subject:* $$Excel-Macros$$ compare columns through for loop
>
> Hi all,
>
> I would like to compare columns in two workbooks. If data from column D in 
> fortest1.xlsx and column F in tested.xlsm are matched, then do nothing. If 
> they are not matched, then data from column A to C in fortest1.xlsx needs 
> to be copied and pasted to column C to E in tested.xlsm. Please see 
> attached for the file. 
> -- 
> 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 https://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 https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ copy new column from sheet 1 and paste to sheet 2

[Kat]

Hi all,

I have a workbook in which the row is fixed (eg. from column A to C) and 
the user will keep adding new column (eg. from adding data in Column D to E 
first time, second time adding data in column F to H) in Sheet 1. Everytime 
when new column is added in Sheet1, I want it to be automatically being 
copied and pasted into Sheet2 as well starting from Column F. For instance, 
When user add data in Column D to E first time, then the data being added 
in Column D to E in Sheet1 will be automatically being copied and pasted in 
Column F to G in Sheet2. Can anyone help?

Thanks in advanced.

-- 
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 https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ compare columns through for loop

[Kat]

Hi all,

I would like to compare columns in two workbooks. If data from column D in 
fortest1.xlsx and column F in tested.xlsm are matched, then do nothing. If 
they are not matched, then data from column A to C in fortest1.xlsx needs 
to be copied and pasted to column C to E in tested.xlsm. Please see 
attached for the file. 

-- 
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 https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


fortest1.xlsx
Description: MS-Excel 2007 spreadsheet


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

Re: $$Excel-Macros$$ database copy paste issue from one workbook to another workbook

[Kat]

<https://lh3.googleusercontent.com/-tTlhKx9MRm0/VqlsAqy9QbI/AGk/YQVUTI4OGhA/s1600/wanted%2Bresult.jpg>
Hi Paul,

Thank you for your response. The first time it copied all is fine. However, 
the second time it still copies all. I need it to copy only the updated 
data at next blank row instead. Please see attached the screenshot for the 
result that I want it to be. For first time, it copies until row 7. For 
second time, there are updated data, so it copies all the updated data at 
next blank row. Thanks for your help.

On Wednesday, 27 January 2016 20:24:06 UTC+8, Paul Schreiner wrote:
>
> OK, I think I need a better example of what you HAVE and what you want the 
> RESULT to be.
>
> In the sample files you provided, one was a blank sheet and the other had 
> sample data.
> your original macro looks like it compared the two workbooks/worksheets
> and for each row was intended to compare column A of the "fortest" 
> workbook to column C of the "tested" workbook (and compare B to D and C to 
> E)
> If they differed, add the record from "fortest" to the END of the data in 
> "Tested".
>
> since in the example file, "tested" is blank, 
> it meant that ALL non-blank rows in "fortest" were different than 
> "tested", 
> so the macro would copy them all.
> the result would be that "tested" would look identical to "fortest".
>
>
> since that is what my macro DID, from your response that isn't what you 
> intended.
>
> So, please provide an example of what the files like "before" and what you 
> want the files to look like after the macro runs.
>
> *Paul*
> -
>
>
>
>
>
>
>
> *“Do all the good you can,By all the means you can,In all the ways you 
> can,In all the places you can,At all the times you can,To all the people 
> you can,As long as ever you can.” - John Wesley*
> -
>
>
> On Tuesday, January 26, 2016 8:20 PM, Kat <kather...@gmail.com 
> > wrote:
>
>
>
> Hi Paul,
>
> The code works. However, it doesn't achieve the desired result. The code 
> doesn''t show all the updated data in the next blank row. It doesn't seem 
> to compare the database in both workboooks.  
>
>
> Cheers 
>
> On Tuesday, 26 January 2016 21:20:47 UTC+8, Paul Schreiner wrote:
>
> I updated the macro to this.
> give it a try:
>
> Option Explicit
> Sub test()
> Dim varSheetA As Variant
> Dim varSheetB As Variant
> Dim strRangeToCheck As String
> Dim strRangeToC As String
> Dim iRow As Long
> Dim iCol As Long
> Dim wbkA As Workbook
> Dim eRow As Long
>
> Set wbkA = Workbooks.Open(Filename:="C:\ temp\vba\fortest.xlsx")
> strRangeToCheck = "A:C"
> strRangeToC = "C:E"
> 'Debug.Print Now
> varSheetA = wbkA.Worksheets("Sheet1"). Range(strRangeToCheck)
> varSheetB = ThisWorkbook.Worksheets(" Sheet1").Range(strRangeToC)
> 'Debug.Print Now
> 'Warning:  VarSheetA and VarSheetB result in arrays of the ENTIRE 
> respective workbook
> '   using LBound() to UBound() causes the ENTIRE workbook to be 
> processed,
> '   regardless of how much is actually used.
> '  I'd suggest using something like:
> '  thisworkbook.select
> '  MaxRow = ActiveCell.SpecialCells( xlLastCell).Row
> '  MaxCol = ActiveCell.SpecialCells( xlLastCell).Column
> '  For iRow = 1 to MaxRow
> '  For iCol = 1 to MaxCol
> '- -
> For iRow = LBound(varSheetA, 1) To UBound(varSheetA, 1)
> For iCol = LBound(varSheetA, 2) To UBound(varSheetA, 2)
> If varSheetA(iRow, iCol) = varSheetB(iRow, iCol) Then
> ' Cells are identical.
> ' Do nothing.
> Else
> eRow = ThisWorkbook.Worksheets(" Sheet1").Cells(Rows.Count, 
> 3).End(xlUp).Row + 1
> ThisWorkbook.Sheets("Sheet1"). Range("C" & eRow & ":E" & 
> eRow).Value = wbkA.Sheets("Sheet1").Range(" A" & iRow & ":C" & iRow).Value
> Exit For
> End If
> Next
> Next
> wbkA.Close savechanges:=False
> End Sub
> *Paul*
> -- ---
>
>
>
>
>
>
>
> *“Do all the good you can,By all the means you can,In all the ways you 
> can,In all the places you can,At all the times you can,To all the people 
> you can,As long as ever you can.” - John 
> Wesley*-- 
> ---
>
>
> On Monday, January 25, 2016 8:14 PM, Kat <kather...@gmail.com> wrote:
>
>
>

Re: $$Excel-Macros$$ database copy paste issue from one workbook to another workbook

[Kat]

Hi Paul,

The code works. However, it doesn't achieve the desired result. The code 
doesn''t show all the updated data in the next blank row. It doesn't seem 
to compare the database in both workboooks.  


Cheers 

On Tuesday, 26 January 2016 21:20:47 UTC+8, Paul Schreiner wrote:
>
> I updated the macro to this.
> give it a try:
>
> Option Explicit
> Sub test()
> Dim varSheetA As Variant
> Dim varSheetB As Variant
> Dim strRangeToCheck As String
> Dim strRangeToC As String
> Dim iRow As Long
> Dim iCol As Long
> Dim wbkA As Workbook
> Dim eRow As Long
>
> Set wbkA = Workbooks.Open(Filename:="C:\temp\vba\fortest.xlsx")
> strRangeToCheck = "A:C"
> strRangeToC = "C:E"
> 'Debug.Print Now
> varSheetA = wbkA.Worksheets("Sheet1").Range(strRangeToCheck)
> varSheetB = ThisWorkbook.Worksheets("Sheet1").Range(strRangeToC)
> 'Debug.Print Now
> 'Warning:  VarSheetA and VarSheetB result in arrays of the ENTIRE 
> respective workbook
> '   using LBound() to UBound() causes the ENTIRE workbook to be 
> processed,
> '   regardless of how much is actually used.
> '  I'd suggest using something like:
> '  thisworkbook.select
> '  MaxRow = ActiveCell.SpecialCells(xlLastCell).Row
> '  MaxCol = ActiveCell.SpecialCells(xlLastCell).Column
> '  For iRow = 1 to MaxRow
> '  For iCol = 1 to MaxCol
> '--
> For iRow = LBound(varSheetA, 1) To UBound(varSheetA, 1)
> For iCol = LBound(varSheetA, 2) To UBound(varSheetA, 2)
> If varSheetA(iRow, iCol) = varSheetB(iRow, iCol) Then
> ' Cells are identical.
> ' Do nothing.
> Else
> eRow = ThisWorkbook.Worksheets("Sheet1").Cells(Rows.Count, 
> 3).End(xlUp).Row + 1
> ThisWorkbook.Sheets("Sheet1").Range("C" & eRow & ":E" & 
> eRow).Value = wbkA.Sheets("Sheet1").Range("A" & iRow & ":C" & iRow).Value
> Exit For
> End If
> Next
> Next
> wbkA.Close savechanges:=False
> End Sub
> *Paul*
> -
>
>
>
>
>
>
>
> *“Do all the good you can,By all the means you can,In all the ways you 
> can,In all the places you can,At all the times you can,To all the people 
> you can,As long as ever you can.” - John Wesley*
> -
>
>
> On Monday, January 25, 2016 8:14 PM, Kat <kather...@gmail.com 
> > wrote:
>
>
>
> Hi Paul,
>
> Please see attached the fortest.xlsx file for your attention.
>
>
> Cheers
>
> On Tuesday, 26 January 2016 04:18:22 UTC+8, Paul Schreiner wrote:
>
> you've only sent the "Tested.xlsm" file
> Can you please include the fortest.xlsx file?
> Otherwise, I would need to GUESS what  file looks like.
> It LOOKS like you're comparing columns A-C in one workbook to range C-E in 
> another.
>
> However:
> you have:
>
> Set varSheetA = wbkA.Worksheets("Sheet1")
> Set varSheetB = ThisWorkbook.Worksheets(" Sheet1")
>
> followed by:
> varSheetA = Worksheets("Sheet1").Range( strRangeToCheck)
> varSheetB = Worksheets("Sheet1").Range( strRangeToC)
>
> which will cause varSheetA and varSheetB to be defined for the currently 
> active workbook.
>
> If you can send me a sample data file, I'd be glad to put something 
> together for you.
>
>  
> *Paul*
> -- ---
>
>
>
>
>
>
>
> *“Do all the good you can,By all the means you can,In all the ways you 
> can,In all the places you can,At all the times you can,To all the people 
> you can,As long as ever you can.” - John 
> Wesley*-- 
> ---
>
>
> On Sunday, January 24, 2016 8:32 PM, Kat <kather...@gmail.com> wrote:
>
>
>
> Hi guys,
>
> I want to copy paste database from one Workbook A to Workbook B. When new 
> row data is added in Workbook A, the excel vba code will compare whether 
> the data is exist in Workbook B. If no, new row data needs to be copied and 
> pasted automatically to last existing row in Workbook B. I've had issue 
> with my code. Can anyone help me have a look? 
>
> Thanks in advance.
>
>
> -- 
> 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

Re: $$Excel-Macros$$ database copy paste issue from one workbook to another workbook

[Kat]

Hi Paul,

If I run the command based on your comment that I use 

  ThisWorkbook.Activate
>   MaxRow = ActiveCell.SpecialCells(xlLastCell).Row
>   MaxCol = ActiveCell.SpecialCells(xlLastCell).Column
>   For iRow = 1 To MaxRow
>   For iCol = 1 To MaxCol
>
 
Then the command below comes up with subscription out of range error.

>  If varSheetA(iRow, iCol) = varSheetB(iRow, iCol) Then 
>

-- 
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 https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ database copy paste issue from one workbook to another workbook

[Kat]

Hi Paul,

Please see attached the fortest.xlsx file for your attention.


Cheers

On Tuesday, 26 January 2016 04:18:22 UTC+8, Paul Schreiner wrote:
>
> you've only sent the "Tested.xlsm" file
> Can you please include the fortest.xlsx file?
> Otherwise, I would need to GUESS what  file looks like.
> It LOOKS like you're comparing columns A-C in one workbook to range C-E in 
> another.
>
> However:
> you have:
>
> Set varSheetA = wbkA.Worksheets("Sheet1")
> Set varSheetB = ThisWorkbook.Worksheets("Sheet1")
>
> followed by:
> varSheetA = Worksheets("Sheet1").Range(strRangeToCheck)
> varSheetB = Worksheets("Sheet1").Range(strRangeToC)
>
> which will cause varSheetA and varSheetB to be defined for the currently 
> active workbook.
>
> If you can send me a sample data file, I'd be glad to put something 
> together for you.
>
>  
> *Paul*
> -
>
>
>
>
>
>
>
> *“Do all the good you can,By all the means you can,In all the ways you 
> can,In all the places you can,At all the times you can,To all the people 
> you can,As long as ever you can.” - John Wesley*
> -
>
>
> On Sunday, January 24, 2016 8:32 PM, Kat <kather...@gmail.com 
> > wrote:
>
>
>
> Hi guys,
>
> I want to copy paste database from one Workbook A to Workbook B. When new 
> row data is added in Workbook A, the excel vba code will compare whether 
> the data is exist in Workbook B. If no, new row data needs to be copied and 
> pasted automatically to last existing row in Workbook B. I've had issue 
> with my code. Can anyone help me have a look? 
>
> Thanks in advance.
>
>
> -- 
> 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 https://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 https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


fortest.xlsx
Description: MS-Excel 2007 spreadsheet

$$Excel-Macros$$ database copy paste issue from one workbook to another workbook

[Kat]

Hi guys,

I want to copy paste database from one Workbook A to Workbook B. When new 
row data is added in Workbook A, the excel vba code will compare whether 
the data is exist in Workbook B. If no, new row data needs to be copied and 
pasted automatically to last existing row in Workbook B. I've had issue 
with my code. Can anyone help me have a look? 

Thanks in advance.


-- 
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 https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


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

$$Excel-Macros$$ Re: add date instantly when there is update in worksheet

[Kat]

Hi Mandeep, 

I've already got the database in the worksheet1. User can add data in row 
or column after the available data on current worksheet. When user add data 
in either row or column, I want it to automatically write the word 'new' in 
A column and compare worksheet1 with worksheet2 and add the new added row 
or column in worksheet1 to worksheet2 and show the date at the left side 
(eg. Column A) in worksheet2 as well. 

On Wednesday, 20 January 2016 13:14:26 UTC+8, Mandeep Baluja wrote:
>
> Use the worksheet event to trigger, It depends on you where you want to 
>> place date. 
>>
>
> Private Sub Worksheet_Change(ByVal Target As Range)
> 'Application.EnableEvents = False
> Range("E1").Value = Date
> 'Application.EnableEvents = True
> End Sub
>  
>
> Regards,
> Mandeep baluja 
>

-- 
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 https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ add date instantly when there is update in worksheet

[Kat]

Hi all,

I was wondering how to have the date being added automatically when there 
is new update in the worksheet either by column or by row.


Cheers

-- 
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 https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ Assist needed

[Kat]

Hi all,

I would like to copy master list from server to a worksheet name 'today'. 
When server update new row it needs to be appeared in the 'today' worksheet 
at the last row and shows 'new' in first column. User will update from the 
'today' worksheet and 'new' needs to be shown in first column as well. The 
'new' needs to be amended in daily basis. At the meantime, I would like to 
create another worksheet which named as 'yesterday'. In 'yesterday' 
worksheet, all the data in 'today' worksheet will be automatically 
transferred to 'yesterday' worksheet around 6pm which is being updated in 
daily basis as well. Please see attached for the sample outcome. Any help 
on this would be much appreciated.

Thanks in advance.


Cheers

-- 
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 https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


Book1.xlsx
Description: MS-Excel 2007 spreadsheet

$$Excel-Macros$$ new added file in folder to the current workbook

[Kat]

Hi all,

I've make a code which listed the folder name and file name with the 
details. I was wondering how can I make the file name and its details 
appear in the current workbook automatically when there are new files and 
folders added in the folder. 

Thanks in advanced.

-- 
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 https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ update modified details in excel automatically

[Kat]

Hi all, 

I've created a vba code for extracting files from folder with its details. 
I would like to know how could I make the excel update the content 
automatically by itself if there is any changes in the folder such as a 
file is deleted, new file is updated, file is being modified etc. 

Thanks in advance.


Cheers

-- 
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 https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ open file from folder

[Kat]

Hi all, 

I was wondering whether could you guys help me figure out how do I open 
file from folder using vb code. My code doesn't seem working. Please see 
attached for the vb code and file location.

Thanks in advance.


Cheers

-- 
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 https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


open file button.xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12

$$Excel-Macros$$ vba code help with revision times

[Kat]

Hi all, 

I need help with my revision time issue. The rule for the revision time 
code is after 8 character, if it's a number then it will show the number. 
Else, it will show error. However, one of the revision time format is 
REVI9_gif. It shows at EVI_gif in the cell instead of error. Can anyone 
help?

Thanks in advance. 

-- 
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 https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


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

$$Excel-Macros$$ how to handle large data with vba code

[Kat]

Hi all, 

I was wondering what can I write for the code with large data in vba 
because the program always crash when I try to execute. The data I'm trying 
to deal with is more than 5GB. 

Thanks in advanced.

-- 
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 https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ vba code for getting the date

[Kat]

Hi all, 

I'm trying to create vba code with corresponding date modified according to 
the file. Can anyone help me with the code? I would like to get just the 
date showed, not the time. When there is new file updated, i hope it can be 
updated automatically in the workbook. may I know how can I achieve this?

Thanks in advanced.


Cheers

-- 
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 https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


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

Re: $$Excel-Macros$$ vba code for listing folder name and file name

[Kat]

Hi Mandeep, 

The revision time in my snapshot is the one I use writing. The real code 
isn't showing. It's not showing the folder name and file name as well. In 
terms of revision times,  it's fine if the changes are done in certain 
interval. 



On Monday, 11 January 2016 15:34:15 UTC+8, Mandeep Baluja wrote:
>
> Revision time ?? I have not heard about this while searching it on the 
> internet I found this 
> http://excel.tips.net/T002868_Using_Revision_Tracking.html 
> 
>  
> which track the changes done workbook shared on network. Is revision time 
> being noted anywhere in your workbook your snapshot is not showing what is 
> the revision time you have entered 6,7 etc. 
>
> This is a bit difficult but not impossible,What i assumed is you each 
> sheet in Excel having the History sheet which tracks the changes with the 
> last line "The history ends with the changes saved on 11-01-2016 at 13:01." 
> after certain interval
>  
> Confirm this first !!
>
>
> Regards,
> Mandeep baluja
>
>
>
>
>

-- 
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 https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


correct folder name.xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12

$$Excel-Macros$$ vba code for listing folder name and file name

[Kat]

Hi all, 

I want to create a xlsm file which list out the folder name, file name and 
revision times with its corresponding date modified. When there is new file 
updated, i hope it can be updated automatically in the workbook. may I know 
how can I achieve this?

Thanks in advanced.


Cheers

-- 
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 https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ vba code for listing folder name and file name

[Kat]

Hi Abhi,

Unfortunately, the code doesn't apply for my case.


On Monday, January 11, 2016 at 2:52:34 PM UTC+8, Abhi wrote:
>
> Please see if this solves your purpose -
>
> http://www.vbaexpress.com/kb/getarticle.php?kb_id=837
>
> On Mon, Jan 11, 2016 at 11:55 AM, Kat <kather...@gmail.com > 
> wrote:
>
>> Hi Abhi,
>>
>> In terms of revision times, I want to show all the current revision 
>> times. Also, in the future, if there is any revision times being updated in 
>> the folder, I want it to be automatically being added in the excel sheet as 
>> well. Please see below the file situation and excel print screen as the 
>> result I want it to be shown. Let me know if you have any further issue. 
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> On Monday, January 11, 2016 at 1:26:07 PM UTC+8, Abhi wrote:
>>>
>>> Please elaborate what do you mean by "revision times". Do you want to 
>>> show the time when it was most recently updated or you want to show how 
>>> many times has it been updated?
>>>
>>>
>>> On Mon, Jan 11, 2016 at 9:52 AM, Kat <kather...@gmail.com> wrote:
>>>
>>>> Hi all, 
>>>>
>>>> I want to create a xlsm file which list out the folder name, file name 
>>>> and revision times with its corresponding date modified. When there is new 
>>>> file updated, i hope it can be updated automatically in the workbook. may 
>>>> I 
>>>> know how can I achieve this?
>>>>
>>>> Thanks in advanced.
>>>>
>>>>
>>>> Cheers
>>>>
>>>> -- 
>>>> 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 https://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 https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ vba code help for the open file location

[Kat]

 Hi all, 

I was wondering how could I make the open folder button for file name 
column instead of file location path column? For instance, from the picture 
below, when I point my cursor to 
C:\Users\maggie\Desktop\coke\diet\apr\2F6KB026 and click open file button, 
it will open the file 2F6KB026. At the moment, I would like to open the 
file 2F6KB026 by pointing my cursor to 2F6KB026. Please see attached for 
the vba code.

Thanks in advanced.


Cheers

-- 
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 https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


update button code.xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12

$$Excel-Macros$$ Re: vba code help for the open file location

[Kat]

Hi Baluja, 

It works well. Thanks a lot for your help. Appreciate that.


Cheers

On Friday, 8 January 2016 13:24:17 UTC+8, Mandeep Baluja wrote:
>
> Check this out !! 
>
> REgards, 
> Mandeep baluja 
>

-- 
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 https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ vba code for integrating particular information from different workbook to one workbook

[Kat]

Hi all,

I need help for vba code for creating a master file. I would like to create 
a master file which needs to be read only in Excel format. The information 
for the master file is integrated from three different excel workbooks and 
only a particular information (eg. Column B and Column E only) is 
outsourced for the master file. When the information in the workbook is 
updated, the master file needs to show the most updated status. Do you know 
how can I get this done?

Thanks in advanced.

-- 
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 https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ Excel Macro- source series for a chart from all sheets

[Kat]

I'm sorry, I'm still not having any luck with this. I'm getting
runtime error 91, object variable or With block not set.

Does this mean that when you select the sheets you deselect your
chart? How do I best write the code within the loop so that I do not
get this error?


On Jun 6, 3:22 pm, ashish koul koul.ash...@gmail.com wrote:
 Sub test()
 For i = 1 To Sheets.Count
 Sheets(i).Select

 ' paste ur code here

 Next i

 End Sub





 On Mon, Jun 6, 2011 at 2:12 PM, Kat viridiancade...@googlemail.com wrote:
  Hi all,

  I have a large spreadsheet, ~200 sheets. For each of these, I wish to
  plot a series where the x values are D3:D103 and the y values are
  E3:E103, and the series name is the same as that of the sheet, all on
  the same chart.

  So far I have

     ActiveChart.SeriesCollection.NewSeries
     ActiveChart.SeriesCollection(1).XValues = ='0,-1 '!R3C4:R103C4
     ActiveChart.SeriesCollection(1).Values = ='0,-1 '!R3C5:R103C5
     ActiveChart.SeriesCollection(1).Name = =0,-1 

  However, I am not sure how to loop this action to cover all worksheets
  in the book, and not sure how to get excel to automatically write the
  sheet name as the series name. Any ideas?

  Thanks in advance.

  -K

  --

  ---­---
  Some important links for excel users:
  1. Follow us on TWITTER for tips tricks and links :
 http://twitter.com/exceldailytip
  2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310
  3. Excel tutorials athttp://www.excel-macros.blogspot.com
  4. Learn VBA Macros athttp://www.quickvba.blogspot.com
  5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com

  To post to this group, send email to excel-macros@googlegroups.com

  
  Like our page on facebook , Just follow below link
 http://www.facebook.com/discussexcel

 --
 *Regards*
 * *
 *Ashish Koul*
 *akoul*.*blogspot*.com http://akoul.blogspot.com/http://akoul.posterous.com/
 *akoul*.wordpress.com http://akoul.wordpress.com/
 My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830

 P Before printing, think about the environment.- Hide quoted text -

 - Show quoted text -

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

$$Excel-Macros$$ Excel Macro- source series for a chart from all sheets

[Kat]

Hi all,

I have a large spreadsheet, ~200 sheets. For each of these, I wish to
plot a series where the x values are D3:D103 and the y values are
E3:E103, and the series name is the same as that of the sheet, all on
the same chart.

So far I have


ActiveChart.SeriesCollection.NewSeries
ActiveChart.SeriesCollection(1).XValues = ='0,-1 '!R3C4:R103C4
ActiveChart.SeriesCollection(1).Values = ='0,-1 '!R3C5:R103C5
ActiveChart.SeriesCollection(1).Name = =0,-1 

However, I am not sure how to loop this action to cover all worksheets
in the book, and not sure how to get excel to automatically write the
sheet name as the series name. Any ideas?

Thanks in advance.

-K

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel