$$Excel-Macros$$ VBA website scrapping help

Hi All, I found the below sample code which works fine. I tried to mimic the code by using another website, but cannot even reach the input parameters. The website has two text boxes. Once you insert value to the first box, it will automatically return a result value to the second box ( no butt

$$Excel-Macros$$ VBA to modify connetion string to change username password - Excel (Data Model)

Hi, I need your help to modify the connection string for excel Data model connected to SQL native client (SQLNCLI11), i have multiple files using this source connection, but now i want to change the useraname and password for the same source connection by using VBA to modify in all the excel fil

$$Excel-Macros$$ VBA/MS Access Developer

* position**:* VBA/MS Access Developer *Location*: Salt Lake City, Utah *Duration*: 2+ years *LOCALS ONLY* *Job description*: Maintain, support, and implement mandatory enhancements to DAF’s existing VBA systems. The systems have VBA logic referencing relational databases (MS SqlServer v2

$$Excel-Macros$$ VBA developer

*Job Title :VBA developer with Microsoft excel.* *Job Location : NJ* *Type :Contact * *Qualifications* - Bachelor degree in Computer Science or related field, or equivalent experience - Demonstrated work experience and proficiency with the following database technologies: -

$$Excel-Macros$$ VBA Copy and Paste to Corresponding Name

Hello Gurus, kindly need assistance with vba solution in the sheet attached, i want to copy the figures from column M with heading Current NAV for Valuation Date 31-may-16 to column E with heading Last Valuation for Valuation date 30-jun-16 and the figures must correspond to the particular name

$$Excel-Macros$$ VBA Macro - Do While Loop

Hi Friends, Feels like worth sharing the knowledge. Do while loop in Excel VBA. https://youtu.be/JIpu6vOe9Vo Thanks & Regards, Prabhu R -- 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://ww

Re: $$Excel-Macros$$ VBA Run time error 13 type mismatch in Excel 2010 with Datavalidation & VBA

Maatangi, your file has a link to a file called Database-formats11.xlsb that I don't have, so I'm not sure if I can do much testing. However, as far as the locked/protected cells go:Record a macro in which you Protect the sheet (with a password) and making appropriate selections.then unprotect i

Re: $$Excel-Macros$$ VBA Run time error 13 type mismatch in Excel 2010 with Datavalidation & VBA

On Mon, 3/6/17, kenyattafreed via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ VBA Run time error 13 type mismatch in Excel 2010 with Datavalidation & VBA To: excel-macros@googlegroups.com Date: Monday, March 6, 2017, 11:2

Re: $$Excel-Macros$$ VBA Run time error 13 type mismatch in Excel 2010 with Datavalidation & VBA

On Mon, 3/6/17, cronincarmelita via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ VBA Run time error 13 type mismatch in Excel 2010 with Datavalidation & VBA To: excel-macros@googlegroups.com Date: Monday, March 6, 2017, 10:2

Re: $$Excel-Macros$$ VBA Run time error 13 type mismatch in Excel 2010 with Datavalidation & VBA

On Mon, 3/6/17, Maatangi M. Karthik wrote: Subject: Re: $$Excel-Macros$$ VBA Run time error 13 type mismatch in Excel 2010 with Datavalidation & VBA To: "MS EXCEL AND VBA MACROS" Cc: schreiner_p...@att.net Date: Monday, March 6,

Re: $$Excel-Macros$$ VBA Run time error 13 type mismatch in Excel 2010 with Datavalidation & VBA

On Fri, 3/3/17, margaretatolliver via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ VBA Run time error 13 type mismatch in Excel 2010 with Datavalidation & VBA To: excel-macros@googlegroups.com Date: Friday, March 3, 2017, 3:4

Re: $$Excel-Macros$$ VBA Run time error 13 type mismatch in Excel 2010 with Datavalidation & VBA

On Fri, 3/3/17, keisha.fry via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ VBA Run time error 13 type mismatch in Excel 2010 with Datavalidation & VBA To: excel-macros@googlegroups.com Date: Friday, March 3, 2017, 1:5

Re: $$Excel-Macros$$ VBA Run time error 13 type mismatch in Excel 2010 with Datavalidation & VBA

First of all (last of all?):You can lock some cells and leave others available for editing:- select all cells- right click on the selection - Select "Format Cells"- select "Protection" tab- Make sure "Locked" is checked.- click "OK" When the sheet is protected, all cells with this "locked" attrib

Re: $$Excel-Macros$$ VBA Run time error 13 type mismatch in Excel 2010 with Datavalidation & VBA

On Fri, 3/3/17, Maatangi M. Karthik wrote: Subject: Re: $$Excel-Macros$$ VBA Run time error 13 type mismatch in Excel 2010 with Datavalidation & VBA To: "MS EXCEL AND VBA MACROS" Cc: schreiner_p...@att.net Date: Friday, March 3,

Re: $$Excel-Macros$$ VBA Run time error 13 type mismatch in Excel 2010 with Datavalidation & VBA

Hi there are a few more things I want from the excel. 1. There are some formulae in my excel sheet, I would like to convert them to the backend so that the users cannot change them at any cost 2. There are some fields that affect these formulae in succession, that is, two or three cell values t

Re: $$Excel-Macros$$ VBA Run time error 13 type mismatch in Excel 2010 with Datavalidation & VBA

Thanks a lot for your response, Paul. However, my issue got resolved with the help of another forum and was resolved with the help of Combination of "On error resume next " and "Application.EnableEvents=False / true" statements. On Friday, 3 March 2017 01:02:22 UTC+5:30, Paul Schreiner wrote:

Re: $$Excel-Macros$$ VBA Run time error 13 type mismatch in Excel 2010 with Datavalidation & VBA

On Fri, 3/3/17, hopkinsruben865 via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ VBA Run time error 13 type mismatch in Excel 2010 with Datavalidation & VBA To: excel-macros@googlegroups.com Date: Friday, March 3, 2017, 4:4

Re: $$Excel-Macros$$ VBA Run time error 13 type mismatch in Excel 2010 with Datavalidation & VBA

On Fri, 3/3/17, kenyattafreed via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ VBA Run time error 13 type mismatch in Excel 2010 with Datavalidation & VBA To: excel-macros@googlegroups.com Date: Friday, March 3, 2017, 4:0

Re: $$Excel-Macros$$ VBA Run time error 13 type mismatch in Excel 2010 with Datavalidation & VBA

On Fri, 3/3/17, mintaspriggs via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ VBA Run time error 13 type mismatch in Excel 2010 with Datavalidation & VBA To: excel-macros@googlegroups.com Date: Friday, March 3, 2017, 3:5

Re: $$Excel-Macros$$ VBA Run time error 13 type mismatch in Excel 2010 with Datavalidation & VBA

On Thu, 3/2/17, margaretatolliver via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ VBA Run time error 13 type mismatch in Excel 2010 with Datavalidation & VBA To: excel-macros@googlegroups.com Date: Thursday, March 2, 2017, 1

Re: $$Excel-Macros$$ VBA Run time error 13 type mismatch in Excel 2010 with Datavalidation & VBA

On Thu, 3/2/17, Paul Schreiner wrote: Subject: Re: $$Excel-Macros$$ VBA Run time error 13 type mismatch in Excel 2010 with Datavalidation & VBA To: "excel-macros@googlegroups.com" Date: Thursday, March 2, 2017, 9:32 PM I dele

Re: $$Excel-Macros$$ VBA Run time error 13 type mismatch in Excel 2010 with Datavalidation & VBA

On Thu, 3/2/17, Paul Schreiner wrote: Subject: Re: $$Excel-Macros$$ VBA Run time error 13 type mismatch in Excel 2010 with Datavalidation & VBA To: "excel-macros@googlegroups.com" Date: Thursday, March 2, 2017, 9:32 PM I dele

Re: $$Excel-Macros$$ VBA Run time error 13 type mismatch in Excel 2010 with Datavalidation & VBA

I deleted a row and received the "Type Mismatch" error.If you select "Debug", you'll see that the offending line of code is:   If Target.Value = "OrderStatus" ThenPutting a  "watch" on the Target variable, you'll see that it isn't a single cell, but an array of cells! When you change multiple ce

Re: $$Excel-Macros$$ VBA: Compile error: User-defined type not defined

I took a quick look myself.There doesn't seem to be a "standard" data type called "Table". Where you've used it before, do you have other macros (or class modules) that define this data type? In the other application (that works) try right-clicking on the word "Table" in: Dim myTable As Table an

$$Excel-Macros$$ VBA: Compile error: User-defined type not defined

Hi, I am trying to save images of chart and table of the same excel workbook and then send them automated email. All works except saving the image of the table. I am getting the following error message: *Compile error:User-defined type not defined Here is the VBA code below: *

Re: $$Excel-Macros$$ VBA Code for search any string (text) & filter data automatic

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

Re: $$Excel-Macros$$ VBA Code for search any string (text) & filter data automatic

Dear Paul Sir, Good Morning. Thank you so much for your code, for the effort and time dedicated.And your explanation is too good but bcos of less understanding VBA coding I cant get all information but any way i sort out my issue.Currently i Use Excel 2003 & future planning to work on excel 2007.

Re: $$Excel-Macros$$ VBA Code for search any string (text) & filter data automatic

 See answers below: On Friday, November 4, 2016 2:00 AM, amar takale wrote: Dear Paul Sir, This is fabulous work! I think this must be flashing on the front page! :D. And I am Extremely sorry for so late reply bcos of diwali vacation. I am VBA learner so only basic knowledge of VBA

Re: $$Excel-Macros$$ VBA Code for search any string (text) & filter data automatic

Dear Paul Sir, This is fabulous work! I think this must be flashing on the front page! :D. And I am Extremely sorry for so late reply bcos of diwali vacation. I am VBA learner so only basic knowledge of VBA coding. I have some Question here: 1) Can I use this code in excel 2007 after giving ch

Re: $$Excel-Macros$$ VBA Code for search any string (text) & filter data automatic

OK, here's something to look at. I'm not sure if you'll need help implementing it, but here's how it works: There are several "Named Ranges".For instance, your entire list is called "Data" in order to manage the Filters.The cell for "place" is called "SearchPlace" and the cell for strings is call

Re: $$Excel-Macros$$ VBA Code for search any string (text) & filter data automatic

Dear Hilary sir pls look into this matter. Also from Paul sir expect lot. On Mon, Oct 24, 2016 at 5:42 PM, amar takale wrote: > Dear Sir > > Thanks for reply.but my requirement not this way (And I am use excel > 2003). I want to search any string from specific cell (D2) then data filter > on th

Re: $$Excel-Macros$$ VBA Code for search any string (text) & filter data automatic

Dear Sir Thanks for reply.but my requirement not this way (And I am use excel 2003). I want to search any string from specific cell (D2) then data filter on that basis like wildcard criteria. My search criteria like hotmail,gmail,water,emirates,net,.com,.ae ,wave etc from D2 & then filter data

Re: $$Excel-Macros$$ VBA Code for search any string (text) & filter data automatic

See attached, HTH. Cheers On Mon, Oct 24, 2016 at 5:35 AM, amar takale wrote: > Dear Friends > any one help me on this issue > > On Fri, Oct 21, 2016 at 12:09 PM, amar takale > wrote: > >> >> -- >> 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)

Re: $$Excel-Macros$$ VBA Code for search any string (text) & filter data automatic

Dear Friends any one help me on this issue On Fri, Oct 21, 2016 at 12:09 PM, amar takale wrote: > > -- > 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

$$Excel-Macros$$ VBA help to auto collapse groups based on cell values

Hi, We are trying to create a toggle button to auto collapse/expand multiple groups dynamically. At the moment we have to name each group in the Names Manager and then manually have an if statement in VBA code where hard-code each groups name. However, we will have more than 100 groups so it mak

$$Excel-Macros$$ VBA - checking for success of a Global Replace

One of the first steps in my macro does a global replace, looking for "BLKY046**" and replace it with "LKAREA". I would like to use this Replace as a means to keep the macro from running again if it has already been run once. Basically, if the Replace can't find "BLKY046**" it means I already ran

Re: $$Excel-Macros$$ VBA MACRO NEEDED (SIMPLE??)

Hey Bil, You can do this thru formula only. Enclosed without macro solution, let us know if you still required macro. -- On Sun, Sep 18, 2016 at 8:42 AM, Bill Q wrote: > Please see attached. > > Looking for a macro to automate a repetitive task. > > 1. It is to look for a specific text in Col

$$Excel-Macros$$ VBA MACRO NEEDED (SIMPLE??)

Please see attached. Looking for a macro to automate a repetitive task. 1. It is to look for a specific text in Column C. In this case, it would be the word "GEORGE" 2. Once it encounters the word, Column B would be populated with "X". 3. The "X" would continue to be populated until it column C

Re: $$Excel-Macros$$ VBA Macro - Whatsapp Group

Thank you On 13 September 2016 at 22:39, Learner Excel wrote: > No, > you can not add more thn 250 ppls > > -- > > On Tue, Sep 13, 2016 at 2:03 PM, Pol Ktk wrote: > >> is there any option in whatsup appln to add unlimited members(in single >> group) >> paid or free ? >> >> On 11 September 2016

Re: $$Excel-Macros$$ VBA Macro - Whatsapp Group

No, you can not add more thn 250 ppls -- On Tue, Sep 13, 2016 at 2:03 PM, Pol Ktk wrote: > is there any option in whatsup appln to add unlimited members(in single > group) > paid or free ? > > On 11 September 2016 at 11:50, Learner Excel wrote: > >> Thanks Prabhu!.. >> >> Happy to here from yo

Re: $$Excel-Macros$$ VBA Macro - Whatsapp Group

is there any option in whatsup appln to add unlimited members(in single group) paid or free ? On 11 September 2016 at 11:50, Learner Excel wrote: > Thanks Prabhu!.. > > Happy to here from you!>=. > > -- > > On Sun, Sep 11, 2016 at 11:31 AM, Prabhu Pinky > wrote: > >> Hi Friends, >> >> Since i h

Re: $$Excel-Macros$$ VBA Macro - Whatsapp Group

Thanks Prabhu!.. Happy to here from you!>=. -- On Sun, Sep 11, 2016 at 11:31 AM, Prabhu Pinky wrote: > Hi Friends, > > Since i have created Whatsapp group for VBA Macro learners/experts. > > And i have added many peoples in this group. Please Msg me to 9500087194 > in whatsapp to get added in

$$Excel-Macros$$ VBA Macro - Whatsapp Group

Hi Friends, Since i have created Whatsapp group for VBA Macro learners/experts. And i have added many peoples in this group. Please Msg me to 9500087194 in whatsapp to get added in this group. if anyone missed or not yet added even you requested earlier. Thanks & Regards, Prabhu R -- Are you =

Re: $$Excel-Macros$$ VBA - How to extract text from blocks defined by “$begin” and “$end” ?

yes On Wednesday, September 7, 2016 at 11:32:24 AM UTC-4, XLS S wrote: > > Do you need all values from brackets or some specif . > > -- > > On Wed, Sep 7, 2016 at 8:41 PM, Pierre > > wrote: > >> here it is >> >> On Wednesday, September 7, 2016 at 11:04:55 AM UTC-4, XLS S wrote: >>> >>> sorry typo

Re: $$Excel-Macros$$ VBA - How to extract text from blocks defined by “$begin” and “$end” ?

Do you need all values from brackets or some specif . -- On Wed, Sep 7, 2016 at 8:41 PM, Pierre wrote: > here it is > > On Wednesday, September 7, 2016 at 11:04:55 AM UTC-4, XLS S wrote: >> >> sorry typo error, >> >> Can you please upload some sample ASCII file if possible >> >> -- >> >> On Wed

Re: $$Excel-Macros$$ VBA - How to extract text from blocks defined by “$begin” and “$end” ?

here it is On Wednesday, September 7, 2016 at 11:04:55 AM UTC-4, XLS S wrote: > > sorry typo error, > > Can you please upload some sample ASCII file if possible > > -- > > On Wed, Sep 7, 2016 at 8:32 PM, Learner Excel > wrote: > >> Can you please upload some same ASCII same file if possible >>

Re: $$Excel-Macros$$ VBA - How to extract text from blocks defined by “$begin” and “$end” ?

sorry typo error, Can you please upload some sample ASCII file if possible -- On Wed, Sep 7, 2016 at 8:32 PM, Learner Excel wrote: > Can you please upload some same ASCII same file if possible > > -- > > On Wed, Sep 7, 2016 at 8:25 PM, Pierre wrote: > >> the data is an ASCII file that I need

Re: $$Excel-Macros$$ VBA - How to extract text from blocks defined by “$begin” and “$end” ?

the data is an ASCII file that I need to parse On Wednesday, September 7, 2016 at 10:35:29 AM UTC-4, XLS S wrote: > > Hi Pirerre, > > Please help me understand - > 1. Is this in excel only? > 2. There is any unique identifier if the blocks are more than one. > > Suggestions - > 1. We can you us Te

Re: $$Excel-Macros$$ VBA - How to extract text from blocks defined by “$begin” and “$end” ?

Can you please upload some same ASCII same file if possible -- On Wed, Sep 7, 2016 at 8:25 PM, Pierre wrote: > the data is an ASCII file that I need to parse > > On Wednesday, September 7, 2016 at 10:35:29 AM UTC-4, XLS S wrote: >> >> Hi Pirerre, >> >> Please help me understand - >> 1. Is this

Re: $$Excel-Macros$$ VBA - How to extract text from blocks defined by “$begin” and “$end” ?

Hi Pirerre, Please help me understand - 1. Is this in excel only? 2. There is any unique identifier if the blocks are more than one. Suggestions - 1. We can you us Text to column than use some formulas to make table 2. You can extract value thru using LEFT,RIGHT formula -- On Wed, Sep 7, 20

$$Excel-Macros$$ VBA - How to extract text from blocks defined by “$begin” and “$end” ?

Hello I have this file that I need to extract data from it $begin pec simple('conductivity', 1.0E30) ModTime=1028307964 $end pec . . . $begin nickel simple('conductivity', 1450) simple('permeability', 600) simple('thermal_conductivity',90) simple('mass_density',

Re: $$Excel-Macros$$ VBA code to display the criteria selected from a filer

Upon investigation, the simplest solution seems to be to:-Make sure you have a formula that recalculates when filters change.   (I used =Count(A:A) in one of the header cells) - Create a Worksheet_Calculate event macro. In that macro, you can check to see if the worksheet is filtered:   If (Acti

$$Excel-Macros$$ VBA code to display the criteria selected from a filer

I have created a macro that will filter information from a report I generated. I would like to print on the total line the filter selected, such as TOTAL FOR EXPENSE GROUP AB when I select AB from the filter drop down. How could I do this Thanks in advance, Rich -- Are you =EXP(E:RT) or =N

Re: $$Excel-Macros$$ VBA Help

Thank you very much. I'm learning VBA Thanks N.Sundarvelan 9600160150 On 19 August 2016 at 22:34, mrExcel4u wrote: > Hi, > Please use the below mentioned code on Add command Button click > > Private Sub CommandButton1_Click() > > Dim Rcount As Integer > > Rcount = Sheet1.Cells(Rows.Count, 1).E

Re: $$Excel-Macros$$ VBA Help

Hi, Please use the below mentioned code on Add command Button click Private Sub CommandButton1_Click() Dim Rcount As Integer Rcount = Sheet1.Cells(Rows.Count, 1).End(xlUp).Row Rcount = Rcount + 1 Range("b" & Rcount).Value = Me.TextBox1.Value ActiveCell.Offset(0, 2).Value = Me.TextBox2.Value Ra

$$Excel-Macros$$ VBA Help

Dear Friends, I'm trying to learn VBA, PFA, i'm trying to add data from userform text to excel table. Please help Thanks N.Sundarvelan 9600160150 -- 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 @ ht

$$Excel-Macros$$ VBA macro - WhatsApp group.

Creating WhatsApp group for VBA macro... Pls msg me your contact, if you wants to join. Add me in WhatsApp and Msg me to - 9500087194 Regards, Prabhu.R -- 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 @

$$Excel-Macros$$ VBA code to send multiple PDF to multiple e mail receipients from outlook

Dear Friends, I have some 150 pdf (payslips) which has to be sent to employees respective mail id.as attachments. Presently I use mail merge to send the payslip html format. Can anyone assist me with VBA code. Rajarajan -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?

Re: $$Excel-Macros$$ Vba find order in which a range of dates are stored

To compare two dates, use the DateDiff() function. Something like:Sub ChkSort()     Dim nRow     For nRow = 1 To 10     Select Case DateDiff("d", Cells(nRow, "A").Value, Cells(nRow + 1, "A").Value)     Case Is > 0     MsgBox "Sort is Ascending"     Exit For

$$Excel-Macros$$ Vba find order in which a range of dates are stored

Range A:A contains a set of dates Rane B:B contains a set of dated Both ranges have been sorted asc or desc. Unknown which. Need a method to find the order in which dates are stored in each range. Thanks for any suggestions. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna

$$Excel-Macros$$ VBA 2016 Compatibility with VBA 2010 (Missing Reference)

Dear Experts: I would like to have spreadsheets shared between a 2010 Excel user and a 2016 Excel user. The issue is that when a 2016 Excel user saves a spreadsheet; a 2010 Excel user will not be able to open it and run macros which use Word objects. When the user tries to run one of these macro

$$Excel-Macros$$ VBA to save each page of a mail merge document seperately

hello Group, Need help with saving each page ( as a PDF or a word file) of a mail merge document. I tried to find a few codes on the net but havent been able to work my way around any of those ?:( Thanks and Regards, Gargee Singh -- Are you =EXP(

Re: $$Excel-Macros$$ VBA to save each page of a mail merge document seperately

t; > Thanks and Regards, > Gargee Singh > > -- > From: garge...@hotmail.com > To: excel-macros@googlegroups.com > Subject: $$Excel-Macros$$ VBA to save each page of a mail merge document > seperately > Date: Wed, 16 Mar 2016 18:50:06 +0530 > >

RE: $$Excel-Macros$$ VBA to save each page of a mail merge document seperately

Hello everyone, Sorry forgot to share the file . Thanks and Regards, Gargee Singh From: garge...@hotmail.com To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ VBA to save each page of a mail merge document seperately Date: Wed, 16 Mar 2016 18:50:06 +0530 hello Group, Need help

Re: $$Excel-Macros$$ VBA developer job in Gurgaon

yes On Tue, Mar 15, 2016 at 3:53 PM, Pramod Singh wrote: > Bro have u knowledge of Excel automation? > > Pramod > On 15 Mar 2016 14:24, "Anil Gawli" wrote: > >> >> >> On Tue, Mar 15, 2016 at 1:08 PM, Pramod Singh >> wrote: >> >>> This is notify to all guys who have good knowledge of VBA progra

Re: $$Excel-Macros$$ VBA developer job in Gurgaon

Bro have u knowledge of Excel automation? Pramod On 15 Mar 2016 14:24, "Anil Gawli" wrote: > > > On Tue, Mar 15, 2016 at 1:08 PM, Pramod Singh wrote: > >> This is notify to all guys who have good knowledge of VBA programming. >> I have un Opning for the post of Vba developer. >> >> Please conta

Re: $$Excel-Macros$$ VBA developer job in Gurgaon

On Tue, Mar 15, 2016 at 1:08 PM, Pramod Singh wrote: > This is notify to all guys who have good knowledge of VBA programming. > I have un Opning for the post of Vba developer. > > Please contact me on below mention details if any one interested. > > Profile Vba developer > Location Gurgaon > Cont

$$Excel-Macros$$ VBA developer job in Gurgaon

This is notify to all guys who have good knowledge of VBA programming. I have un Opning for the post of Vba developer. Please contact me on below mention details if any one interested. Profile Vba developer Location Gurgaon Contact 9899650234 Pramod Singh. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT

Re: $$Excel-Macros$$ VBA password protected

Dear Mr. Vikas, If you look in the "FORUM RULES", you'll notice #3: 3) Don't post questions regarding breaking or bypassing any security measure. Basically, programmers use passwords to protect their "Intellectual Property", which is their livelihood.For myself and others, we would be unwilling to

Re: $$Excel-Macros$$ VBA password protected

​Send me the file​ On 5 March 2016 at 19:48, wrote: > Hi all, > > I have an excel file which has multiple macros built. When I try to access > the VBA, it gives a pop-up to enter the password. The macros have been > written by predecessor and my boss wants me to decode this. > > Since i

$$Excel-Macros$$ VBA password protected

Hi all, I have an excel file which has multiple macros built. When I try to access the VBA, it gives a pop-up to enter the password. The macros have been written by predecessor and my boss wants me to decode this. Since it contains confidential client details, wont be able to share the file,

$$Excel-Macros$$ VBA Code to sort on multiple columns and print out result

Hello, I have a worksheet that I would like to sort on multiple columns and then print out the result with the title of the report on the first row. I would like to get the worksheet "Data", in the attached file, filtered by "Input date" (column "E"),"Sex"(Column "C" )and then "Name" (Column"A"

Re: $$Excel-Macros$$ VBA Macro for PPT Chart objects content edit (inside)

dim ppApp  As PowerPoint.Applicationdim ppReport   As PowerPoint.Presentationdim ppSlide  As PowerPoint.Slidedim oPPTOLEObject_Text   as object Set ppReport = ppApp.Presentations.Open("PPT Path")                    ppApp.Visible = msoTrue                    'Filling text boxes in ppt            

$$Excel-Macros$$ VBA Macro for PPT Chart objects content edit (inside)

Hi team, is there any piece of code for opening chart object and edit the content in PPT? -- Thanks & regards Satheesh -- 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/discu

$$Excel-Macros$$ VBA access to sheets on Google Drive

I've tried Googling this, with mixed results, so I thought I'd bring it to this group. I'm working with a team of students that are updating sheets on a Google Drive. One of the student is opening each of the Google Sheets and coping the test data into an Excel workbook and using macros to gene

$$Excel-Macros$$ VBA Code for Create Name Range

Dear All Here I want VBA code for creating Name Range (Ctrl+F3).If there are few companies then it is possible to create name rage for each sector but if there are more than 100 companies with different sector in both column then there are a lot of time consuming.So i want this code. If we click

$$Excel-Macros$$ vba code help with revision times

Hi all, I need help with my revision time issue. The rule for the revision time code is after 8 character, if it's a number then it will show the number. Else, it will show error. However, one of the revision time format is REVI9_gif. It shows at EVI_gif in the cell instead of error. Can anyon

$$Excel-Macros$$ vba code for getting the date

Hi all, I'm trying to create vba code with corresponding date modified according to the file. Can anyone help me with the code? I would like to get just the date showed, not the time. When there is new file updated, i hope it can be updated automatically in the workbook. may I know how can I a

Re: $$Excel-Macros$$ vba code for listing folder name and file name

Hi Mandeep, I've changed my code to the following. In terms of the revision times, I want to check whether it's following the format or not as well. Other than that, I'm not sure how to put the date modified in it as well. On Monday, 11 January 2016 17:50:35 UTC+8, Mandeep Baluja wrote: > >

Re: $$Excel-Macros$$ vba code for listing folder name and file name

Hey Kat, I am sorry but i didn't get the logic of this code which is totally different from your above query,Things which i understand its just checking whether file_name following the criteria or not, if 9th letter of the file name is equal to R then do something else show error in all column

Re: $$Excel-Macros$$ vba code for listing folder name and file name

Hi Mandeep, The revision time in my snapshot is the one I use writing. The real code isn't showing. It's not showing the folder name and file name as well. In terms of revision times, it's fine if the changes are done in certain interval. On Monday, 11 January 2016 15:34:15 UTC+8, Mandeep

Re: $$Excel-Macros$$ vba code for listing folder name and file name

Revision time ?? I have not heard about this while searching it on the internet I found this http://excel.tips.net/T002868_Using_Revision_Tracking.html which track the changes done workbook shared on network. Is revision time being noted anywhere in your workbook your snapshot is not showing wh

Re: $$Excel-Macros$$ vba code for listing folder name and file name

Hi Abhi, Unfortunately, the code doesn't apply for my case. On Monday, January 11, 2016 at 2:52:34 PM UTC+8, Abhi wrote: > > Please see if this solves your purpose - > > http://www.vbaexpress.com/kb/getarticle.php?kb_id=837 > > On Mon, Jan 11, 2016 at 11:55 AM, Kat > > wrote: > >> Hi Abhi, >> >

Re: $$Excel-Macros$$ vba code for listing folder name and file name

Please see if this solves your purpose - http://www.vbaexpress.com/kb/getarticle.php?kb_id=837 On Mon, Jan 11, 2016 at 11:55 AM, Kat wrote: > Hi Abhi, > > In terms of revision times, I want to show all the current revision times. > Also, in the future, if there is any revision times being updat

Re: $$Excel-Macros$$ vba code for listing folder name and file name

Please elaborate what do you mean by "revision times". Do you want to show the time when it was most recently updated or you want to show how many times has it been updated? On Mon, Jan 11, 2016 at 9:52 AM, Kat wrote: > Hi all, > > I want to create a xlsm file which list out the folder name, f

$$Excel-Macros$$ vba code for listing folder name and file name

Hi all, I want to create a xlsm file which list out the folder name, file name and revision times with its corresponding date modified. When there is new file updated, i hope it can be updated automatically in the workbook. may I know how can I achieve this? Thanks in advanced. Cheers --

Re: $$Excel-Macros$$ vba code help for the open file location

I'm "slightly" confused by your example. For your records: | A | B | C | | apr | C:\Users\pwloo\Desktop\break\goal\apr\2F6KB026 | 2F6KB026 | Is the value in column "B" a folder? or a filename with path?Is the value in column "C" a FILE that just happens to be the same name as the last folder nam

$$Excel-Macros$$ vba code help for the open file location

Hi all, I was wondering how could I make the open folder button for file name column instead of file location path column? For instance, from the picture below, when I point my cursor to C:\Users\maggie\Desktop\coke\diet\apr\2F6KB026 and click open file button, it will open the file 2F6KB026

$$Excel-Macros$$ vba code for integrating particular information from different workbook to one workbook

Hi all, I need help for vba code for creating a master file. I would like to create a master file which needs to be read only in Excel format. The information for the master fil

$$Excel-Macros$$ VBA (Excel) Transferring Data to Website

Dear Experts: Does anyone know if VBA can input data from a spreadsheet onto a web page? Can the data in the attached spreadsheet be automatically populated into the following page? https://www.defeasewithease.com/ Thank you very much, I respect you expertise, M.P. -- Are you =EXP(E:RT) or

Re: $$Excel-Macros$$ VBA Code need

Run this code Regards, Mandeep baluja Sub Parse() > > Dim hw As Long: hw = 2 > Dim k As Long: k = 2 > Dim j As Long: j = 2 > For i = 3 To 7 > Sheets(2).Cells(1, j).Value = "Col" & j - 1 > Sheets(2).Cells(k, 1).Resize(hw, 1).Value = Sheets(1).Cells(i, 1).Value > Sheets("sheet1").Range(Cells(i,

Re: $$Excel-Macros$$ VBA Code need

can,To all the people > you can,As long as ever you can.” - John Wesley* > - > > -- > *From:* Renukachari Kasee > > *To:* "excel-...@googlegroups.com " < > excel-...@googlegroups.com > > *Sent:* Thursday, November

Re: $$Excel-Macros$$ VBA Code need

enukachari Kasee To: "excel-macros@googlegroups.com" Sent: Thursday, November 12, 2015 2:49 PM Subject: $$Excel-Macros$$ VBA Code need Dear All, Pls help...need vba code for specified format... Thanks & Regards RenukaChari. Kasee-- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Ex

$$Excel-Macros$$ VBA Code need

*Dear All,* *Pls help...* *need vba code for specified format...* *Thanks & RegardsRenukaChari. Kasee* -- 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 R

Re: $$Excel-Macros$$ VBA to pick up current date in last column

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: Pravin Gunjal To: Excel Macros ; Mandeep Baluja ; Vaibhav Joshi (Vabz) - Mumbai Excel Sent: Mond

Re: $$Excel-Macros$$ VBA to pick up current date in last column

PFA... On Mon, Oct 26, 2015 at 4:02 PM, Pravin Gunjal wrote: > Dear Friends > > I have attached an excel file in which I have used macro to get "Created > by" field automatically once the values are entered in column N (Qty). > Likewise I want the last column (Entry Date) to be updated as curren

$$Excel-Macros$$ VBA to pick up current date in last column

Dear Friends I have attached an excel file in which I have used macro to get "Created by" field automatically once the values are entered in column N (Qty). Likewise I want the last column (Entry Date) to be updated as current date, as and when the column N gets entered. I have made one manual ent

$$Excel-Macros$$ VBA Code Error in all files

Hi Greetings! Getting an attached error while opening files of VBA. Kindly help me to resolve the same. Regards Pravin Gunjal -- 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.co

Re: $$Excel-Macros$$ VBA code for delete duplicate rows

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: mani bolla To: excel-macros@googlegroups.com Sent: Thursday, October 22, 2015 2:03 PM Subject: Re: $$Excel-Macros

Re: $$Excel-Macros$$ VBA code for delete duplicate rows

> you can,As long as ever you can.” - John Wesley* > - > > -- > *From:* mani bolla > *To:* MS EXCEL AND VBA MACROS > *Sent:* Thursday, October 22, 2015 1:47 PM > *Subject:* $$Excel-Macros$$ VBA code for delete duplicate

  1   2   3   4   5   6   7   8   9   >