$$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 2009 15:20:24 +0100
ah hi see, I think its my fault for not explaining properly, ill email you a
copy off the sheet to let you see, you will see the form called farm take a
look at that J
alex
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On
Behalf Of Dave Bonallack
Sent: 21 October 2009 06:02
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Re: Is this possible and how
Hi Alex,
Not sure if this is helpful, but it's something to consider.
A macro can identify the button that called it, and the text on that button.
So you can have just one macro, with lots of different buttons calling it. The
code within the macro can do different things depending on which button called
it, or the text on the button that called it.
For example:
On Error GoTo Ext:
Dim X As Range
A = Application.Caller 'The variable 'A' now holds the Button Object that
called the macro
B = ActiveSheet.Buttons(A).Characters.Text'The variable 'B' now holds
the text from that Button
If B = "Text A" Then
Set X = Columns("D:D").SpecialCells(xlCellTypeBlanks)
If B = "Text B" Then
Set X = Columns("F:F").SpecialCells(xlCellTypeBlanks)
If B = "Text C" Then
Set X = Columns("H:H").SpecialCells(xlCellTypeBlanks)
X.Cells(1, 1) = 7
X.Cells(1, 2) = 58
Ext:
Exit Sub
Change Text A, Text B, Text C to whatever text you have on your buttons.
If 50 of your buttons have one text, and the other 50 have another text, then
you'll only need 2 choices.
Regards - Dave.
> Date: Tue, 20 Oct 2009 10:21:53 -0700
> Subject: $$Excel-Macros$$ Is this possible and how
> From: zanderman1...@googlemail.com
> To: excel-macros@googlegroups.com
>
>
> Hi all in VBA 6.5 I have this code that i was supplied by one off your
> members which works fine:
>
> On Error GoTo Ext:
> Dim X As Range
> Set X = Columns("D:D").SpecialCells(xlCellTypeBlanks)
> X.Cells(1, 1) = 7
> X.Cells(1, 2) = 58
> Ext:
> Exit Sub
>
> Having used this code on 50 Option buttons and changing the X.Cells
> Values to suit, I now need to cpoy and paste the same code another 100
> times But changing the D:D values to F:F for 50 buttons and H:H for
> the remaining 50. Can anyone help or do i really have to do this all
> manualy??
>
> alex
>
>
> http://clk.atdmt.com/NMN/go/157639755/direct/01/
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
We reach over 6,500 subscribers worldwide and receive many nice notes about the
learning and support from the group. Our goal is to have 10,000 subscribers by
the end of 2009. Let friends and co-workers know they can subscribe to group at
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---
$$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 -Original Message- From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of Anish Shrivastava Sent: Wednesday, October 21, 2009 8:42 PM To: excel-macros@googlegroups.com Subject: $$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 installed)... Cheers!! ANISH On Tue, Oct 20, 2009 at 8:27 PM, Anurag Singh Aswal wrote: Hi Excel mahagurus, First of all, I appreciate this group and especially the troubleshooter members very much and pay my highest regards to them. My query is that, I need to open an excel workbook which requires password.Have already tried my hand on some recovery softwares but no luck as of now. Is there any way to unlock it and if any, please let me know. ANURAG SINGH ASWAL Mobile +91-9818399155 anurag.singh.as...@ericsson.com --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$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 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 some reports that I run. I use excel 2007 and the > main problem I have is that the reports are updated bi-weekly via > refresh of external qry to an access database on my server. When I > click "refresh all" the qrys run and excel becomes unusable to me for > several minutes. I am sure that It doesn't sound that bad but I have > to repeat the process for 6-10 reports. The time adds up and I need > to find a way to report faster. > > Please tell me if I am just a dreamer but in my mind it seems like > there should be a way for me to activate the "refresh all" and email > myself the finished product without locking up my computer or excel > for 2 hours. I do have a macro to run the refresh then email me the > product but again I still have the problem of excel locking up. Is > there a way for me to have the refresh (or macro to email self) run > without opening excel? I have punch and pie for anyone with a > promising suggestion. :) > > I am sure that that I have not explained details in full and I welcome > any questions. > > Thanks for your time. --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$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 appreciated! JP --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$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.saveas("\\path\name.xls")
applcation.displayalerts=true
thisworkbook.close(false)
2009/10/19 Doug
>
> Hello, again.
>
> I have a workbook which creates a new worksheet each day. When the
> worksheet is completed for the day, it is then saved as a new
> workbook. The original workbook is set to reference an xla add-in that
> I made but the newly created workbook doesn't have the reference.
>
> Can someone please tell me how to set the reference to a custom made
> add-in automatically through code?
>
> Thank you.
> Doug
>
> >
>
--
Hemant Hegde
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
We reach over 6,500 subscribers worldwide and receive many nice notes about the
learning and support from the group. Our goal is to have 10,000 subscribers by
the end of 2009. Let friends and co-workers know they can subscribe to group at
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---
$$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 installed)... Cheers!! ANISH On Tue, Oct 20, 2009 at 8:27 PM, Anurag Singh Aswal < anurag.singh.as...@ericsson.com> wrote: > > > Hi Excel mahagurus, > > First of all, I appreciate this group and especially the troubleshooter > members very much and pay my highest regards to them. > > My query is that, I need to open an excel workbook which requires > password.Have already tried my hand on some recovery softwares but no luck > as of now. > Is there any way to unlock it and if any, please let me know. > > > > > ANURAG SINGH ASWAL > Mobile +91-9818399155 > anurag.singh.as...@ericsson.com > > > > > --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$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 was available for use while it refreshed the data in the background. Have you noticed that when an excel application is busy (running a macro etc.) you could always open a separate excel application using [WINDOWS + R] key and entering "excel" in the dialog box? Why don't you run a separate excel application programatically (i guess you can even keep it invisible), get the data refreshed and values copied to the original workbook later when the refresh is complete? Please let me know if any of the above solve the problem Can you please email me the workbook (or a part of it) which you use to send emails to yourself or any other way of posting data from an excel workbook to a web site? I prefer the easiest way of doing it. That is may be like by generating an easy url like http://mywebsite.com/?mymsgsub=test%message?body=blah%blah%blah and without depending on a configured MS Outlook account. Thank you :) -- Hemant Hegde --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$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 dilemma that the cell needs > to be displayed in TIME format. Anyways thanks to the TEXT feature and YOU. > > Best Regards > Praveen Khunte > Lead Engineer > > E praveen.khu...@gmail.com > > -- > > > Dilip Pandey wrote: > > Hi Praveen, > > Try below formula and check it by changing system date. > > =TEXT(IF(AND(HOUR(NOW())>=10,MINUTE(NOW())>=0, > SECOND(NOW())>0),TODAY()+1,TODAY()),"dd-mmm-") & TEXT(TIME(10,0,0)," > hh:mm AM/PM") > > 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/20/09, Praveen Khunte wrote: >> >> Hi Dilip >> Thanks for the effort.It gave me sound idea of manipulating date. >> However, I would like to reiterate the problem. >> The cell displays 10/20/2009 10:00AM on 20th October. >> Can I display 10/21/2009 10:00AM on the same cell automatically when I >> open the file to 21st October. >> This means that dynamic date but fixed time in single cell. I hope you >> understand my requirement. >> >> Thanks >> Best Regards >> Praveen Khunte >> >> Dilip Pandey wrote: >> >> Hi Praveen, >> >> Try below formula:- >> >> =IF(AND(HOUR(NOW())>=10,MINUTE(NOW())>=0, >> SECOND(NOW())>0),TODAY()+1,TODAY()) >> Best Regards, >> -- >> DILIP KUMAR PANDEY >> MBA-HR,B COM(Hons.),BCA >> Mobile: +91 9810929744 >> dilipan...@gmail.com >> dilipan...@yahoo.com >> New Delhi - 110062 >> >> >> >> On Tue, Oct 20, 2009 at 7:18 AM, Praveen Khunte > > wrote: >> >>> >>> Hi ALL >>> In a excel sheet, I want to trigger an event everyday when time exceeds >>> 10 AM. >>> Is it possible to display on 20th October 2009 in a cell 20-Oct-2009 >>> 10:00 AM, >>> and when date changes to 21st October 2009 then it should automatically >>> change to 21-Oct-2009 10:00 AM >>> >>> Thanks in advance >>> Regards >>> Praveen >>> >>> > >>> >>> >>> >>> >>> >> >> > > > > > > > > --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$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 > work. > > Thanks, > > Imran > > > On Tue, Oct 20, 2009 at 9:28 PM, Dilip Pandey wrote: > >> Hi Imran, >> >> Attached file has been solved as per your requirements. Let me know if >> you face any challenge(s). >> >> 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/20/09, Imran khan wrote: >>> >>> Hi, >>> >>> I have one query in Excel. I have attached one excel file as an example. >>> I have date base in sheet 1 and in sheet 2 column B, I want the date count >>> from sheet 1 column G. >>> >>> Example: in Sheet1 : Column A Column B >>> >>> M8 20-Oct-09 >>> M8 20-Oct-09 >>> M7 17-Oct-09 >>> >>> I want result in sheet2: M08- 2 >>> M07- 1 >>> >>> It will be appreciated if someone can help as soon as possible, because i >>> am stuck here. >>> >>> Thanks, >>> >>> Imran Khan >>> Project Control Engineer >>> KBR - Kellog Brown & Root >>> Saudi Kayan Olefins Project >>> Al-Jubail (KSA) - 31952 >>> Mobile: +966-552158721 >>> Email: imran.kh...@kbr.com >>> >>> >>> >>> >> >> >> >> >> > > > -- > Imran Khan > Project Control Engineer > KBR - Kellog Brown & Root > Saudi Kayan Olefins Project > Al-Jubail (KSA) - 31952 > Mobile: +966-552158721 > Email: imran.kh...@kbr.com > > --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$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 applications, it sometimes extends the time for the refresh. What I did was keep a copy of the file in a folder called: ../../../Batch/ Then, I have a workbook_Open event that looks at the path name of the file. If it includes "/Batch/" then it executes the refresh and exits. I then created a Windows Scheduled Task and have it open the file at 4:00 in the morning. That way, it is updated by 5:30am every day. Of course, that means that I have to leave my workstation logged in (but locked) at night. I've considered writing the whole refresh script into a VBScript session. I THINK I can run this in a Scheduled Task without being logged in, since it doesn't open up a Windows application. Then, I could simply read from a text file and update Excel... either of these approaches sound promising? Paul From: Holsten To: MS EXCEL AND VBA MACROS Sent: Wednesday, October 21, 2009 12:56:48 AM Subject: $$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 some reports that I run. I use excel 2007 and the main problem I have is that the reports are updated bi-weekly via refresh of external qry to an access database on my server. When I click "refresh all" the qrys run and excel becomes unusable to me for several minutes. I am sure that It doesn't sound that bad but I have to repeat the process for 6-10 reports. The time adds up and I need to find a way to report faster. Please tell me if I am just a dreamer but in my mind it seems like there should be a way for me to activate the "refresh all" and email myself the finished product without locking up my computer or excel for 2 hours. I do have a macro to run the refresh then email me the product but again I still have the problem of excel locking up. Is there a way for me to have the refresh (or macro to email self) run without opening excel? I have punch and pie for anyone with a promising suggestion. :) I am sure that that I have not explained details in full and I welcome any questions. Thanks for your time. --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$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 some reports that I run. I use excel 2007 and the main problem I have is that the reports are updated bi-weekly via refresh of external qry to an access database on my server. When I click "refresh all" the qrys run and excel becomes unusable to me for several minutes. I am sure that It doesn't sound that bad but I have to repeat the process for 6-10 reports. The time adds up and I need to find a way to report faster. Please tell me if I am just a dreamer but in my mind it seems like there should be a way for me to activate the "refresh all" and email myself the finished product without locking up my computer or excel for 2 hours. I do have a macro to run the refresh then email me the product but again I still have the problem of excel locking up. Is there a way for me to have the refresh (or macro to email self) run without opening excel? I have punch and pie for anyone with a promising suggestion. :) I am sure that that I have not explained details in full and I welcome any questions. Thanks for your time. --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
