$$Excel-Macros$$ Different behaviour between opening xls and xlsx files

2009-01-21 Thread Wazza
I have an application that opens Excel files and loads data into an Access database. This app runs unattended and so I have to take various precautions to ensure that Excel doesn't produce any prompts that require human input. One such situation is where a user decides to password protect the fil

$$Excel-Macros$$ Re: How to unhide the sheet

2009-01-21 Thread VIRAL PANDYA
I m just an end user but if any one know please help this man with default file name for MS excel. Like NORMAL.DOT for Microsoft word. Open the default file for excel and unhide from VBA mudule... it may be very hide... (-1) factor. this may clear everything... if not... than reinstall MS Of

$$Excel-Macros$$ Re: How to unhide the sheet

2009-01-21 Thread Tariq Kamal
can u send the sheet... On 1/21/09, Ajay Varshney wrote: > > send us your file, we will unhide the sheet and send back to you. > > > > > > On Mon, Jan 19, 2009 at 4:23 PM, vinu wrote: > >> >> its not working I tried it.. >> >> On Jan 17, 2:34 pm, "vijender kumar" wrote: >> > Just go to >> >

$$Excel-Macros$$ Re: Import CSV - Prompt for File - Adjust for Formulas and Totals Row?

2009-01-21 Thread macrojunkie
Just to post some of what I have worked on, I have the code that I can use to add formulas, and set the page setup. I know I will need to modify this to accomodate for how many lines may be in a given csv. What is missing here, is the beginning of the code, which needs to be the importing of a cs

$$Excel-Macros$$ Re: macro that will combine workbooks

2009-01-21 Thread Tom Jeffries
Take a look at the attached macro. It may do what you want. Tom On Tue, Jan 20, 2009 at 12:49 PM, Debasish Sahu wrote: > hi > I have several work books having contact details in a folder (with same > headers). Now I want to merge all files in to one sheet. Could somebody > please provide a macro

$$Excel-Macros$$ help with vlookup in macro

2009-01-21 Thread himansu
Hello everyone, Anyone know what's wrong with this formula? It's embedded in a macro that I'm writing: ActiveCell.FormulaR1C1 = "VLOOKUP(LEFT(rc1,4)&"2"&RIGHT(rc1,LEN(rc1)-5)," & JobNumber & "_keycodes!R1C1:R150C3,3,FALSE)" -- Thanks, Himansu --~--~-~--~~~---~

$$Excel-Macros$$ Import CSV - Prompt for File - Adjust for Formulas and Totals Row?

2009-01-21 Thread macrojunkie
I have a workbook with 3 tabs. Right now, I am working to make this a template that I can import 3 csv files into for a given report. What I lack is a way to make this automated. I set this up with a small set of data. Each tab has the follow standard format: + First row has headers + A total

$$Excel-Macros$$ Re: Date of Entry in cell -> automatically into next collumn!

2009-01-21 Thread Paul Schreiner
Ok, first of all, the sub should be a change event, so that it is triggered when you make a change to the worksheet. Second, You really don't need the cdate function. Third, I would recommend that you use the Application.EnableEvents function so that you don't trigger the change event when you a

$$Excel-Macros$$ Password Recobvery

2009-01-21 Thread Thierry Belgium
Go on google and look for "Free Word Excel Password Wizard" It's free but it's also putting spying cookies on your PC so remove it afterwards ... Thierry Delgutte www.intermotion.net --~--~-~--~~~---~--~~ Visit the blog to download Excel tutorials at http://www.

$$Excel-Macros$$ Re: How to unhide the sheet

2009-01-21 Thread Ajay Varshney
send us your file, we will unhide the sheet and send back to you. On Mon, Jan 19, 2009 at 4:23 PM, vinu wrote: > > its not working I tried it.. > > On Jan 17, 2:34 pm, "vijender kumar" wrote: > > Just go to > > > > Fomat > sheet > unhide the sheet. > > > > On 1/16/09, vinu wrote: > > >

$$Excel-Macros$$ Multivariate Analysis Add inn

2009-01-21 Thread SR
Is there anybody who has thiscan you please share... --~--~-~--~~~---~--~~ 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 this group

$$Excel-Macros$$ Re: foget password

2009-01-21 Thread Thierry Belgium
Go on google and look for "Free Word Excel Password Wizard" It's free but it's also putting spying cookies on your PC so remove it afterwards ... Thierry Delgutte www.intermotion.net On Jan 17, 3:38 pm, Rabindra Thapa wrote: > i protected by password on my working files but after long time whe

$$Excel-Macros$$ Re: How to unhide the sheet

2009-01-21 Thread vinu
Yes I have tried.. its not working.. On Jan 21, 10:51 am, Naveen wrote: > Hi, > Have u tried this one.? >   >   > Tools-Options-General tab-Sheets in new workbook-make changes here.. >   > >   > Regards > Naveen Kumar M N > >     Transport Supervisor(HP) > 91-08-99728 10

$$Excel-Macros$$ Date of Entry in cell -> automatically into next collumn!

2009-01-21 Thread Tobi Hammet
Hey everyone, I wanted to have an entry of date everytime i make a new entry in A1:A100 the dates should dissapear when i delete the content. I thought this should work: Sub auto_date() 'Quelle: tob If Intersect(Target, Range("A1:A100")) Is Nothing Then Exit Sub If Target.Count > 1 Then

$$Excel-Macros$$ Re: foget password

2009-01-21 Thread Thierry Belgium
Search for the free application "Free Word Excel Password Wizard" on google. It will crack your Excel Password. This free application however is also somekinda spyware .. so delete it after you used it and delet your internet cookies. Thierry Delgutte www.intermotion.net -