$$Excel-Macros$$ printing page numbers of worksheets

2010-01-10 Thread Shannon
Hi there, this is no doubt a newb question, but I can't find anything online. I have a 'master' workbook containing various formulas (let's call that WB1). I import customer data into WB1 as separate worksheets, run my formulas, then copy out the resulting customer-specific worksheets into a new

$$Excel-Macros$$ Password crecker for Excel workbbok

2010-01-10 Thread maulik desai
Hi, Can any one provide me the password breaker or macros or any tool which can break the password to open the Excel workbook i am takiing abt to open password protected Excel workbook (not to unprotect the password protected sheet) i hope from this best group some one will help me -- Thanks &

$$Excel-Macros$$ unzip file using vba

2010-01-10 Thread Abhishek Agarwal
Hi, I want to unzip file using VBA. I am getting some response(a zip file) using XMLHTTP Object and i want to unzip it automatically. I referred to the site http://www.rondebruin.nl/windowsxpunzip.htm . It is using Getopenfilename which opens a dialog box. i don't want this dialog box. The file s

$$Excel-Macros$$ Vlookup-Dates

2010-01-10 Thread Sachin Gohil
Dear All, I did a vlookup of dates, but Im getting #N/A. The reason is every date in excel is tored as serial no. Tried using Date/Date value but it doesnt work.. _ New Windows 7: Find the

Re: $$Excel-Macros$$ Vlookup-Dates

2010-01-10 Thread Alokeshwar Tiwary
Please share the workbook? _ "There are known knowns. These are things we know that we know. There are known unknowns. That is to say, there are things that we know we don't know. But there are also

RE: $$Excel-Macros$$ printing page numbers of worksheets

2010-01-10 Thread Dave Bonallack
Hi S, Not sure if there's a solution to this. Probably is, but since you're doing it by macro, I'd just repeat the print command for each sheet. You can put a single print code-line into a loop if there's lots of sheets. Regards - Dave. > Date: Sat, 9 Jan 2010 11:08:44 -0800 > Subject: $$Exc

Re: $$Excel-Macros$$ Export from word to excel

2010-01-10 Thread ashish koul
thanks a lot for the solution can u please make it for notepad files too On Sun, Jan 10, 2010 at 3:02 PM, Alokeshwar Tiwary < alokeshwar.tiw...@yahoo.com> wrote: > Criteria or parameters aren't necessory but it may not be extracting data > in a useful format. > I have modified the macro to Selec

Re: $$Excel-Macros$$ Password crecker for Excel workbbok

2010-01-10 Thread Nandkumar kakvipure
Hello Bro, Please attach File On Sun, Jan 10, 2010 at 4:02 PM, maulik desai wrote: > Hi, > > Can any one provide me the password breaker or macros or any tool which > can break the password to open the Excel workbook i am takiing abt to open > password protected Excel workbook > (not to unprotec

Re: $$Excel-Macros$$ Code User Laval

2010-01-10 Thread SUMIT VYAS
GREAT ANKUR On Sat, Jan 9, 2010 at 10:32 AM, ankur wrote: > hi ramesh > > please check this file > > > On 1/8/10, Chanti-Hyderabad wrote: > > Hi Ankur, > > > > That working file looks awesomebut i cant see see any data on 'New > > Data' sheet. Is there a way i can see the data change accord