Re: $$Excel-Macros$$ Convert Excel Ranges to PDF

2011-04-29 Thread STDEV(i)
Save As *.PDF  (excel 2007)

[image: save as PDF.GIF]


On Thu, Apr 28, 2011 at 7:39 PM, Anil Bhange 
anil.bha...@tatacommunications.com wrote:

 Hi Expert,



 I am having one excel file which contains many report, I wanted to convert
 the same in PDF. Below example will give you further details,



 Sheet 1 : from A2 : K30

 Sheet 2 : from A2 : K 45

 Sheet 4 : from B5 : H14



 Worksheet also has other details but I wanted to convert those specific
 range only.



 Thanks  Regards,



 Anil Bhange

 IP - 512320




-- 
--
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
save as PDF.GIF

Re: $$Excel-Macros$$ Help Required!

2011-04-29 Thread syed aliya raza hashim
Hi Andred,

see for example in sheet1 UPS 28-Apr-12

  Battery  28-Jul-11
   SMPS  2-Jan-11


then i want the meassage box should display message when  we open the file
--like ur UPS product will expire in 1 year 0r 365 days because it will
calculate from today date so today is 28 april-2011 but for UPS date entry
is 28-Apr-2012 so that means it will expire in 365 days

same for Battery ur Battery product will expire after 3 month because
today date is 28 april 2011 and battery entry date is 28 jul-2011 so that
means it will expire after 3 month

but for SMPS product no need to display because the date mention for SMS is
02-jan-2011 which is already expired on


so if the above condition is there for all
product in all sheet then i want to display the message box for all sheet if
remaining date is there to expire from current date





2011/4/28 André D'Avila C

 Hello Syed,

 Let me understand...

 You have in Sheet1 - UPS, Battery and SMPS
   Sheet2 - Phone, Data Card, Lenser
   Sheet3 - Keyboard, Mouse and Monitor

 You want when the file open,  a message like:

 Ur product UPS will expire in X days
 Ur product Battery will expire in X days
 Ur product SMPS will expire in X days
 Ur product Phone will expire in X days
 Ur product Data Card will expire in X days
 Ur product Lenser will expire in X days
 Ur product Keyboard will expire in X days
 Ur product Mouse will expire in X days
 Ur product Monitor will expire in X days

 Or
 Each time you open a sheet, for exemple sheet3

 That automaticaly a message shows and display:

 Ur product Keyboard will expire in X days
 Ur product Mouse will expire in X days
 Ur product Monitor will expire in X days


 Best Regards

 André Luiz D´Avila



 2011/4/28 syed aliya raza hashim hashim...@gmail.com

 Hi,
 Problem is stated in file itself ,
 the problem is how to displaly the meassage box suppose date column is
 there is all sheets i want to display the meaasage like this product will be
 expired on one month or 30 days or more
 *when we open the file *

 see in the attachment

 --
 syed aliya

 --

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


  --

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




-- 
syed aliya

-- 
--
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$$ Fwd: Plz help me

2011-04-29 Thread sanjay maurya
All Friends

I have some solution. I have problem to create the report look in attached
Excel Sheet.

-- 
***Thanks  Best Regards**
Sanjay Kumar Maurya*

*
Life is Very beautiful !!!
*
*
¨`•.•´¨) Always
`•.¸(¨`•.•´¨) Keep
(¨`•.•´¨)¸.•´ Smiling!
 `•.¸.•´.
*

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


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


$$Excel-Macros$$ How to include new Rs font in Excel Currency format (option in format cell)

2011-04-29 Thread vaibhav joshi
Hello everybody

Can any one tell me how to insert New Rs font in currency format in excel.
So that when ever i type any amt that should reflect  also to ensure that i
can use that cell for formula also

Regards

Vaibhav

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


Re: $$Excel-Macros$$ Help Required!

2011-04-29 Thread ashish koul
try this macro


Sub t()


Dim i, j, k  As Long

For ww = 1 To Worksheets.Count

Sheets(ww).Activate
For j = 2 To Sheets(ww).Range(a1).End(xlDown).Row
If Sheets(ww).Cells(j, 4).Value - DateSerial(Year(Now), Month(Now),
Day(Now)) = 1 Then

MsgBox Sheets(ww).Cells(j, 1).Value   Will Expire in  
Abs(DateSerial(Year(Now), Month(Now), Day(Now)) - Sheets(ww).Cells(j,
4).Value)  days
End If

Next j

Next ww

End Sub




On Fri, Apr 29, 2011 at 9:04 AM, syed aliya raza hashim hashim...@gmail.com
 wrote:

 Hi Andred,

 see for example in sheet1 UPS 28-Apr-12

   Battery  28-Jul-11
SMPS  2-Jan-11


 then i want the meassage box should display message when  we open the file
 --like ur UPS product will expire in 1 year 0r 365 days because it will
 calculate from today date so today is 28 april-2011 but for UPS date entry
 is 28-Apr-2012 so that means it will expire in 365 days

 same for Battery ur Battery product will expire after 3 month because
 today date is 28 april 2011 and battery entry date is 28 jul-2011 so that
 means it will expire after 3 month

 but for SMPS product no need to display because the date mention for SMS is
 02-jan-2011 which is already expired on


 so if the above condition is there for all
 product in all sheet then i want to display the message box for all sheet if
 remaining date is there to expire from current date





 2011/4/28 André D'Avila C

 Hello Syed,

 Let me understand...

 You have in Sheet1 - UPS, Battery and SMPS
   Sheet2 - Phone, Data Card, Lenser
   Sheet3 - Keyboard, Mouse and Monitor

 You want when the file open,  a message like:

 Ur product UPS will expire in X days
 Ur product Battery will expire in X days
 Ur product SMPS will expire in X days
 Ur product Phone will expire in X days
 Ur product Data Card will expire in X days
 Ur product Lenser will expire in X days
 Ur product Keyboard will expire in X days
 Ur product Mouse will expire in X days
 Ur product Monitor will expire in X days

 Or
 Each time you open a sheet, for exemple sheet3

 That automaticaly a message shows and display:

 Ur product Keyboard will expire in X days
 Ur product Mouse will expire in X days
 Ur product Monitor will expire in X days


 Best Regards

 André Luiz D´Avila



 2011/4/28 syed aliya raza hashim hashim...@gmail.com

 Hi,
 Problem is stated in file itself ,
 the problem is how to displaly the meassage box suppose date column is
 there is all sheets i want to display the meaasage like this product will be
 expired on one month or 30 days or more
 *when we open the file *

 see in the attachment

 --
 syed aliya

 --

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


 --

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




 --
 syed aliya

 --

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




-- 
*Regards*
* *
*Ashish Koul*
*akoul*.*blogspot*.com http://akoul.blogspot.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.

-- 

Re: $$Excel-Macros$$ Convert Excel Ranges to PDF

2011-04-29 Thread rajan verma
Download DoPDF from Internet..  Select the Range  and Print seletion by this
doPDF Printer...

On Thu, Apr 28, 2011 at 6:09 PM, Anil Bhange 
anil.bha...@tatacommunications.com wrote:

 Hi Expert,



 I am having one excel file which contains many report, I wanted to convert
 the same in PDF. Below example will give you further details,



 Sheet 1 : from A2 : K30

 Sheet 2 : from A2 : K 45

 Sheet 4 : from B5 : H14



 Worksheet also has other details but I wanted to convert those specific
 range only.



 Thanks  Regards,



 Anil Bhange

 IP - 512320



 --

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




-- 
Regards
Rajan verma
+91 9158998701

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


Re: $$Excel-Macros$$ Fwd: Plz help me

2011-04-29 Thread Yogesh Gohil
Check this might be it help


On Fri, Apr 29, 2011 at 9:45 AM, sanjay maurya mail2sanja...@gmail.comwrote:


 All Friends

 I have some solution. I have problem to create the report look in attached
 Excel Sheet.

 --
 ***Thanks  Best Regards**
 Sanjay Kumar Maurya*

 *
 Life is Very beautiful !!!
 *
 *
 ¨`•.•´¨) Always
 `•.¸(¨`•.•´¨) Keep
 (¨`•.•´¨)¸.•´ Smiling!
  `•.¸.•´.
 *



  --

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




-- 
Hello,





This is
Yash

Bye...

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


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


$$Excel-Macros$$ How do I transfer subtotal account Nr. along with its balance?

2011-04-29 Thread celadol_a
Hello Guys,

Please, I have generated a subtotal spreadsheet with over 150 accounting 
numbers with their balances that need to be transfered to another sheet to 
generate Trial Balance figures and Balance Sheet. Kindly tell me on how to do 
it.

Thank you and Best Regards.
Reginald Ok
Sent from my BlackBerry® wireless handheld from Glo Mobile.

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


Re: $$Excel-Macros$$ Fwd: Plz help me

2011-04-29 Thread rajan verma
Hi Sanjay
Hope it will help you..


On Fri, Apr 29, 2011 at 9:45 AM, sanjay maurya mail2sanja...@gmail.comwrote:


 All Friends

 I have some solution. I have problem to create the report look in attached
 Excel Sheet.

 --
 ***Thanks  Best Regards**
 Sanjay Kumar Maurya*

 *
 Life is Very beautiful !!!
 *
 *
 ¨`•.•´¨) Always
 `•.¸(¨`•.•´¨) Keep
 (¨`•.•´¨)¸.•´ Smiling!
  `•.¸.•´.
 *



  --

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




-- 
Regards
Rajan verma
+91 9158998701

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


personal file.xlsm
Description: Binary data


Re: $$Excel-Macros$$ help macro commands need -reg

2011-04-29 Thread rajan verma
http://www.ozgrid.com/
http://www.ozgrid.com/http://www.excel-vba.com/excel-vba-contents.htm
http://www.excel-vba.com/excel-vba-contents.htm
http://www.webandmacros.net/excel-macros-vba.htm

On Fri, Apr 29, 2011 at 7:55 PM, jmothilal gjmothi...@gmail.com wrote:

 Dear  any one

 i want to learn macro commands , can u help me  send the macro commands

 --
 J.Mohilal
 Universal Computer Systems
 # 16, Brindavan Complex
 Otteri, Vellore-2

 --

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




-- 
Regards
Rajan verma
+91 9158998701

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


Re: $$Excel-Macros$$ How do I transfer subtotal account Nr. along with its balance?

2011-04-29 Thread rajan verma
Please attach a Sample File..

On Fri, Apr 29, 2011 at 2:56 PM, celado...@yahoo.com wrote:

 Hello Guys,

 Please, I have generated a subtotal spreadsheet with over 150 accounting
 numbers with their balances that need to be transfered to another sheet to
 generate Trial Balance figures and Balance Sheet. Kindly tell me on how to
 do it.

 Thank you and Best Regards.
 Reginald Ok
 Sent from my BlackBerry® wireless handheld from Glo Mobile.

 --

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




-- 
Regards
Rajan verma
+91 9158998701

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


Re: $$Excel-Macros$$ How do I transfer subtotal account Nr. alongwith its balance?

2011-04-29 Thread celadol_a
Rajan,
Please, kindly send again the sample file as I did not get the attached file 
referenced. Thanks.
Sent from my BlackBerry® wireless handheld from Glo Mobile.

-Original Message-
From: rajan verma rajanverma1...@gmail.com
Sender: excel-macros@googlegroups.com
Date: Fri, 29 Apr 2011 21:03:21 
To: excel-macros@googlegroups.com
Reply-To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ How do I transfer subtotal account Nr. along
 with its balance?

Please attach a Sample File..

On Fri, Apr 29, 2011 at 2:56 PM, celado...@yahoo.com wrote:

 Hello Guys,

 Please, I have generated a subtotal spreadsheet with over 150 accounting
 numbers with their balances that need to be transfered to another sheet to
 generate Trial Balance figures and Balance Sheet. Kindly tell me on how to
 do it.

 Thank you and Best Regards.
 Reginald Ok
 Sent from my BlackBerry® wireless handheld from Glo Mobile.

 --

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




-- 
Regards
Rajan verma
+91 9158998701

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

-- 
--
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 pulling data from Crystal report

2011-04-29 Thread Hall
I know I can export a Crystal report to Excel format from the Crystal
Viewer.

But is it possible to have my Excel file initiate the export from
Crystal into the same Excel file or a different Excel file?

-- 
--
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$$ Fwd: Available consultant's for your requirement.

2011-04-29 Thread Akshay Korgaonkar
-- Forwarded message --
From: Akshay Korgaonkar recruiter.aks...@gmail.com
Date: Fri, Apr 29, 2011 at 11:55 PM
Subject: Fwd: Available consultant's for your requirement.
To: Akshay Korgaonkar recruiter.aks...@gmail.com



 HI,



Mentioned below are the list of candidates available for your requirement.
Kindly let me know if you have any requirement for them.

*Name*

*Position*

*Yrs of Exp*

*Skills*

*Availability*

*Preferred location*



Mukesh Jaiswal

Sr. Software Engineer / Consultant

11 yrs

Java, J2EE (EJB, JSP, RMI, Servlets, JNDI, JDBC, JMS), Struts 1.1,
hibernate, Java2, XML (DTDs, SAX / DOM Parser, Schemas), HTML, IBM MQ
Series, JavaScript in Windows (XP/2000/NT), Unix (Solaris, Linux).

Immediately

Bay Area, CA



Sreerama Moorthi

Java/J2ee Developer

6 yrs

OOA,OOD, Jakarta Struts Framework, JavaServer Faces, Spring Framework,
Spring MVC, Hibernate, IBM WebSphere, Oracle Weblogic, Apache HTTP

April

Anywhere in US



Sheetal Zatakia

Data Tester

12 yrs

ASP, .Net, HTML, XML, MS-Office Suite, Java, Oracle PL/SQL, Toad, Edit Plus,
Quick Test Pro, Quality Center

Immediately

L.A



Prashanth Dandamundi

QA / Test Lead

10+ yrs

ad-hoc product testing, reporting bugs and reporting tester status, writing
test scripts, test automation using diverse testing tools like HP
LoadRunner, HP QuickTest Professional (QTP) 11.0/10.0/9.x, HP Quality Center
(formerly Test Director 9/8/7.6), WinRunner. C, C# , Java, C++, ASP, Visual
Basic,  SQL, PL/SQL, JavaScript, VBScript, HTML, CSS, Rational Clearcase,
TFS, VSS etc. SQL Server 2005/2000/7.0/6.5, Oracle 10g/9i/8i, Sybase, DB2,
MS Access, MySQL, Windows 7, Vista, XP, Win 2003, NT, Win 2k Server, Unix,
Linux, DOS,

Immediately

Anywhere in US



Srinath Kamatam

ETL / Informatica Developer

7+ yrs

Power Center 8.6/8.1/7.1/6.2/5.1, INFORMATICA Power Mart 5.1,  Mapping
Designer, Server Manager and Repository Manager, Power Connect.

CrystalReports10.0, Cognos 8.1/7 (Impromptu), Business Objects 3.1 XIR2*/*
6.5.

Oracle 10g/9i/8i, SQL Server 2005/2000, DB2 UDB7.2, COBOL, SQL Loader, MS
Access 97/2000

UNIX shell scripts, SQL, PL/SQL, Perl, C/C++,

Dimensional modeling, Star schema, Snowflake schema, Kimball methodology,
code pages, DBCS

UNIX (IBM-AIX), Windows 2003/2000/98/95

Immediately

Anywhere US



Vishal Kangala

Sr. Java / UI Developer

10 yrs

Java/J2EE, Servlet, JSP, JavaBeans, Hibernate, Struts, JSF, Spring, Oracle,
JavaScript, IBM - Web Sphere, XML, XSL, XSLT, HTML, JQuery, HttpUnit, *Java
PageFlows, OOPS***



Immediately

Anywhere in NC, GA, VA, FL, PA







Thanks  Regard’s

* *

*Akshay Korgaonkar*

Wisdom InfoTech

Direct: 650-488-7828

*akshay.korgaon...@wisdominfotech.us*

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