$$Excel-Macros$$ Re: Is this possible and how

Hi Alex, Didn't realise you were talking about a form, sorry. Can't help you on your actual query. Outside my area of experience. Regards - Dave. From: zanderman1...@googlemail.com To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: Is this possible and how Date: Wed, 21 Oct 200

$$Excel-Macros$$ Re: Opening excel workbook-Password recovery

Hi Anish Bro, Thanks a lot for your response. Actually I cannot send the file since it is an official one and I won't be allowed to send it outside. If you can please give me the exact name of the software which you use, I might try to get one. Thanks again for your help. ANURAG SINGH ASWAL -

$$Excel-Macros$$ Re: Run Excel Macro?

Unsure, but might it be faster to save the queried results to a temporary file from within Access then load the considerably smaller prequeried results into Excel for its update and reporting process? On Oct 21, 12:56 am, Holsten wrote: > Hi All, > > First let me say that I love reading through

$$Excel-Macros$$ Insert file path and name into cell

I would like to be able to select a cell in a worksheet and then run a macro to open a dialogue box to browse through folders and files on my computer, select a file, and insert that file path and name into the active cell. Can someone please help me to do this? Any help would be greatly appreci

$$Excel-Macros$$ Re: Set reference through VBA

Why dont you include the original vb code in the new workbook? use application.savecopyas("\\path\name.xls") Or if you are anyway closing the original workbook 'delete unwanted sheets and save applcation.displayalerts=false sheets("unwanted1").delete sheets("unwanted2").delete thisworkbook.sav

$$Excel-Macros$$ Re: Opening excel workbook-Password recovery

Hi Anurag, IF you dont mind then please send the file to me, I will give it a try (as of now dis cracker has cracked all the excel file ...hope this one also count on)... I will recover and send it bk to u.. (I cant send you the Setup file coz I don hv it for dis software/cracker, I hv got it ins

$$Excel-Macros$$ Re: Run Excel Macro?

I am not much familar with data connections to/from excel or automating emails but I remember when I had checked "data query" property (i got it by right-clicking on a cell in a sheet having external data connections) I had seen an option for "background refresh". When I enabled this feature, excel

$$Excel-Macros$$ Re: Displaying fixed time everyday

Dear Praveen, You are welcome..!! Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On 10/21/09, Praveen Khunte wrote: > > Thanks a lot Dilip > It worked out and solved my problem. I was in dilemm

$$Excel-Macros$$ Re: Excel Query

Hey Imran, You are always welcome...!! Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On 10/21/09, Imran khan wrote: > Thanks very much dear. I appreciate your effort. Keep it up this good > w

$$Excel-Macros$$ Re: Run Excel Macro?

I know exactly what you're going through. I've an application that has over 10,600 lines of vba code. it refreshes from 3 different data sources. I've got the refresh time reduced from over 3 hours to an hour and 12 minutes. During this time, Excel is unavailable and if I try to use other applicat

$$Excel-Macros$$ Run Excel Macro?

Hi All, First let me say that I love reading through the suggestions and examples that have been posted for other peoples problem's and have picked up some great formulas and macros and for that I am already thankful to you all. Now for my question. I have been searching for a way to automate s