$$Excel-Macros$$ Re: What is this Cache stands for.

2014-12-26 Thread Mandeep Baluja
You have installed a addin in your sheet. remove the addin first it will 
automatically remove. 

   1. 
   
   Click the Microsoft Office Button [image: Office button image], click Excel 
   Options, and then click Add-Ins. then select addin and press go uncheck 
   the addin. 
   


Regards,
Mandeep Baluja 
LearningZmyPassion
https://www.linkedin.com/profile/view?id=312532939
https://www.facebook.com/VBAEXCELSQL?ref=hl 


On Saturday, December 27, 2014 11:48:23 AM UTC+5:30, sandeep chhajer wrote:
>
> Dear Excel Gurus,
>
> Please check the print screen attached herewith. I am getting a sheet 
> called "Acerno_cache_x" with a status very hidden, in every workbook I 
> am opening.
>
> Can any one help me out.  
>
> -- 
> Regards,
> CA Sandeep Kumar Chhajer.
> Membership no: 160212
>  

-- 
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$$ Conditional Formatting

2014-12-26 Thread De Premor

PFA

On 27/12/2014 1:06, Alison Toczko wrote:
Hi. I have a spreadsheet with cells containing month and year (ie. Mar 
2014) without using a day. I would like the cell to be yellow if we 
are in the current month and year, and appear red if the month and 
year has passed. Using Excel 2013, what cell date formatting should I 
use, and how should the formula be structured? Thank you.

--
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.


month colour.xlsx
Description: MS-Excel 2007 spreadsheet


$$Excel-Macros$$ Conditional Formatting

2014-12-26 Thread Alison Toczko
Hi. I have a spreadsheet with cells containing month and year (ie. Mar 
2014) without using a day. I would like the cell to be yellow if we are in 
the current month and year, and appear red if the month and year has 
passed. Using Excel 2013, what cell date formatting should I use, and how 
should the formula be structured? Thank you.

-- 
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$$ Help on coding to change cell value after every printing

2014-12-26 Thread Ashish Bhalara
Dear experts,

I want to change cell value on every automatic printing as per series
given, please see attached file in which describe in detail.

Regards.
Ashish Bhalara
9624111822
P*Please do not print this email unless it is absolutely necessary. Spread
environmental üawareness.♣♣♣*

-- 
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.


query.xls
Description: MS-Excel spreadsheet


$$Excel-Macros$$ Re: Import file from Text Fil

2014-12-26 Thread Mandeep Baluja
Want this result ?
Regards,
Mandeep Baluja 
LearningZmyPassion
https://www.linkedin.com/profile/view?id=312532939
https://www.facebook.com/VBAEXCELSQL?ref=hl 


On Friday, December 26, 2014 4:33:13 PM UTC+5:30, saravanan R wrote:
>
> Hi Team,
>
> I have an query on Importing text file , delimit by "Seperator" and make 
> particular column to be text, and import the same data into excel update 
> those data from Row 2.
>
> thanks & regards,
> saravanan R
>
>

-- 
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.


abc.xlsx
Description: MS-Excel 2007 spreadsheet


Re: $$Excel-Macros$$ Re: Import file from Text Fil

2014-12-26 Thread saravanan R
here it is

On Fri, Dec 26, 2014 at 4:55 PM, Mandeep Baluja 
wrote:

> send file
>
> On Friday, December 26, 2014 4:33:13 PM UTC+5:30, saravanan R wrote:
>>
>> Hi Team,
>>
>> I have an query on Importing text file , delimit by "Seperator" and make
>> particular column to be text, and import the same data into excel update
>> those data from Row 2.
>>
>> thanks & regards,
>> saravanan R
>>
>>  --
> 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.
000707  SAR VAOOWJO (MWX)   600660.06.2014  6000802776  
8   XXIOW666T60 OW666\T60   6800,000600,000 6600,000
6,872668,00 6600,0002668,00 0,000   0,0006.62.2014   N\A
06.62.2014
000707  SAR VAOOWJO (MWX)   600670.00.2014  6000868766  
00022   XXIRZ7XT60  RZ7X\T600060,000200,000 0760,000
0,707682,00 7220,0000660,00 0,000   0,0028.66.2014   N\A
67.62.2014
000707  SAR VAOOWJO (MWX)   600670.00.2014  6000868766  
00068   XXIOW666T60 OW666\T60   6800,0000,000   6800,000
6,877766,00 0,000   0,006800,0007766,00 26.62.2014  0 or 
OWss   . .
000707  SAR VAOOWJO (MWX)   600606.06.2014  6000876266  
7   XXIOW686T60 OW686\T60   7600,0002200,000
6600,0006,602760,00 6600,0002760,00 0,000   0,00
00.62.2014   N\A27.66.2014
000707  SAR VAOOWJO (MWX)   600620.06.2014  6000870866  
2   XXXWON7077  WON7\0776080,0000,000   6080,000
6,08,60 6080,000,60 0,000   0,0027.62.2014   N\A
27.62.2014
000707  SAR VAOOWJO (MWX)   600627.06.2014  6000878668  
6   XXIRZ7XT60  RZ7X\T602000,0000,000   2000,000
0,706000,00 2000,0006000,00 0,000   0,0028.66.2014   N\A
06.62.2014
000707  SAR VAOOWJO (MWX)   600627.06.2014  6000878666  
0   XXIOW676T60 OW676\T60   0600,0002800,000
2600,0006,706000,00 2600,0006000,00 0,000   0,00
66.66.2014   N\A66.62.2014
000707  SAR VAOOWJO (MWX)   600620.07.2014  6000888670  
00062   XXIOW006T60 OW006\T60   6800,000600,000 6600,000
0,866676,00 6200,0007602,00 0,000   0,0008.62.2014   N\A
66.62.2014
000707  SAR VAOOWJO (MWX)   60

$$Excel-Macros$$ Re: Import file from Text Fil

2014-12-26 Thread Mandeep Baluja
send file

On Friday, December 26, 2014 4:33:13 PM UTC+5:30, saravanan R wrote:
>
> Hi Team,
>
> I have an query on Importing text file , delimit by "Seperator" and make 
> particular column to be text, and import the same data into excel update 
> those data from Row 2.
>
> thanks & regards,
> saravanan R
>
>

-- 
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$$ Strange behaviour with no developer code changes

2014-12-26 Thread John A Cooke

With shtControlPanel
Select Case UCase(strValue)
Case cstrMONTHLY_PAID
.optMonthly.Value = True
DB_PayFrequency = PayMonthly
intFrequency = cintMONTHLY_PAID
Case cstrWEEKLY_PAID
.optWeekly.Value = True
DB_PayFrequency = PayWeekly
intFrequency = cintWEEKLY_PAID
Case cstr4WEEKLY_PAID
.optOther.Value = True
DB_PayFrequency = PayEvery4Weeks
intFrequency = cint4WEEKLY_PAID
Case Else
.optWeekly.Value = True
DB_PayFrequency = PayWeekly
intFrequency = cintWEEKLY_PAID
End Select

' ...

End With

In this code fragment, shtControlPanel is the CodeName of the worksheet 
containing, among other things, 3 ActiveX option button (radio) controls, 
namelY:

optMonthly
optWeekly
optOther

This code fragment has worked for months in Excel 2013 workbooks.

Suddenly, without any alterations made to the software, the code fails at 
the compile stage opening the workbook, objecting to optMonthly, saying the 
member cannot be found.

Has anyone experienced a similar problem?

The environment has bee subject to Windows updates only.

Any ideas would be appreciated.

Thanks

John A Cooke

-- 
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$$ Import file from Text Fil

2014-12-26 Thread saravanan R
Hi Team,

I have an query on Importing text file , delimit by "Seperator" and make
particular column to be text, and import the same data into excel update
those data from Row 2.

thanks & regards,
saravanan R

-- 
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$$ Urgent need of Advanced Excel Teacher

2014-12-26 Thread Vani Sharma
All,

Do we have a directory of teachers in MS Excel-both newbies and Advanced? I 
need someone in Indore(Madhya Pradesh, India) urgently.

Regards,
Vani Sharma
Information transmitted by this e-mail is proprietary to Mphasis, its 
associated companies and/ or its customers and is intended 
for use only by the individual or entity to which it is addressed, and may 
contain information that is privileged, confidential or 
exempt from disclosure under applicable law. If you are not the intended 
recipient or it appears that this mail has been forwarded 
to you without proper authority, you are notified that any use or dissemination 
of this information in any manner is strictly 
prohibited. In such cases, please notify us immediately at 
mailmas...@mphasis.com and delete this mail from your records.

-- 
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: Complex formula Solution

2014-12-26 Thread Mandeep Baluja
=IF($K$3="ABB",IF(INDEX(A1:A195,MATCH(MIN(ABS($B$2:$B$195-M12)),ABS($B$2:$B$195-M12),0),0)https://www.linkedin.com/profile/view?id=312532939
https://www.facebook.com/VBAEXCELSQL?ref=hl 



On Wednesday, December 24, 2014 6:44:29 PM UTC+5:30, amar takale wrote:
>
> Dear experts team, 
>
> I required formula to extract data as par my criteria but it is very 
> complex criteria but my thought is that everything is possible in 
> excel. 
>
> Appreciate the help. 
>
> Let us know in case of any further assistance. 
>
> Regards 
> Amar 
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/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.


Report Data (2)Final.xls
Description: MS-Excel spreadsheet