$$Excel-Macros$$ Fwd:Job Process Developer

- Original message From:""HR Axis India Pvt Ltd.""< quali...@hraxisindia.com > Date: 9 Sep 11 18:01:48 Subject: A Leading MNC Captive BPO Company is looking for Process Developer (Billing & Collections - US Healthcare) for Hyderabad Location. To: The sender of this email is regist

Re: $$Excel-Macros$$ calculating age with months

Hi Sunny, What ..Result not. *Best Regards,* *Venkat * *Chennai* *My Linked in profile * * * * * On Fri, Sep 9, 2011 at 9:54 PM, XLS S wrote: > Great!!! But Result not. > > > On Fri, Sep 9, 2011 at

Re: $$Excel-Macros$$ Re: Report Generation

If crystal reports can be used for excel vba, which version is compatible ? On Sat, Sep 10, 2011 at 9:55 AM, Shankar Bheema wrote: > I am attaching excel which is having VBA code for Userform. Pls press > Alt+F11 after opening the excelsheet. > > I also attached a word document which contains th

Re: $$Excel-Macros$$ Moving Sheets

IF??? I understand just copy>paste values>copy . -Original Message- From: bom Sent: Friday, September 09, 2011 2:24 PM To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ Moving Sheets I would like to know whether its possible to move sheets from one workbook to another without t

$$Excel-Macros$$ Moving Sheets

I would like to know whether its possible to move sheets from one workbook to another without the formulas on the sheets moved being changed? For example I want to move two sheets from one workbook to another. One of those sheets populates info from the other sheet that is being moved with it. when

Re: $$Excel-Macros$$ Date from textbox reversed.

How is the date entered into the textbox? perhaps Excel isn't recognizing the value as an actual "date"... Try this:] if (isdate(frmApplications.TextBox1.Value)) then     ActiveCell.Value = Format(frmApplications.TextBox1.Value)) , "dd/mm/") end if   I'm suspecting that the value in the textb

Re: $$Excel-Macros$$ Date from textbox reversed.

Hi Try ActiveCell.Value = Format(FrmApplications.TextBox1.Value,"dd/mm/") Thanks Mahesh On Fri, Sep 9, 2011 at 10:26 PM, Brian wrote: > I am using a form to enter data and then from the textbox complete > data in an excel spreadsheet. This is my code >ActiveCell.Value = Date >

$$Excel-Macros$$ Date from textbox reversed.

I am using a form to enter data and then from the textbox complete data in an excel spreadsheet. This is my code ActiveCell.Value = Date ActiveCell.Offset(0, 1).Select ActiveCell.Value = FrmApplications.TextBox1.Value ActiveCell.Offset(0, 1).Select Activecell.Value = Date works pe

Re: $$Excel-Macros$$ Loop Practice in VBA

Venkat Ji... Google Baba Ki Jai http://msdn.microsoft.com/en-us/library/ezk76t25%28v=vs.71%29.aspx On Fri, Sep 9, 2011 at 10:47 AM, Venkat CV wrote: > Dear All, > > Find attached some Examples With Loops...in VBA it will useful > > *Best Regards,* > *Venkat * > *Chennai* > *M

Re: $$Excel-Macros$$ calculating age with months

Great!!! But Result not. On Fri, Sep 9, 2011 at 10:39 AM, Venkat CV wrote: > Hi Varun, > > See if Helps Attached... > > *Best Regards,* > *Venkat * > *Chennai* > *My Linked in profile > * > > > > On Thu, Sep 8, 2011 at

Re: $$Excel-Macros$$ vba help

If you do it that way, you're going to skip some rows: first loop: i = 1, selects 1 to 200   i = i + 200 = 201 second loop: INCREMENTS i i = 201, for loop increments to 202, selects 202 to 401   i = i + 200 = 402 loop increments 402 to 403,   selects 403-602 what you SHOULD use for the loop is:

Re: $$Excel-Macros$$ vba help

Sub breaksheet_data() For i = 1 To 2000 Sheets(1).Rows(i & ":" & i + 199).Copy Sheets.Add After:=Sheets(Sheets.Count) Cells(1, 1).Select ActiveSheet.Paste i = i + 200 Next End Sub On Fri, Sep 9, 2011 at 12:47 PM, naresh v wrote: > Hi Group, > >I have one excel sheet with 2000 records.

$$Excel-Macros$$ Re: How to recast a variant as an array in VBA

On 7 Sep., ShayneH wrote: > Is there a way to expose an array that is enclosed by a variant? > Basically I have one function that returns a variant type which needs > to be passed to another procedure that requires the parameter to be > typed as a byte array. > > eg: > Function UsuallyReturnsAnA

Re: $$Excel-Macros$$ Manipulating data in rows into Columns

Hi Andy change For k = 3 To 7 if u have more than 7 cols in ur data try the below code Sub tests() Dim i As Long j = 1 For i = 2 To Sheets(1).Range("a65356").End(xlUp).Row For k = 3 To 7 Sheets(2).Cells(j, 1).Value = Sheets(1).Cells(i, 1).Value Sheets(2).Cells(j, 2).Value = Sheets(1).Cells

Re: $$Excel-Macros$$Read column(s) and calculate currency on multiple target spreadsheets/worksheets

Hi Jose, Just go to your Gmail and Compose Mail and send it to * excel-macros@googlegroups.com * and it will Automatically Reach Group.. You can attach your file in Gmail itself.. On Fri, Sep 9, 2011 at 6:15 PM, Jose Costa wrote: > Hi Venkat, > > Thanks for your quick reply. > > I'm new to t

Re: $$Excel-Macros$$ Msg Box

In the vba help type in msgbox From: Mr Excellent Sent: Friday, September 09, 2011 6:13 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Msg Box Hi Group, I have a form which has a Close button and a Code assgined to it as below: Private Sub cmdClose_Click() MsgBox "Do you wan

Re: $$Excel-Macros$$Read column(s) and calculate currency on multiple target spreadsheets/worksheets

Hi Venkat, Thanks for your quick reply. I'm new to the group and couldn't find any option to attach files. Jose On Sep 9, 3:15 am, Venkat CV wrote: > *Hi,* > * > * > *Please attach some Data in Excel...* > * > * > *Best Regards,* > *Venkat * > *Chennai* > *My Linked in profile

Re: $$Excel-Macros$$ Msg Box

Dear Surya, use simple...for excel sheet.. ** *Private Sub cmdClose_Click() ActiveWorkbook.Close True* *End Sub* for userform.. *Private *Sub* CommandButton1_Click() If MsgBox("Do you want to Save the details", vbQuestion + vbOKCancel) = vbYes Then End If Unload Me End Sub* -- Thanks &

Re: $$Excel-Macros$$ Msg Box

You should use: Dim Result Result = MsgBox("Do you want to Save the Details",vbYesNoCancel) if (Result = vbYes) then Unload Me or you could use something like: select case Result     case vbYes         ' Enter code to process when option is to Save Details case vbNo     ' Enter code to

Re: $$Excel-Macros$$ Msg Box

Hi, Look Attached... *Best Regards,* *Venkat * *Chennai* *My Linked in profile * On Fri, Sep 9, 2011 at 4:43 PM, Mr Excellent wrote: > Hi Group, > > I have a form which has a Close button and a Code assgined to it as below: > > Private Sub cmd

$$Excel-Macros$$ Msg Box

Hi Group, I have a form which has a Close button and a Code assgined to it as below: Private Sub cmdClose_Click() MsgBox "Do you want to Save the details", vbYesNoCancel Unload Me End Sub But What i need is when i Click on "OK" button on the form should close or if i click on "No" the Form shoul

Re: $$Excel-Macros$$ Help required offset command

Thank you Daniel On Fri, Sep 9, 2011 at 2:56 PM, Daniel wrote: > Hi, > > ** ** > > See attached file. > > ** ** > > Regards. > > ** ** > > Daniel > > ** ** > > *De :* excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] > *De la part de* Kal xcel > *Envoyé :* ve

$$Excel-Macros$$ Fwd: Urgent Opening for SQL developer

Original message From:"Magna Infotech Pvt Ltd"< afr...@magna.in > Date: 9 Sep 11 14:07:27 Subject: Urgent Opening for SQL developer The sender of this email is registered with Naukri.com as Magna Infotech Pvt Ltd Dear Candidate,This is in reference to your profile in my database

Re: $$Excel-Macros$$ Crystal Reports for vba excel

hello venkat ji, the links which you have provided are seems very useful for me. but the forums are closed registrations and replies for queries. If possible, is there any other forum which provide sample examples with crystal reports with VBA Excel On Fri, Sep 9, 2011 at 10:54 AM, Venkat CV w

$$Excel-Macros$$ Change excel file logo separate for single files

Hi! I keep four excel workbooks in a folder and need to change logo of each file separately to distinguish them by logo. The logo change in Excel applies to all files. I need to have each file a different logo. Please guide how to pick up logos? Mahess -- --

Re: $$Excel-Macros$$ Code to control the database not to accept repeated number

thank you all very muchh On Fri, Sep 9, 2011 at 10:51 AM, Venkat CV wrote: > Hi Bheema, > > See below image and Try Data Validation and use custom and formula as * > =COUNTIF(C:C,C1)=1* > > [image: image.png] > *Best Regards,* > *Venkat * > *Chennai* > *My Linked in profile

$$Excel-Macros$$ Manipulating data in rows into Columns

Hi All, I have a spreadsheet that contains some test results that go across multiple columns on each row. Now these results are unique to a serial number, however can be tested on multiple dates i.e. after software updates etc. Therefore need to be on seperate rows. See example below: Ser No

$$Excel-Macros$$ vba help

Hi Group, I have one excel sheet with 2000 records. i want to split those records. those 2000 records should copy into moresheets for ex: main sheet -- 2000 records; sheet1 -- 1 to 200 sheet2 -- 201 to 400 sheet3 -- 401 to 600 . . . sheet10 -- 1801 to 2000 thanks in advance regards, n

Re: $$Excel-Macros$$ Re: Report Generation

Hi , See Below links if Helps... http://databases.about.com/od/tutorials/l/aareports1.htm http://office.microsoft.com/en-us/access-help/create-a-simple-report-HA001230739.aspx http://www.databasedev.co.uk/reports.html *Best Regards,* *Venkat * *Chennai* *My Linked in profile

Re: $$Excel-Macros$$Read column(s) and calculate currency on multiple target spreadsheets/worksheets

*Hi,* * * *Please attach some Data in Excel...* * * *Best Regards,* *Venkat * *Chennai* *My Linked in profile * On Fri, Sep 9, 2011 at 2:04 AM, Jose Costa wrote: > Hi all, > > I'm trying to build an Excel solution that would do the following: >