$$Excel-Macros$$ Re: Using Name.Name to Access Cell Names is Slow

Thank you. I have used the method of looping through the names in the workbook before, but I wanted to avoid it because I have several hundred named cells and the main objective of my code is to determine the name of the cell so I can write a value to that cell from a separate sheet. For example

$$Excel-Macros$$ Re: help on splitting into columns

If there is space between tel no & e-mail id,: 1. Go to data menu 2. Select text to colmuns 3. Select delimited 4. Click on next and select space 5. Click next and then finish Ur data will be seperated. On Nov 8, 10:13 am, [EMAIL PROTECTED] wrote: > In excel,i have a column having the phonenumbe

$$Excel-Macros$$ Can't Login via QueryTables to a Webpage (POST Method) Optionen

Hi Well, your problem has actually nothing to do with mine. This is something totally different. But you can of course create your own thread to get all the help you need. Thank you. -- pmw On 11 Nov., 02:55, "TERTIUS KOSHY THOMAS" <[EMAIL PROTECTED]> wrote: > Hi all, >   I need to create a l

$$Excel-Macros$$ Re: Macro for Login Page

The attached file does what you describe. When a workbook opens Excel automatically executes a module named "Auto_Open". I used Auto_Open to display an InputBox and looped until I got a match to one of your user IDs. To keep it clean I used a tab labeled Login for the security check. I also mov

$$Excel-Macros$$ Re: Macro for Login Page

Go to Workbook's private module and type this code in Open Workbook event:   If Environ("UserName") <> "USERNAME HERE" Then 'your code here ThisWorkbook.close ' if you want to close the workbook End If

$$Excel-Macros$$ I need your help for the below issue.

Hi all, I have explained all in the below attchment pls lookinto this and give your solution. Thanks and Regards, Vinu (¨`*.*´¨) Always `*.¸(¨`*.*´¨) Keep (¨`*.*´¨)¸.*´ Smiling! `*.¸.*´ --~--~-~--~~~---~--~~ Visit the blog to download Excel tutorials at http:/

$$Excel-Macros$$ Number of sheets in workbook equal to number of days in a month

Hi, Is there any macro using which i could get number of sheets in a workbook equal to number of days in a month. For example : If i am preparing a report for October then I should get 31 sheets in the workbook and if i am preparing report for November then i should get 30 sheets in the workbook.

$$Excel-Macros$$ Re: Picture in a workbook

Could you post the code for that function so that it will be easy for us to customize according to your needs. Regards, Ilyas Kazi http://automax-vba.blogspot.com On Nov 11, 3:20 am, [EMAIL PROTECTED] wrote: > Hello, > > We are using a function to add pictures to an Excel workbook in a VB > macr

$$Excel-Macros$$ Re: How can i print a range of worksheets from workbooks in a directory

I've attached a workbook containing two macros PrintWorkbooks and Traversethat together do what you are describing. Invoke PrintWorkBooks and provide the full starting path (e.g. C:\TEST). Starting at this point all subdirectories are traversed and each workbook found is opened and sheets meeting

$$Excel-Macros$$ Re: Running a sub through sub directories

I've found some code which lists files in recursive directories, however, how would i adapt it to pass the directory path to the printworkbooks(path) function. - A RECURSIVE VBA PROCEDURE TO DISPLAY A LIST OF FILES IN NESTED DIRECTORIES The example

$$Excel-Macros$$ What is array??

Hello all, Pls explain me what do mean by array in excel?? Thanks. --~--~-~--~~~---~--~~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group, send email to excel-macros@googlegroups.com For more options, visit