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 Pa

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

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 Reg

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

$$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, ac

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

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

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 Th

$$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("VBScr

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

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

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

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

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

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