RE: $$Excel-Macros$$ Save as PDF for 2003

2013-11-12 Thread Ravi Kumar 
K download primopdf or nitropdf software or any pdf machine software

 

Then u can convert excel into pdf

 

By using  "activesheet.printout" or by pressing : ctrl+P

 

 

 

Warm Regards,

Ravi Kumar.

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Pavan Valluru
Sent: Wednesday, November 13, 2013 12:34 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Save as PDF for 2003

 

Dear Ravi,

 

The below code doesnt work in 2003.

 

-Pavan

On Wednesday, 13 November 2013 12:09:39 UTC+5:30, Ravi Kumar wrote:

Hi,

 

 

Try this.

Sub saveasPDFE()

ActiveWorkbook.ExportAsFixedFormat Type:=xlTypePDF,
Filename:=ActiveWorkbook.Path & "\Filename.PDF"

End Sub

 

 

 

Warm Regards,

Ravi Kumar.

 

From: excel-...@googlegroups.com 
[mailto:excel-...@googlegroups.com  ] On Behalf Of Pavan
Valluru
Sent: Wednesday, November 13, 2013 12:05 PM
To: excel-...@googlegroups.com  
Subject: $$Excel-Macros$$ Save as PDF for 2003

 

Can anyone has code to Save as PDF for excel 2003? If yes, please shares.

 

-Pavan

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
 
FORUM RULES
 
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
not get quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security
measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
 
NOTE : Don't ever post confidential data in a workbook. Forum owners and
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups
"MS EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to excel-macros...@googlegroups.com  .
To post to this group, send email to excel-...@googlegroups.com
 .
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

-- 
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/groups/opt_out.

-- 
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/groups/opt_out.

Re: $$Excel-Macros$$ Save as PDF for 2003

2013-11-12 Thread Pavan Valluru 
Dear Ravi,

The below code doesnt work in 2003.

-Pavan

On Wednesday, 13 November 2013 12:09:39 UTC+5:30, Ravi Kumar wrote:
>
> Hi,
>
>  
>
>  
>
> Try this…
>
> Sub saveasPDFE()
>
> ActiveWorkbook.ExportAsFixedFormat Type:=xlTypePDF, 
> Filename:=ActiveWorkbook.Path & "\Filename.PDF"
>
> End Sub
>
>  
>
>  
>
>  
>
> *Warm Regards,*
>
> *Ravi Kumar.*
>
>  
>
> *From:* excel-...@googlegroups.com  [mailto:
> excel-...@googlegroups.com ] *On Behalf Of *Pavan Valluru
> *Sent:* Wednesday, November 13, 2013 12:05 PM
> *To:* excel-...@googlegroups.com 
> *Subject:* $$Excel-Macros$$ Save as PDF for 2003
>
>  
>
> Can anyone has code to Save as PDF for excel 2003? If yes, please shares.
>
>  
>
> -Pavan
>
> -- 
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
> https://www.facebook.com/discussexcel
>  
> FORUM RULES
>  
> 1) Use concise, accurate thread titles. Poor thread titles, like Please 
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice 
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security 
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>  
> NOTE : Don't ever post confidential data in a workbook. Forum owners and 
> members are not responsible for any loss.
> --- 
> You received this message because you are subscribed to the Google Groups 
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an 
> email to excel-macros...@googlegroups.com .
> To post to this group, send email to excel-...@googlegroups.com
> .
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/groups/opt_out.
>

-- 
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/groups/opt_out.

Re: $$Excel-Macros$$ Save as PDF for 2003

2013-11-12 Thread Pavan Chowdary 
That code does nt work in 2003. I need it for 2003.


On Wed, Nov 13, 2013 at 12:09 PM, Ravi Kumar wrote:

> Hi,
>
>
>
>
>
> Try this…
>
> Sub saveasPDFE()
>
> ActiveWorkbook.ExportAsFixedFormat Type:=xlTypePDF,
> Filename:=ActiveWorkbook.Path & "\Filename.PDF"
>
> End Sub
>
>
>
>
>
>
>
> *Warm Regards,*
>
> *Ravi Kumar.*
>
>
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Pavan Valluru
> *Sent:* Wednesday, November 13, 2013 12:05 PM
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ Save as PDF for 2003
>
>
>
> Can anyone has code to Save as PDF for excel 2003? If yes, please shares.
>
>
>
> -Pavan
>
> --
> 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/groups/opt_out.
>
>  --
> 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 a topic in the
> Google Groups "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this topic, visit
> https://groups.google.com/d/topic/excel-macros/XOUB6R0KrhI/unsubscribe.
> To unsubscribe from this group and all its topics, 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/groups/opt_out.
>

-- 
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/groups/opt_out.

RE: $$Excel-Macros$$ Save as PDF for 2003

2013-11-12 Thread Ravi Kumar 
Hi,

 

 

Try this.

Sub saveasPDFE()

ActiveWorkbook.ExportAsFixedFormat Type:=xlTypePDF,
Filename:=ActiveWorkbook.Path & "\Filename.PDF"

End Sub

 

 

 

Warm Regards,

Ravi Kumar.

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Pavan Valluru
Sent: Wednesday, November 13, 2013 12:05 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Save as PDF for 2003

 

Can anyone has code to Save as PDF for excel 2003? If yes, please shares.

 

-Pavan

-- 
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/groups/opt_out.

-- 
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/groups/opt_out.

$$Excel-Macros$$ Save as PDF for 2003

2013-11-12 Thread Pavan Valluru 
Can anyone has code to Save as PDF for excel 2003? If yes, please shares.

-Pavan

-- 
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/groups/opt_out.

$$Excel-Macros$$ paste multiple ranges in vba excel 2010

2013-11-12 Thread cristian paduraru 
Hello to You all,



I encountered following issue:
I want to copy multiple ranges and paste to it in the specific ranges. I 
will send you down the vba code:

Sub seldate()

Range("F10").Select

Application.CutCopyMode = False

ActiveCell.FormulaR1C1 = "1/1/2011"

Range("F11").Select

ActiveCell.FormulaR1C1 = "=R[-1]C+1"

Range("F11").Select

Selection.Copy

Range("F12:F41").Select

ActiveSheet.Paste

Range("G12,G17,G22").Select

 Selection.copy

Range("H12,H17,H22").Select

Activesheet.Paste
End Sub

Well, the vba send an error occur in multiple paste.
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/groups/opt_out.

$$Excel-Macros$$ Re: Macro Modification Needed To Include Start/Stop Time

2013-11-12 Thread Bill Q 
Hi, 
 
Looking to have code in attached modified slightly to :
 
A. Only function between Monday and Friday.
B. To work in a loop. IE: It's activated at a certain time to start on 
Monday and goes off at a certain time on Monday - THEN starts again at the 
same time on Tuesday and goes off at the same time on Tuesday. so on 
and so forth until end of day Friday.
 
Thanks.  
 

On Tuesday, December 11, 2012 5:25:54 PM UTC-5, Bill Q wrote:

> Hi, 
>  
> Looking for code to be modified using military time if possible. I would 
> just go into the code and modify the time when needed. 
>  
> Thanks.
>  
>

-- 
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/groups/opt_out.

Re: $$Excel-Macros$$ Macro Modification Needed To Include Start/Stop Time

2013-11-12 Thread Bill Q 

On Thursday, December 13, 2012 8:48:25 PM UTC-5, Enrique Martin wrote:
>
> My Pleasure.. You have given me new title.
>
>
> On Fri, Dec 14, 2012 at 12:57 AM, Bill Q 
> > wrote:
>
>> Just what the doctor ordered. Thank you very much Dr. Anoop.
>>  
>> Much appreciated.
>>  
>>  
>>
>> On Thursday, December 13, 2012 1:59:22 AM UTC-5, Enrique Martin wrote:
>>
>>> Hi Bill,
>>>
>>> I have modified the code which will work within stipulated time as 
>>> described above.
>>> I have also provided two command buttons to stop the scheduler forcely.
>>>
>>> Regards,
>>> Anoop
>>> Sr. Developer
>>>
>>>
>>>
>>> On Thu, Dec 13, 2012 at 2:25 AM, Bill Q  wrote:
>>>
 To be more specific.
  
 In this case I want to query the S&P 500 every minute between 09:00 and 
 16:30. 
  
 Thanks for all your input.
  

 On Wednesday, December 12, 2012 10:09:26 AM UTC-5, Bill Q wrote:

> From what I can see, it looks like this will interfere with the 
> runintervalminutes (which is important to be seperate). Also, how to I 
> get 
> it to stop at a specific time ?  
>  
>  
>
> On Wednesday, December 12, 2012 2:44:15 AM UTC-5, Enrique Martin wrote:
>
>> Hi Bill,
>>
>> There are two variable defined in your module. These are "RunWhen" 
>> and "SaveWhen".
>> Both of them are being used with timeserial value.
>>
>> You can provide your desired time in this parameter(TimeSerial).
>> Suppose you want to Run your code at 1500 hrs then you can modify 
>> your code as below:
>> RunWhen = Now + TimeSerial(15, 0, 0).
>> Similarly, you can set up your Save Time by modifying SaveWhen syntax.
>>
>> You can also make your code run on specific date/time.
>>
>> Regards,
>> Anoop
>> Sr. Developer
>>
>>
>> On Wed, Dec 12, 2012 at 3:55 AM, Bill Q  wrote:
>>
>>> Hi, 
>>>  
>>> Looking for code to be modified using military time if possible. I 
>>> would just go into the code and modify the time when needed. 
>>>  
>>> Thanks.
>>>  
>>>
>>> -- 
>>> 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 post to this group, send email to excel-...@googlegroups.com.
>>> To unsubscribe from this group, send email to 
>>> excel-macros...@googlegroups.com.
>>> Visit this group at http://groups.google.com/group
>>> /excel-macros?hl=en.
>>>  
>>>  
>>>
>>
>>
>>
>> -- 
>> Regards,
>> Anoop
>> Sr. Developer
>>
>>   -- 
 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 post to this group, send email to excel-...@googlegroups.com.
 To unsubscribe from this group, send email to excel-macros...@
 googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros?hl=en.
  
  

>>>
>>>
>>>
>>> -- 
>>> Regards,
>>> Anoop
>>> Sr. Developer
>>>
>>>   -- 
>> 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 Proble

$$Excel-Macros$$ Email Validation Micro

2013-11-12 Thread Rupesh Patil 
Hi Experts,

I am writing email validation micro, also i sharing my code with you, can
any buddy tell where I am going wrong. I have to call this funtion on text
box Exit event

code is

Public Function isEmailValid(ByVal strEmailAdd As String) As Boolean
'MsgBox ("ok")
With CreateObject("VBScript.RegExp")
.IgnoreCase = True
.Global = True
.Pattern =
"^([a-zA-Z0-9_\-\.]+)@[A-Z0-9-]+(\.[a-z0-9-]+)*(\.[a-z]{2,3})$"
blnEmailValid = .Test(strEmailAdd)
End With

End Function

-- 
Thanks and Regards, Rp.

-- 
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/groups/opt_out.

$$Excel-Macros$$ Reverse an Array

2013-11-12 Thread Pavan Valluru 
Guyz Can i know how to reverse ana array in VBA. I am passing values like 
MyArray(1) = 1,MyArray(2) = 2,MyArray(3) = 3
But i need to reverse that array without using loop. Is there any direct 
function to reverse it? i need output like MyArray(1) = 3, MyArray (2)= 2 & 
MyArray(3) = 1.

Thanks in Advance.

-Pavan

-- 
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/groups/opt_out.

$$Excel-Macros$$ Formula to fetch employee names based on time

2013-11-12 Thread Abhishek Jain 
Friends,

> I have a file, wherein I have times when employees are scheduled to work.
These times are in PST.
> I have a table where I have noted the hours of a day in different
timezones.
> All I need is a formula (not VBA) that will show the corresponding
employee name(s) working on that hour based on selection.

See attached sample file - I have clarified.

Any and all help will be appreciated.

Thanks in advance.

Best regards,

Abhishek

-- 
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/groups/opt_out.


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

$$Excel-Macros$$ Re: To know about the substitute of SQL.REQUEST

2013-11-12 Thread Basole 

Dear Sandeep, follow a link to an example of integration excel + access. 
And excel working with front-end

Link: http://www.4shared.com/rar/z6j4vQEO/Excel-Access.html

tks. regards. 

Basole.



Em quarta-feira, 17 de julho de 2013 11h48min43s UTC-3, Sandeep Kumar 
Baranwal escreveu:
>
> Hi
>
> Kindly note that sql.request is functional in MS Excel 2007 but not in MS 
> Excel 2010. Could you please let me know any VBA code that would be a 
> substitute for sql.request. 
> If yes, Please let me know with the help of an example.
> We use sql.request to transfer data from MS Access to MS Excel in version 
> 2007
>
>
> Thanks & regards,
> *Sandeep Kumar Baranwal*
> Business Analyst
> Credit Risk Methodology & Wholesale Basel,Genpact
> Gurgaon
> India
> Mob:-+91-8588802543
>
>  

-- 
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/groups/opt_out.

$$Excel-Macros$$ Different Time Zones display

2013-11-12 Thread Abhishek Jain 
Friends,

> I have a file, wherein I have times when employees are scheduled to work.
These times are in PST.
> I have a table where I have noted the hours of a day in different
timezones.
> All I need is a formula (not VBA) that will show the corresponding
employee name(s) working on that hour based on selection.

See attached sample file - I have clarified.

Any and all help will be appreciated.

Thanks in advance.

Best regards,

Abhishek

-- 
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/groups/opt_out.


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

$$Excel-Macros$$ Re: VBA Macro problem - Excel 2007

2013-11-12 Thread krazykasper1 

On Monday, September 23, 2013 10:27:18 AM UTC-5, Krazy Kasper wrote: 
>
>  I pull data for individual customers from a source system into an Excel 
> workbook. I have a separate Excel workbook template that contains macros, 
> which allow me to reformat the data in the source workbook. I am trying to 
> "add" another macro that will do additional formatting, but when trying to 
> run the following Macro, I get a runtime error. (In the example provided 
> below, the source workbook is Jervis detail-1.xls).The error message says:
> Runtimme Error '9'
> Subscript out of range.
>
> Using Debug, it is the second line of code, which reads:
> Active Workbook.worksheets ("Jervis detail-1").Sort.Sortfields.clear
>
> For some reason it appears to not be picking up the correct workbook or 
> worksheet name.
> Appreciate all help.
>
>
>
> Sub Sort()
> '
> ' Sort Macro
> ' Sort the data
> '
> '
> Cells.Select
> ActiveWorkbook.Worksheets("Jervis detail-1").Sort.SortFields.Clear
> ActiveWorkbook.Worksheets(ActiveWorksheet).Sort.SortFields.Add Key:=Range( 
> _
> "A2:A1500"), SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:= _
> xlSortNormal
> ActiveWorkbook.Worksheets(ActiveWorksheet).Sort.SortFields.Add Key:=Range( 
> _
> "L2:L1500"), SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:= _
> xlSortNormal
> ActiveWorkbook.Worksheets(ActiveWorksheet).Sort.SortFields.Add Key:=Range( 
> _
> "P2:P1500"), SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:= _
> xlSortNormal
> ActiveWorkbook.Worksheets(ActiveWorksheet).Sort.SortFields.Add Key:=Range( 
> _
> "X2:X1500"), SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:= _
> xlSortNormal
> ActiveWorkbook.Worksheets(ActiveWorksheet).Sort.SortFields.Add Key:=Range( 
> _
> "Y2:Y1500"), SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:= _
> xlSortNormal
> With ActiveWorkbook.Worksheets(ActiveWorksheet).Sort
> .SetRange Range("A1:AH1500")
> .Header = xlYes
> .MatchCase = False
> .Orientation = xlTopToBottom
> .SortMethod = xlPinYin
> .Apply
> End With
> Columns("Q:Q").Select
> Selection.NumberFormat = "$#,##0.00"
> Selection.NumberFormat = "$#,##0.0"
> Selection.NumberFormat = "$#,##0"
> Columns("R:R").Select
> Selection.NumberFormat = "0.00"
> Selection.NumberFormat = "0.0"
> Selection.NumberFormat = "0"
> Range("A1").Select
> 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 http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

Re: $$Excel-Macros$$ Re: To know about the substitute of SQL.REQUEST

2013-11-12 Thread Sandeep Kumar Baranwal 
Hi Basole

I am glad you understood my requirement.
Kindly share the models that use excel to ms access with tables and indexes
at your convenience.

Looking forward to your generous help once again.


Thanks & regards,
*Sandeep Kumar Baranwal*
Assistant Manager
Credit Risk Methodology & Wholesale Basel,Genpact
Gurgaon
India
Mob:-+91-8588802543



On Sat, Nov 9, 2013 at 8:44 AM, Basole  wrote:

>
> Dear Sandeep, it seems to me that this code was used in excel 2003 with
> connection via the "ODBC" nowadays use more connection "ADO" "DAO" etc..
> Well I have some models use excel to ms Access with tables and indexes,
> which I will share with you.
>
> Regards,
>
> Basole.
>
>
>
>
>
>
> Em quarta-feira, 17 de julho de 2013 11h48min43s UTC-3, Sandeep Kumar
> Baranwal escreveu:
>>
>> Hi
>>
>> Kindly note that sql.request is functional in MS Excel 2007 but not in MS
>> Excel 2010. Could you please let me know any VBA code that would be a
>> substitute for sql.request.
>> If yes, Please let me know with the help of an example.
>> We use sql.request to transfer data from MS Access to MS Excel in version
>> 2007
>>
>>
>> Thanks & regards,
>> *Sandeep Kumar Baranwal*
>> Business Analyst
>> Credit Risk Methodology & Wholesale Basel,Genpact
>> Gurgaon
>> India
>> Mob:-+91-8588802543
>>
>>   --
> 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/groups/opt_out.
>

-- 
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/groups/opt_out.