Re: $$Excel-Macros$$ Excel Macro Help

On Tue, 12/19/17, 'Julienne Schindler' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Excel Macro Help To: excel-macros@googlegroups.com Date: Tuesday, December 19, 201

Re: $$Excel-Macros$$ Excel Macro Help

On Mon, 12/18/17, V wrote: Subject: Re: $$Excel-Macros$$ Excel Macro Help To: "MS EXCEL AND VBA MACROS" Date: Monday, December 18, 2017, 7:56 PM Hi, do you know how can I get using validations in Google Drive that change the colo

Re: $$Excel-Macros$$ Excel Macro Help

Hi, do you know how can I get using validations in Google Drive that change the color by codes. El miércoles, 11 de octubre de 2017, 11:40:37 (UTC-5), GENIUS escribió: > > look at the attachment, I can do only this. > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s

Re: $$Excel-Macros$$ Excel Macro Help

look at the attachment, I can do only this. -- 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 titl

Re: $$Excel-Macros$$ Excel Macro Help

Dear Paul, Thank you for your help. I have attached both files in the mail. In the master file I’ve highlighted some columns, if I update any value in the master file automatically it’s need to update in the another attached excel.. Thank you in advance. On Mon, 09 Oct 2017 at 14:41, Paul Schre

Re: $$Excel-Macros$$ Excel Macro Help

sure.fairly easily done.Please provide sample files.  Paul- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley --

Re: $$Excel-Macros$$ Excel Macro to copy data from Word

Hi Experts, Can please anyone help me, i really needing for some help here. On Sat, Jul 8, 2017 at 2:19 PM, Secret Shot wrote: > Can anyone help me out here > > On Fri, Jul 7, 2017 at 11:12 PM, Secret Shot wrote: > >> Hi Folks, >> >> I really need your help, in a case i am working. >> >> I am g

Re: $$Excel-Macros$$ Excel Macro to copy data from Word

Can anyone help me out here On Fri, Jul 7, 2017 at 11:12 PM, Secret Shot wrote: > Hi Folks, > > I really need your help, in a case i am working. > > I am getting data in a word file, and i need a macro which can open that > word file using "Getfilename" option, then copy all data from that file

Re: $$Excel-Macros$$ $$Excel-Macro$$ Import Data from PDF to Excel $$

++Adding Excel File On Sat, Jun 18, 2016 at 10:44 AM, Deepu Dubey wrote: > > > Hi Guys, > > I have a pdf file which need to be update on daily basis in an excel > file(Attached). > > I have to update only one thing from pdf file. > 1. Occ% column > > Can we get an macro to complete the same. > >

Re: $$Excel-Macros$$ excel Macro

like this On Sat, Apr 18, 2015 at 3:32 PM, B.N.Chethan Kumar < chetankumar1...@gmail.com> wrote: > Hi > > Please help me with macro code. I am trying to send file to each > individual. > > I need to filter and send the file to each individual. Current i have > macro it work on person. > > > > --

Re: $$Excel-Macros$$ Excel Macro to send email.. on specific dates of the month

Hi Andy Is it solved? On Wed, Mar 4, 2015 at 2:02 AM, AndyB wrote: > Hi everyone, > > Hope you're well. Looking for some help with an email macro. > > So I have an excel sheet (similar copy attached). > > Once run, the macro should read from (the first sheet) Data - Column I to > understand wha

Re: $$Excel-Macros$$ Excel Macro to Protect Sheet - password application not working

Excellent, thank you sir!! -- 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 H

Re: $$Excel-Macros$$ Excel Macro to Protect Sheet - password application not working

The problem is that you cannot protect a protected sheet. So once you use: ActiveSheet.protect DrawingObjects:=True, Contents:=True, Scenarios:=True then the line: Activesheet.protect Password:="deck" does NOTHING, because the sheet is already protected! you need to combine the two lines: A

Re: $$Excel-Macros$$ Excel macro from 2003 no longer works in Excel 2010

Paul, that was the fix, thank you very much for looking into this! Scott On Thursday, May 15, 2014 4:44:24 AM UTC-7, Paul Schreiner wrote: > For: > Workbooks("ESS CentreVu Stats Half").Worksheets("Mel").Range("b3").Value > > Is the workbook "ESS CentreVu Stats Half" open? > > I tested cod

Re: $$Excel-Macros$$ Excel macro from 2003 no longer works in Excel 2010

For:  Workbooks("ESS CentreVu Stats Half").Worksheets("Mel").Range("b3").Value   Is the workbook "ESS CentreVu Stats Half" open?   I tested code with my workbook. It seems that the file extension must be included.   In my case: Workbooks("Ora_RMS_Flags_Master.xlsb").Sheets("Ora_PN").Range("B3").Va

Re: $$Excel-Macros$$ Excel macro from 2003 no longer works in Excel 2010

Hi What error you are getting, can you send screenshot?? Cheers!! On Thu, May 15, 2014 at 5:33 AM, Sabosis wrote: > Hello- > > I am getting an error message on a certain line in my module that always > worked before switching to Office 2010. The line checks for a zero value in > a cell and wi

Re: $$Excel-Macros$$ Excel Macro to print, slecting range, printer and orientation etc

What Error are you getting? Can you share your file in which you use your recorded macro. On Sun, Oct 27, 2013 at 9:48 AM, ashish koul wrote: > try this way > http://mariaevert.dk/vba/?p=6 > > > > > On Sun, Oct 27, 2013 at 8:26 AM, Howard Rambin wrote: > >> I am new to macros in Excel (wiz at l

Re: $$Excel-Macros$$ Excel Macro to print, slecting range, printer and orientation etc

try this way http://mariaevert.dk/vba/?p=6 On Sun, Oct 27, 2013 at 8:26 AM, Howard Rambin wrote: > I am new to macros in Excel (wiz at lotus keyboard macros). > > I don't have not problem recording a simple print macro with just a range > selection, but when I go to select a printer, fit to pa

Re: $$Excel-Macros$$ excel macro help on regular basis required- on weekly payment/hourly basis

As you can imagine, it's not easy to set up such a relationship that pays on a weekly basis. Instead of paying weekly, why don't you hire a developer on project basis only as and when you need it? You could use http://www.excelfox.com/forum/f21/ to post queries that you are willing to pay for. On

Re: $$Excel-Macros$$ Excel macro help please

can you share the sample file On Mon, Dec 17, 2012 at 9:57 PM, sw1085 wrote: > Hi all, > > I've been searching for hours looking for a generic macro to help with the > following problem. > > If cell value in column J of worksheet "Sheet1" = "Apple" or "Pear" then > copy that cell plus the previ

Re: $$Excel-Macros$$ Excel Macro

I'm sorry to say that I've never heard of an application that can do as you ask. I would think it would be very difficult to interpret the macros. yes, the macro can record that you selected a cell. But it unless you've named the range that you're selecting, the macro doesn't know what the cell RE

Re: $$Excel-Macros$$ $$excel-macro-vba for sumif function-type mismatch error-reg

” - John Wesley - From: Paul Schreiner To: excel-macros@googlegroups.com Sent: Fri, November 2, 2012 12:53:16 PM Subject: Re: $$Excel-Macros$$ $$excel-macro-vba for sumif function-type mismatch error-reg The problem is that Cells D263 and D355 have a space in them. When you try to issue  k

Re: $$Excel-Macros$$ $$excel-macro-vba for sumif function-type mismatch error-reg

The problem is that Cells D263 and D355 have a space in them. When you try to issue  k = k + " ", you get a "Type Mismatch" because you cannot add a space to an integer   Paul - “Do all the good you can, By all the means you can, In all the ways you can, In a

Re: $$Excel-Macros$$ Excel macro to add VBA password

;" > Exit Sub > ElseIf Right(Password, 2) = "^^" Or Right(Password, 2) = "++" Then > Password = "" > Exit Sub > Else > SendKeys Password & "~~" & "{ESC}" > Application.VBE.CommandBars(1).FindControl(ID:=2578, > recu

Re: $$Excel-Macros$$ Excel macro to add VBA password

f vbProj.Protection = 1 Then SendKeys "%{F11}", True End If 'Reset Password Password = "" Application.ScreenUpdating = True Set vbProj = Nothing Exit Sub ErrorHandler: MsgBox Err.Description, 64 End Sub Don Guillett Microsoft Excel Developer SalesAid Software dguille...

Re: $$Excel-Macros$$ Excel macro to add VBA password

Gtalk] > > > -Original Message- > From: excel-...@googlegroups.com [mailto: > excel-...@googlegroups.com ] > On Behalf Of Kiran Kancharla > Sent: 06 September 2012 7:37 > To: excel-...@googlegroups.com > Subject: Re: $$Excel-Macros$$ Excel macro to add VBA

RE: $$Excel-Macros$$ Excel macro to add VBA password

September 2012 7:37 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Excel macro to add VBA password 4. vba protecion password On 9/6/12, Rajan_Verma wrote: > Where you want to apply Password. > > 1) File Open ? > 2) Worksheet Password ? > 3) Workbook Password ? > 4) VB

Re: $$Excel-Macros$$ Excel macro to add VBA password

Original Message- > From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] > On Behalf Of Kiran Kancharla > Sent: 06 September 2012 12:08 > To: excel-macros@googlegroups.com > Subject: Re: $$Excel-Macros$$ Excel macro to add VBA password > > Hi, > >

RE: $$Excel-Macros$$ Excel macro to add VBA password

Kancharla Sent: 06 September 2012 12:08 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Excel macro to add VBA password Hi, thanks a lot your quick responce.. thanks,u kiran On 9/6/12, NOORAIN ANSARI wrote: > Kiran, > > Before run macro, Pls check on Tools-Reference-

Re: $$Excel-Macros$$ Excel macro to add VBA password

hi noorain, yes i want to protect VBA Thanks, kiran On 9/6/12, NOORAIN ANSARI wrote: > Means, You want to protect VBA Coding instead of Opening File. > Kindly confirm. > > On Thu, Sep 6, 2012 at 6:32 PM, Kiran Kancharla > wrote: > >> Hi, >> >> with the above macro I am able to add pasword to o

Re: $$Excel-Macros$$ Excel macro to add VBA password

Hi, with the above macro I am able to add pasword to open the file. In my case i need a maco to add pssword for VBA, not for opening the file. plase help... On 9/6/12, SAGAR KASANGOTTUWAR wrote: > *Thanks a lot Noorain Bhai* > > ** > Have you any programme for protecting the same files in that

Re: $$Excel-Macros$$ Excel macro to add VBA password

*Thanks a lot Noorain Bhai* ** Have you any programme for protecting the same files in that folder...? Thanks & Regards, SAGAR On Thu, Sep 6, 2012 at 2:41 PM, NOORAIN ANSARI wrote: > Dear Sagar, > > Please use it. > > Change Folder path as per your need. > > Sub Protect_filesofFolder() > > D

Re: $$Excel-Macros$$ Excel macro to add VBA password

Dear Sagar, Please use it. Change Folder path as per your need. Sub Protect_filesofFolder() Dim MyFile As File Dim MyFolder As Folder Dim fso As Scripting.FileSystemObject Set fso = New Scripting.FileSystemObject Set MyFolder = fso.GetFolder("D:\VBA_Class\Extra\") For Each MyFile In MyF

Re: $$Excel-Macros$$ Excel macro to add VBA password

Wht error is showing, Please send screenshot. On Thu, Sep 6, 2012 at 1:49 PM, SAGAR KASANGOTTUWAR < sagarkasangottu...@gmail.com> wrote: > Dear Noorain, > > I have the same but it is not working. > > Thanks & Regards, > > KSAGAR > > > On Thu, Sep 6, 2012 at 1:33 PM, NOORAIN ANSARI > wrote: > >>

Re: $$Excel-Macros$$ Excel macro to add VBA password

Dear Noorain, I have the same but it is not working. Thanks & Regards, KSAGAR On Thu, Sep 6, 2012 at 1:33 PM, NOORAIN ANSARI wrote: > Dear Sagar, > > First of all you have add library in VBE Area > > Step:- Tools-Reference-Microsoft Scrinpting Runtime. > > Brother check once again, if does',t

Re: $$Excel-Macros$$ Excel macro to add VBA password

Dear Sagar, First of all you have add library in VBE Area Step:- Tools-Reference-Microsoft Scrinpting Runtime. Brother check once again, if does',t work revert me. On Thu, Sep 6, 2012 at 1:22 PM, SAGAR KASANGOTTUWAR < sagarkasangottu...@gmail.com> wrote: > Dear Noorain, > > I am not able to ru

Re: $$Excel-Macros$$ Excel macro to add VBA password

Dear Noorain, I am not able to run the programme and showing compile error (Method or data not found) after running. Thanks & Regards, KSAGAR On Thu, Sep 6, 2012 at 12:07 PM, Kiran Kancharla wrote: > Hi, > > thanks a lot your quick responce.. > > thanks, > kiran > > On 9/6/12, NOORAIN ANSARI

Re: $$Excel-Macros$$ Excel macro to add VBA password

Hi, thanks a lot your quick responce.. thanks, kiran On 9/6/12, NOORAIN ANSARI wrote: > Kiran, > > Before run macro, Pls check on Tools-Reference-Microsoft Scripting Runtime > under VBE editor. > > On Thu, Sep 6, 2012 at 11:03 AM, NOORAIN ANSARI > wrote: > >> Dear Kiran, >> >> Please try it.. >

Re: $$Excel-Macros$$ Excel macro to add VBA password

Kiran, Before run macro, Pls check on Tools-Reference-Microsoft Scripting Runtime under VBE editor. On Thu, Sep 6, 2012 at 11:03 AM, NOORAIN ANSARI wrote: > Dear Kiran, > > Please try it.. > > > Sub ProtectFiles() > > Dim MyFile As File > > Dim MyFolder As Folder > > Dim fso As Scripting.File

Re: $$Excel-Macros$$ Excel macro to add VBA password

Dear Kiran, Please try it.. Sub ProtectFiles() Dim MyFile As File Dim MyFolder As Folder Dim fso As Scripting.FileSystemObject Set fso = New Scripting.FileSystemObject Set MyFolder = fso.GetFolder(YourFolderPath) For Each MyFile In MyFolder.Files MyFile.Password="abc" Next End Su

Re: $$Excel-Macros$$ Excel Macro

As long as ever you can.” - John Wesley - From: Darren Combellack To: "excel-macros@googlegroups.com" Sent: Wed, September 5, 2012 8:35:05 AM Subject: RE: $$Excel-Macros$$ Excel Macro Not to worry,   Sorted

RE: $$Excel-Macros$$ Excel Macro

18 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Excel Macro the Filename is a fully "delineated" name. That is to say, it is intended to be the full path and file name. If not path is specified, the default path is used. If fPath is defined, then you can use: Active

RE: $$Excel-Macros$$ Excel Macro

ElseIf PO = vbCancel Then Quit = True End If End Sub The two units I've highlighted in yellow are different options I've tried, but none have worked. Many thanks Darren Combellack From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Paul Schrein

Re: $$Excel-Macros$$ Excel Macro

ou can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley - From: combellack To: excel-macros@googlegroups.com Sent: Wed, September 5, 2012 4:27:10 AM Subject: Re: $$Excel-Ma

Re: $$Excel-Macros$$ Excel Macro

can.” - John Wesley > *------------- > > > -- > *From:* combellack > > *To:* excel-...@googlegroups.com > *Sent:* Tue, September 4, 2012 8:59:44 AM > *Subject:* Re: $$Excel-Macros$$ Excel Macro > > Hi Paul,

Re: $$Excel-Macros$$ Excel Macro

all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley - ____________ From: combellack To: excel-macros@googlegroups.com Sent: Tue, September 4

Re: $$Excel-Macros$$ Excel Macro

Sorry about my previous message. I didn't finish reading... What does the error message read? what is the value of Range("G4") and... wouldn't the line following elseif PO = vbCancel then Cancel = true ??   Paul - “Do all the good you can, By all the mean

Re: $$Excel-Macros$$ Excel Macro

Where is the debugger hilighting the error? I suspect that it's the quit=true line. I'm not sue what that does. I would have thought the syntax would be Application.Quit.   Paul - “Do all the good you can, By all the means you can, In all the ways you can, I

Re: $$Excel-Macros$$ $$excel-macro$$HOW TO EXTRACT DATA BETWEEN TWO DATES

Sir, This works fine.Thank u very much. Karunanithi R From: Jaysheel Bhasme To: excel-macros@googlegroups.com Sent: Wednesday, April 11, 2012 11:55 PM Subject: Re: $$Excel-Macros$$ $$excel-macro$$HOW TO EXTRACT DATA BETWEEN TWO DATES Hi, Please find the

Re: $$Excel-Macros$$ $$excel-macro$$HOW TO EXTRACT DATA BETWEEN TWO DATES

Sir,     This works fine.  I got what I expected. Thanks. Karunanithi R From: Rajan_Verma To: excel-macros@googlegroups.com Sent: Thursday, April 12, 2012 12:11 AM Subject: RE: $$Excel-Macros$$ $$excel-macro$$HOW TO EXTRACT DATA BETWEEN TWO DATES See the

RE: $$Excel-Macros$$ $$excel-macro$$HOW TO EXTRACT DATA BETWEEN TWO DATES

Bhasme Sent: Apr/Wed/2012 11:55 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ $$excel-macro$$HOW TO EXTRACT DATA BETWEEN TWO DATES Hi, Please find the attached sheet. Jaysheel. On Wed, Apr 11, 2012 at 11:48 PM, Rajan_Verma wrote: Please attached file R

Re: $$Excel-Macros$$ $$excel-macro$$HOW TO EXTRACT DATA BETWEEN TWO DATES

Hi, Please find the attached sheet. Jaysheel. On Wed, Apr 11, 2012 at 11:48 PM, Rajan_Verma wrote: > Please attached file > > ** ** > > Rajan. > > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *karunanithi ramaswamy > *Sent:* Apr

RE: $$Excel-Macros$$ $$excel-macro$$HOW TO EXTRACT DATA BETWEEN TWO DATES

Please attached file Rajan. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of karunanithi ramaswamy Sent: Apr/Wed/2012 11:17 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ $$excel-macro$$HOW TO EXTRACT DATA BETWEEN TWO DATES sir, I h

RE: $$Excel-Macros$$ Excel macro for IBM Mainframe 3270

thara...@wipro.com Sent: Monday, February 27, 2012 10:31 PM To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ Excel macro for IBM Mainframe 3270 Hi Asa, That’s a pretty cool explanaion from you. And as you said I am having Macro Editor option in my terminal emulation sof

RE: $$Excel-Macros$$ Excel macro for IBM Mainframe 3270

to:excel-macros@googlegroups.com] On Behalf Of hariharan.thara...@wipro.com Sent: Thursday, February 23, 2012 7:45 AM To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ Excel macro for IBM Mainframe 3270 Hi Experts, Could you please help on this?

RE: $$Excel-Macros$$ Excel macro for IBM Mainframe 3270

..@wipro.com Sent: Thursday, February 23, 2012 7:45 AM To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ Excel macro for IBM Mainframe 3270 Hi Experts, Could you please help on this? Am I clear in the requirement? Thanks, Hariharan Tharagan _ From: excel-macr

RE: $$Excel-Macros$$ Excel macro for IBM Mainframe 3270

Hi Experts, Could you please help on this? Am I clear in the requirement? Thanks, Hariharan Tharagan From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of hariharan.thara...@wipro.com Sent: Thursday, February 23, 2012

Re: $$Excel-Macros$$ Excel Macro to navigate IE

arting off point) Asa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Kiran Kancherla Sent: Wednesday, February 01, 2012 9:34 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Excel Macro to navigate IE Hi Asa, I am sorry. I can n

RE: $$Excel-Macros$$ Excel Macro to navigate IE

ps.com [mailto:excel-macros@googlegroups.com] On Behalf Of Kiran Kancherla Sent: Wednesday, February 01, 2012 9:34 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Excel Macro to navigate IE Hi Asa, I am sorry. I can not give you the URL as it has some confidential informa

Re: $$Excel-Macros$$ Excel Macro to navigate IE

2 21:27:42 To: Reply-To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ Excel Macro to navigate IE Kiran, Can you give an example of a web page and the links the macro would click on it? Asa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On B

RE: $$Excel-Macros$$ Excel Macro to navigate IE

: $$Excel-Macros$$ Excel Macro to navigate IE Hi Asa, I agree with you. Excel can extract Web query. In my current requirement i don't have a constant URL to download the data. Like www.Google.com -> Calender -> (My case URL is only one) These kind of URLS I have.

Re: $$Excel-Macros$$ Excel Macro to navigate IE

Hi Asa, I agree with you. Excel can extract Web query. In my current requirement i don't have a constant URL to download the data. Like www.Google.com -> Calender -> (My case URL is only one) These kind of URLS I have. The Macro need to open IE click on Specified links and copy the data to Ex

RE: $$Excel-Macros$$ Excel Macro to navigate IE

Hello Kiran, Have you considered the approach of using web queries? Excel can automatically retrieve data from URLs that contain tables or XML/RSS and put it in a worksheet. Excel can also automatically refresh the data from the web on a set schedule if desired. The feature works in all version

Re: $$Excel-Macros$$ Excel Macro to navigate IE

cros@googlegroups.com Subject: Re: $$Excel-Macros$$ Excel Macro to navigate IE You can start with this Public Sub directa() Const strURL_c As String = "http://www.xyz.com"; Const strUsr_c As String = "ABC" Const strPwd_c As String = "DEF" Dim objIE As SHDocVw

Re: $$Excel-Macros$$ Excel Macro to navigate IE

You can start with this Public Sub directa() Const strURL_c As String = "http://www.xyz.com"; Const strUsr_c As String = "ABC" Const strPwd_c As String = "DEF" Dim objIE As SHDocVw.InternetExplorer Dim ieDoc As MSHTML.HTMLDocument Dim tbxPwdFld As MSHTML.HTMLInputElement

Re: $$Excel-Macros$$ Excel macro to send mail with other than excel attachment

Subject and body will be simple e.g. Sub : Data for the month Jan-12 and Email Body : Dear Sir/Mam Kindly find the attached file On Tue, Jan 10, 2012 at 4:08 PM, Anish Shrivastava wrote: > Hi Priyanka, > > I have a written a macro which does similar task, but I just wanted to > check with you

Re: $$Excel-Macros$$ Excel macro to send mail with other than excel attachment

Dear Noorain I have already tried this Kindly suggest if there is some other way On Tue, Jan 10, 2012 at 5:14 PM, NOORAIN ANSARI wrote: > Hi Priyanka, > > Check below link, hope it will help to you. > http://msdn.microsoft.com/en-us/library/ee834871(v=office.11).aspx > > -- > Thanks & regards,

Re: $$Excel-Macros$$ Excel macro to send mail with other than excel attachment

Hi Priyanka, Check below link, hope it will help to you. http://msdn.microsoft.com/en-us/library/ee834871(v=office.11).aspx -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://noorain-ansari.blogspot.com/*

Re: $$Excel-Macros$$ Excel macro to send mail with other than excel attachment

Hi Priyanka, I have a written a macro which does similar task, but I just wanted to check with you about "Subject" and "Mail Body" of the email. What would be the Subject and what should be written in the mail?? If you can give me these 2, I will modify the macro and send it to you. Regards, Ani

RE: $$Excel-Macros$$ &&Excel Macro&& How to retrive selected values based on another worksheet

I think it's a blank file.. please send it again.. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of SWADHEEN JAIN Sent: 26 December 2011 12:56 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ &&Excel Macro&& How to re

Re: $$Excel-Macros$$ &&Excel Macro&& How to retrive selected values based on another worksheet

HI here is the attached file , I want to retrieve only those Ptid and other column from patient problem table who are assigned with cardiologist from physician assign table On Mon, Dec 26, 2011 at 12:56 PM, SWADHEEN JAIN wrote: > Find the demo file as attachment. > > > On Sat, Dec 24, 2011 at 6

Re: $$Excel-Macros$$ &&Excel Macro&& How to retrive selected values based on another worksheet

Find the demo file as attachment. On Sat, Dec 24, 2011 at 6:26 PM, dguillett1 wrote: > Send file with complete explanation and examples > > > > Don Guillett > SalesAid Software > dguille...@gmail.com > -Original Message- From: SwadheenJain > Sent: Saturday, December 24, 2011 2:24 AM > To

Re: $$Excel-Macros$$ &&Excel Macro&& How to retrive selected values based on another worksheet

Send file with complete explanation and examples Don Guillett SalesAid Software dguille...@gmail.com -Original Message- From: SwadheenJain Sent: Saturday, December 24, 2011 2:24 AM To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ &&Excel Macro&& How to retrive selected values ba

RE: $$Excel-Macros$$ $$ excel - macro $$ copy data from multiple row

Hi Ashish, Thanks for the help once again. It works perfectly. Thanks and Regards, Gargee Singh Date: Fri, 9 Dec 2011 22:47:50 +0530 Subject: Re: $$Excel-Macros$$ $$ excel - macro $$ copy data from multiple row From: koul.ash...@gmail.com To: excel-macros@googlegroups.com Sub tests

Re: $$Excel-Macros$$ $$ excel - macro $$ copy data from multiple row

ou select both the columns ie D and E in audit sheet and do a paste > special - transpose , that is what it should look like . > > > Thanks and Regards, > Gargee Singh > > > > -- > Date: Fri, 9 Dec 2011 22:21:01 +0530 > > Subject: Re:

RE: $$Excel-Macros$$ $$ excel - macro $$ copy data from multiple row

Hi Ashish, If you select both the columns ie D and E in audit sheet and do a paste special - transpose , that is what it should look like . Thanks and Regards, Gargee Singh Date: Fri, 9 Dec 2011 22:21:01 +0530 Subject: Re: $$Excel-Macros$$ $$ excel - macro $$ copy data from multiple

Re: $$Excel-Macros$$ $$ excel - macro $$ copy data from multiple row

and Regards, > Gargee Singh > > > > -- > Date: Fri, 9 Dec 2011 22:14:05 +0530 > Subject: Re: $$Excel-Macros$$ $$ excel - macro $$ copy data from multiple > row > From: koul.ash...@gmail.com > To: excel-macros@googlegroups.com > > > can you add some content to e11:

Re: $$Excel-Macros$$ $$ excel - macro $$ copy data from multiple row

can you add some content to e11: e 490 and show us how would u like to be pasted on the mtd sheet On Fri, Dec 9, 2011 at 9:52 PM, gargee singh wrote: > Hi all > > > I need yet another help. In the above attached workbook i need to copy > data from audit sheet and paste it into the mtd consoli

RE: $$Excel-Macros$$ $$ excel - macro $$

Hi Ashish Yes , that's what i had thought, seems a good idea. Thanks for the help once again.. Thanks and Regards, Gargee Singh Date: Thu, 8 Dec 2011 23:18:02 +0530 Subject: Re: $$Excel-Macros$$ $$ excel - macro $$ From: koul.ash...@gmail.com To: excel-macros@googlegroups.com in

Re: $$Excel-Macros$$ $$ excel - macro $$

r + 1, 1).Resize(slr, 7).Copy ds.Cells(dlr + 1, 1) End Sub Don Guillett SalesAid Software dguille...@gmail.com From: gargee singh Sent: Thursday, December 08, 2011 11:41 AM To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ $$ excel - macro $$ Hi Don Thanks for your time an

Re: $$Excel-Macros$$ $$ excel - macro $$

d me with > the code and it seemed to work fine. > > > > > Thanks and Regards, > Gargee Singh > > > > -- > From: dguille...@gmail.com > To: excel-macros@googlegroups.com > > Subject: Re: $$Excel-Macros$$ $$ excel - macro $$

RE: $$Excel-Macros$$ $$ excel - macro $$

Hi Don Thanks for your time and help , one fellow group member helped me with the code and it seemed to work fine. Thanks and Regards, Gargee Singh From: dguille...@gmail.com To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ $$ excel - macro $$ Date: Thu, 8 Dec 2011 11

RE: $$Excel-Macros$$ $$ excel - macro $$

argee Singh From: garge...@hotmail.com To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ $$ excel - macro $$ Date: Thu, 8 Dec 2011 22:58:21 +0530 Hi Ashish, Thanks for such quick reply and time. This is fantastic :) .Completely meets my requirements. Thanks and Regards, G

RE: $$Excel-Macros$$ $$ excel - macro $$

Hi Ashish, Thanks for such quick reply and time. This is fantastic :) .Completely meets my requirements. Thanks and Regards, Gargee Singh Date: Thu, 8 Dec 2011 22:51:54 +0530 Subject: Re: $$Excel-Macros$$ $$ excel - macro $$ From: koul.ash...@gmail.com To: excel-macros@googlegroups.com

Re: $$Excel-Macros$$ $$ excel - macro $$

on Guillett SalesAid Software dguille...@gmail.com From: gargee singh Sent: Thursday, December 08, 2011 11:00 AM To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ $$ excel - macro $$ Hi Ashish, Thanks for your reply.Please find the attached sheet.The source sheet is what the s

RE: $$Excel-Macros$$ $$ excel - macro $$

and source data will always be in ascending order. ie dates from 1-2-3 dec and so on. Thanks and Regards, Gargee Singh From: dguille...@gmail.com To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ $$ excel - macro $$ Date: Thu, 8 Dec 2011 11:09:11 -0600 It would be

Re: $$Excel-Macros$$ $$ excel - macro $$

It would be helpful to post your code and/or file (if allowed) Don Guillett SalesAid Software dguille...@gmail.com From: gargee singh Sent: Thursday, December 08, 2011 10:24 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ $$ excel - macro $$ Hi experts I urgently need help wi

RE: $$Excel-Macros$$ $$ excel - macro $$

the help. Thanks and Regards, Gargee Singh Date: Thu, 8 Dec 2011 22:16:52 +0530 Subject: Re: $$Excel-Macros$$ $$ excel - macro $$ From: koul.ash...@gmail.com To: excel-macros@googlegroups.com can you attach the sample file and send it to the group id excel-macros@googlegroups.com On Thu

Re: $$Excel-Macros$$ $$ excel - macro $$

can you attach the sample file and send it to the group id excel-macros@googlegroups.com On Thu, Dec 8, 2011 at 9:54 PM, gargee singh wrote: > Hi experts > > I urgently need help with a code. > Though I have tried a lot of options just couldn't get the accurate code. > > This is what i need to

RE: $$Excel-Macros$$ $$Excel-Macro$$ - Optimize Formula

Subject: RE: $$Excel-Macros$$ $$Excel-Macro$$ - Optimize Formula Date: Mon, 1 Aug 2011 12:50:31 +0800 Hi, Try this: =IF(A5<=$T$5,$S$5,IF(A5<=$T$6,$S$6,IF(A5<=$T$7,$S$7,IF(A5<=$T$8,$S$8,IF(A5<=$T$9,$S$9,IF(A5<=$T$10,$S$10,"")) The multiple IF statement

RE: $$Excel-Macros$$ $$Excel-Macro$$ - Optimize Formula

Hi, Try this: =IF(A5<=$T$5,$S$5,IF(A5<=$T$6,$S$6,IF(A5<=$T$7,$S$7,IF(A5<=$T$8,$S$8,IF(A5<=$T$9,$S$9,IF(A5<=$T$10,$S$10,"")) The multiple IF statement stops as soon as it finds a TRUE. So you don't need to use AND statements to create 'windows' The above asks: Is A5 greater or equal to T5?

Re: $$Excel-Macros$$ Excel Macro

Hi Paste below code in thisworkbook module Private Sub Workbook_Open() If MsgBox("Do u want to Disable macro?", vbYesNo, "Information") = vbYes Then ActiveWorkbook.Close savechanges:=True End If End Sub Thanks Mahesh On Thu, Jul 14, 2011 at 10:07 PM, karthikeyan < karthikeyansankar...@gmail.

RE: $$Excel-Macros$$ Excel Macro- source series for a chart from all sheets

Please attached Your Sample WOrksheet -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Kat Sent: Wednesday, June 08, 2011 6:49 PM To: MS EXCEL AND VBA MACROS Subject: Re: $$Excel-Macros$$ Excel Macro- source series for a chart

Re: $$Excel-Macros$$ Excel Macro- source series for a chart from all sheets

can you share you sample workbook of 2 or 3 sheets On Wed, Jun 8, 2011 at 6:48 PM, Kat wrote: > I'm sorry, I'm still not having any luck with this. I'm getting > runtime error 91, object variable or With block not set. > > Does this mean that when you select the sheets you deselect your > char

Re: $$Excel-Macros$$ Excel Macro- source series for a chart from all sheets

I'm sorry, I'm still not having any luck with this. I'm getting runtime error 91, object variable or With block not set. Does this mean that when you select the sheets you deselect your chart? How do I best write the code within the loop so that I do not get this error? On Jun 6, 3:22 pm, ashish

Re: $$Excel-Macros$$ Excel Macro- source series for a chart from all sheets

Sub test() For i = 1 To Sheets.Count Sheets(i).Select ' paste ur code here Next i End Sub On Mon, Jun 6, 2011 at 2:12 PM, Kat wrote: > Hi all, > > I have a large spreadsheet, ~200 sheets. For each of these, I wish to > plot a series where the x values are D3:D103 and the y values are > E3:

Re: $$Excel-Macros$$ Excel Macro Request!

Hi Try Sub fillUp() Dim lLastRow As Long Dim lCounter As Long Dim sThisCust As String lLastRow = Cells(Rows.Count, "B").End(xlUp).Row sThisCust = Cells(1, "B") For lCounter = 2 To lLastRow If Trim((Cells(lCounter, "B")) = "") Then Cells(lCounter, "B") = sThisCust Else sThisCust = Cells(lCounter, "

Re: $$Excel-Macros$$ Excel Macro Request!

try this http://www.contextures.com/xlDataEntry02.html Fill Blank Cells From Above http://www.contextures.com/Excel-Videos-Data-Entry.html#FillBlanks On Sun, May 15, 2011 at 11:34 AM, Prabhu wrote: > Hi friends, > > I need a macro for a selected column to fill previous cell > automatically whe

Re: $$Excel-Macros$$ excel macro to remove shadow from shapes

try this code it may help you. Sub removeshadow() Dim i As Integer Dim sh As Shape For i = 1 To Worksheets.Count Sheets(i).Activate For Each sh In ActiveSheet.Shapes sh.Shadow.Visible = msoFalse Next sh Next i End Sub On Fri, Oct 8, 2010 at 4:54 AM, Jude Barnes wrote: > Our company i

Re: $$Excel-Macros$$ Excel Macro - Need help using Find and Selecting a range

Hi Paul - Thank you for your reply. I have added in your suggestion, but unfortunately I am still having a bit of an issue. The find now activates the correct cell, and the offset moves the active cell one to the left, but it is only selecting that particular row to copy and paste into the other t

  1   2   >