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

$$Excel-Macros$$ Excel Macro Help

I have a master excel file (ABC.xls) which has n number of rows and columns. And also i have another excel file (DEF.xls) which has limited number of same data from the master excel file (ABC.xls). I need a macro code for if i update some values in the master excel file (ABC.xls), automatica

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

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

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 and paste into a excel sheet (Paste special). I am trying below code but it is not working.

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

$$Excel-Macros$$ excel Macro

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

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

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

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 what date is today. If the date on column I matches with the system date, it will se

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

com >Sent: Wednesday, January 21, 2015 12:32 PM >Subject: $$Excel-Macros$$ Excel Macro to Protect Sheet - password application >not working > > > >Hello, > >i'm having trouble with a macro that i've sent up to: >1) unprotect a sheet with a password >2)

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

Hello, i'm having trouble with a macro that i've sent up to: 1) unprotect a sheet with a password 2) do some filtering and set a print area 3) apply the password again Looks like steps 1 and 2 are working fine but step 3 isn't working. After running the marco I can click the "Unprotect Sheet" b

$$Excel-Macros$$ Excel Macro to add rotated picture in Cell Comments

Dear Experts, I got a Excel macro to paste pictures in Excel cell comments. It is working fine. Now, I need a change in it. Pictures should be rotated 270 degree & then pasted in cell comments. Can anybody help, please? Thanks in advance. code is mentioned below:- Sub InsertPictures() Dim cll

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

*“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* > - > >*From:* Sabosis > > *To:* excel-.

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

“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 - From: Sabosis >To: excel-macros@googl

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

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

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 will quit excel if the value is zero. If not zero then the code continues. I am getting an error on this line though as we are

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

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

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 page etc, I get errors. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(

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

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

I neeed excel macro help on a regualr basis...can pay in dollars every week. if you have time this week, can you pleas reply to me? -- 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

$$Excel-Macros$$ Excel Macro to import specific data from PDF to Excel

Hello, I hope you're having a good day. I would like some help in my project involving imprting some data from pdf into excel spredsheet. It involves creating a button in excel to load the pdf file and copy some pre-selected data into excel. Can anybody help me in how I should approach the proje

$$Excel-Macros$$ Excel Macro

Hi c Michael Cho -- 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

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

$$Excel-Macros$$ Excel macro help please

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 previous 4 cells to a new worksheet called "Sheet2". Hope someone can help. Best regards sw10

Re: $$Excel-Macros$$ Excel Macro

ans 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 - From: AR To: excel-macros@googlegroups.com Sent: Mon, Decem

$$Excel-Macros$$ Excel Macro

Hi Frnds, Can anybody tell me , whether is it possible to document a process by recording the process using macro. For example .. i am having 2 excel files .. i am copying data from one to another and using the necessary formulas i am preparing the report say P&L.. i need to document these steps

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

Fri, November 2, 2012 12:19:34 PM Subject: $$Excel-Macros$$ $$excel-macro-vba for sumif function-type mismatch error-reg Dear Experts,   I wrote a vba for replacing the sumif function in my own way.  It works for few datas(sheet2) it works fine. the vba is as follows: Sub sumb() Dim i, j

$$Excel-Macros$$ Excel Macro Reqd for Folder to Folder

Dear Export, I have one folder "x" witch has contain mail's, every mail contain an excel file, i want to copy all excel file from folder "x" to onther folder with different name.. Regard Manoj -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1

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

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

Hi, Need help to create a macro to add VBA password to all the excel files in a folder. I am using excel 2003. Request you help me on this. -- Thanks & Regards, Kiran -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BAN

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

groups.com Sent: Tue, September 4, 2012 8:17:40 AM Subject: $$Excel-Macros$$ Excel Macro I was hope you could help!   I wrote a VB Code for Excel (mainly copied for Google!) to help us when raising purchase orders.   I wrote it on my mac within Office 2010, and I ran perfect.   Unfortunately w

Re: $$Excel-Macros$$ Excel Macro

AM Subject: $$Excel-Macros$$ Excel Macro I was hope you could help!   I wrote a VB Code for Excel (mainly copied for Google!) to help us when raising purchase orders.   I wrote it on my mac within Office 2010, and I ran perfect.   Unfortunately when I try on Windows (also Office 2010) I get a d

$$Excel-Macros$$ Excel Macro

I was hope you could help! I wrote a VB Code for Excel (mainly copied for Google!) to help us when raising purchase orders. I wrote it on my mac within Office 2010, and I ran perfect. Unfortunately when I try on Windows (also Office 2010) I get a debug error? Private Sub

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

*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 have list of staff with dates of retirement. *I want to e

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

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

sir,   I have list of staff with dates of retirement. I want to extract the staff who retire between 5/1/2012 and 5/31/2012. I want the vba code to do this. thank u in advance. Karunanithi R -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor

$$Excel-Macros$$ Excel Macro Code Request for List files and Move specified directory

Dear all, Please find below is my request to create macro code: Step1: Browse Directory. Step2: List files in above selected directory. Step3: Create directory based on the file Step4: Move files based on its named directory. Please help us to get this process solution. Please let me know if y

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

t: RE: $$Excel-Macros$$ Excel macro for IBM Mainframe 3270 Hi Hariharan, Is there any special reason to do this from Excel? SendKeys is unreliable, and you have no way to verify the results using built-in VBA functionality. Usually: The best place to script would be on the server using

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

, 2012 7:00 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Excel macro for IBM Mainframe 3270 Hi Experts, I am a IBM Mainframe 3270, Reflection User (Terminal Emulation Front End)and I don't have access for Session Manager. I just need a macro to do some process autom

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

Hi Experts, I am a IBM Mainframe 3270, Reflection User (Terminal Emulation Front End)and I don't have access for Session Manager. I just need a macro to do some process automation. * Is it possible to interact with Mainframe without connectivity? * Will Send Keys work f

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

om Subject: RE: $$Excel-Macros$$ Excel Macro to navigate IE Hi Kiran, No problem. I wanted to investigate if their was any way to get web queries to work with your URLs. Notice that the links I gave describe how to work with parameters in some cases. Also you might be able to use Yahoo! Pipes or

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

ooglegroups.com] > On Behalf Of Kiran Kancherla > Sent: Wednesday, February 01, 2012 8:58 AM > To: excel-macros@googlegroups.com > Subject: $$Excel-Macros$$ Excel Macro to navigate IE > > ** ** > > ** ** > > Hi All, > > ** ** > >

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

@googlegroups.com] On Behalf Of Kiran Kancherla Sent: Wednesday, February 01, 2012 8:58 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Excel Macro to navigate IE Hi All, If any of have Macro ''click'' or ''navigate'' internet explorer... My r

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

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

Hi All, If any of have Macro ''click'' or ''navigate'' internet explorer... My requirement is to click 3 hyper links and copy the data to Excel I have tried googling it.. But no luck.. Sent on my BlackBerry® from Vodafone Thanks & Regards. Kiran -- FORUM RULES (986+ members already BANNE

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

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

Dear Team In an excel sheet have data in A column "Employee Name ", in B Column " email id of concern Employee" I h ave a folder of PDF files, PDF file name are same as Employee Name and there is a PDF for all employee I want to send concern Employee his own named PDF from that folder to the em

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

r 24, 2011 2:24 AM >> To: MS EXCEL AND VBA MACROS >> Subject: $$Excel-Macros$$ &&Excel Macro&& How to retrive selected values >> based on another worksheet >> >> >> HI .. >> >> I am having patient id of about 4000 patients and associated

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

, December 24, 2011 2:24 AM > To: MS EXCEL AND VBA MACROS > Subject: $$Excel-Macros$$ &&Excel Macro&& How to retrive selected values > based on another worksheet > > > HI .. > > I am having patient id of about 4000 patients and associated physician > in one s

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

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

HI .. I am having patient id of about 4000 patients and associated physician in one sheet and in another sheet contain patient problem detail. now i want to find out only those patient data from another sheet who has been chosen from previous sheet with assigned physician for eg, cardiologist. How

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

  1   2   >