Re: $$Excel-Macros$$ Insert FilePath into cell

Dear Matthew, Use following function:- =CELL("filename",a1) Note:- A1 means reference to any of the cell in the spreadsheet. This functin will get you the complete path and now you can use it as per your needs. Best regards, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 98109297

Re: $$Excel-Macros$$ data cleaning in excel

Dear Azimullah, Choose any of the below formual and paste it in third column i.e, column C Row 2 onwards and you are done. =IF(SUMPRODUCT(($B$1:B2=B3)*($A$1:A20,"Duplicate","Unique") OR, =IF(COUNTIF($B$1:B1,B2)=0,"Unique","Duplicate") solved workbook is also attached. Best Regards, -- DILIP KU

$$Excel-Macros$$ Re: Insert FilePath into cell

so whats the problem using smthg like dim x,asd() as string x = application.getopenfilename asd=split(x,"/") x="" for i=1 to ubound(asd)-1 x=x & asd(i) next i On 11 дек, 00:20, Sing wrote: > Hey, does anyone know how to get a macro to insert a folder path into > a cell?  I'm not talking about the

Re: $$Excel-Macros$$ Marco for Print out

U can try this ,take the user input(url of particular website) then open page in sheet,and then print. i have uploaded macro and example sheet http://groups.google.com/group/excel_vba i m sure u will got answer. :) On Thu, Dec 10, 2009 at 2:45 PM, Mahesh wrote: > Dear All. > > I have any

Re: $$Excel-Macros$$ Insert FilePath into cell

Option Explicit ''user can choose 1 or more file from open dialogue ''path will be displayed by bsgbox '''for more help check out the link http://groups.google.com/group/excel_vba Sub UseFileDialogOpen() Dim lngCount As Long ' Open the file dialog With Application.FileDialog

Re: $$Excel-Macros$$ data cleaning in excel

Thanks for your reply Paul. actually i am using excel 2003 version, and looking for solution from excel functions only. i have one more constraint that i can't play with source data which means i may not be able to sort data. as these our output from another software application. so it might become

$$Excel-Macros$$ Insert FilePath into cell

Hey, does anyone know how to get a macro to insert a folder path into a cell? I'm not talking about the whole filepath like in using dim x as string s = application.getopenfilename I need only a folder, as I am then going to access that cell to determine where to save a bunch of files later on i

$$Excel-Macros$$ Copy all userforms to another workbook

I am currently working on an Excel project that I need to be able to update certain worksheets and userforms. I have built the code to replace the worksheets and have code to export / import an individual userform to the other workbook. I am having problems finding a way to loop through each of t

$$Excel-Macros$$ Freeze the cell once the Data has been entered?

Hi Excel Gurus, Looking for the following actions in excel. 1. As soon as I select an option from the drop down, the cell should be frozen, rather locked. 2. Further Cell should not allow any user to edit the data Please let me know if you have any questions. Regards, --Ramesh -- Thanks!!!

$$Excel-Macros$$ Freeze the cell once the Data has been entered?

Hi Excel Gurus, Looking for the following actions in excel. 1. As soon as I select an option from the drop down, the cell should be frozen, rather locked. 2. Further Cell should not allow any user to edit the data Please let me know if you have any questions. Regards, --Ramesh -- --

$$Excel-Macros$$ Freeze the once the Data has been entered?

Hi Excel Gurus, Looking for the following actions in excel. 1. As soon as I select an option from the drop down, the cell should be frozen, rather locked. 2. Further Cell should not allow any user to edit the data Please let me know if you have any questions. Regards, --Ramesh -- --

Re: $$Excel-Macros$$ data cleaning in excel

What version of Excel are you using? Are you wanting to "identify" the duplicates, or remove them? What you could do is: Sort the data by phone number and date. Copy the Phone numbers to another sheet, then if you're using Excel2007, remove Duplicates. Next, use VLookup to get the correct date. (

$$Excel-Macros$$ data cleaning in excel

Hi i have market research data that i need to clean in terms of finding out duplicate surveys. there are two criteria for this. firstly telephone number from which it was done. if it is repeated more han once then it means its duplicate, its the first criteria. second criteria is date. so if there

Re: $$Excel-Macros$$ Re: Need help to select the data columns into pivot table data field using VBA code.....

Hi Vallinayagam, Thanks a tonne for your help. It's working great. I would like to get more help on this. If data structure changes then I may need to edit the codes according to that. Instead of that input boxes have to get the input from me for column name to use for Row field (e.g. A to

RE: $$Excel-Macros$$ How to Protect Access Database from the Users ?

Hello. For instance : ConnectString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & BDD & ";" ConnectString = ConnectString & "Jet OLEDB:Database Password=" & "yourpassword" cn.Open ConnectString Daniel De : excel-macros@googlegroups.com [mailto:excel-mac...@google

$$Excel-Macros$$ Marco for Print out

Dear All. I have any excel file which contain around 200 links(website address). Now i want a Marco that copy the link from the cell and paste it on the address bar in Internet Explorer, open that page and give the print out, close it and move to next line. Please suggest it if possible or not.