RE: $$Excel-Macros$$ Refresh cell formula using VBA

2011-02-17 Thread Dave Bonallack
Hi Aduh, I assume that you have the Calculation set to Manual. One way would be to use a selection change event that detects if the selected cell has a formula in it, then calculates just that cell. The following code goes into the VBA sheet window: Private Sub Worksheet_SelectionChange(ByVal

RE: $$Excel-Macros$$ Refresh cell formula using VBA

2011-02-17 Thread Dave Bonallack
Hi, Sorry - didn't see your attachment. Link your button to the following macro, which can just live in a module: Sub refreshRange() Range(B40:B54).Calculate End Sub Alternatively, you could do away with the button and have the macro fire whenever you change B39. This macro would live in the

Re: $$Excel-Macros$$ Partial Matching HELP PLEASE! SOS! SOS!!

2011-02-17 Thread Umed Singh
On 2/16/11, Aindril De aind...@gmail.com wrote: Hi Mike, Please use: =VLOOKUP(A2,Sheet1!B:B,1,0) instead. Regards, Andy On Wed, Feb 16, 2011 at 2:21 AM, MikeMikeMike michael.lovel...@gmail.comwrote: I am struggling with this and wondering if you could help.. Worksheet 1 Column A B

$$Excel-Macros$$ Import .csv match records

2011-02-17 Thread Dave
I am on Excel 2003,. I have a spreadsheet with 12 monthly tabs one for every month of the year January, February … December.. This file is called montly_totals.xls and is located in P:\DAM\WI_FTP. There are a total of 200 accounts set up in each of these monthly tabs. Each of these accounts

$$Excel-Macros$$ New Web Query get data from existing open IE Browser instead of opening new browser window

2011-02-17 Thread RCGUA
With Microsoft Excel 2003, using the Web Query feature, I record a macro, put the URL of the website into the New Web Query and that opens a new instance of Internet Explorer. Using the Web Query, I go to a specific table within the tables on the web page and select the table that I want to get

Re: $$Excel-Macros$$ Nos. of Sundays between two days

2011-02-17 Thread Rajasekhar Praharaju
thanks alot its awesome On Wed, Feb 16, 2011 at 8:48 PM, ashish koul koul.ash...@gmail.com wrote: j1 start date j2 end date monday =I F(TEXT(J1,)Monday,NETWORKDAYS(J1,J2)/5,INT(NETWORKDAYS(J1,J2)/5)+1) saturday = INT(((J2-J1)-NETWORKDAYS(J1,J2))/2) On Wed, Feb 16, 2011 at 7:10

Re: $$Excel-Macros$$ Import .csv match records

2011-02-17 Thread Paul Schreiner
Piece of cake... I can probably write it in 20 minutes. = Option Explicit Dim Col_Array_Code1, Col_Array_Code2, Col_Array_YR, Col_Array_MM Dim Col_Array_CoName, Col_Array_Dept, Col_Array_Qty, Col_Array_Amt Dim Code1, Code2,

Re: $$Excel-Macros$$ New Web Query get data from existing open IE Browser instead of opening new browser window

2011-02-17 Thread ashish koul
write on error resume next on the line above in the code which is giving errors see if that helps On Thu, Feb 17, 2011 at 8:17 PM, RCGUA stv.nels...@gmail.com wrote: With Microsoft Excel 2003, using the Web Query feature, I record a macro, put the URL of the website into the New Web Query

RE: $$Excel-Macros$$ Import .csv match records

2011-02-17 Thread Dave Bonallack
I think someone is using my name in vain - unless there are two Dave's in the world - and I don't know how that could be... Dave. Date: Thu, 17 Feb 2011 09:15:24 -0800 From: schreiner_p...@att.net Subject: Re: $$Excel-Macros$$ Import .csv match records To: excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Diff excel Sheet based on Name test

2011-02-17 Thread maulik desai
Thanks mahesh, there is some problem with the code when i click on Create workbook button it give me error in code ActiveWorkbook.SaveAs (sPath sFileName) also border part also not execute request u to kindly check the same And my earlier mail have mentioned that each process has is own

Re: $$Excel-Macros$$ How to Pull out Ref type Value base on process DOJ Process Name

2011-02-17 Thread maulik desai
Thanks Ashish Sir, For such nice solution time Sorry for late reply On Tue, Feb 8, 2011 at 8:23 PM, ashish koul koul.ash...@gmail.com wrote: try this On Mon, Feb 7, 2011 at 9:10 PM, maulik desai mauliksde...@gmail.comwrote: Hello sir please provide me the correction in your macro

Re: $$Excel-Macros$$ columns into rows, with a twist

2011-02-17 Thread RFisher
Hi Ashish, Sorry I'm really new to google groups. How do I send the sample workbook? Can I post it here somewhere? Thanks and sorry to ask so many questions. Ryan On Feb 16, 8:19 pm, ashish koul koul.ash...@gmail.com wrote: can you please send  the sample workbook On Thu, Feb 17, 2011 at

Re: $$Excel-Macros$$ columns into rows, with a twist

2011-02-17 Thread ashish koul
send a mail on excel-macros@googlegroups.com and attach the workbook On Fri, Feb 18, 2011 at 5:43 AM, RFisher fishe...@uregina.ca wrote: Hi Ashish, Sorry I'm really new to google groups. How do I send the sample workbook? Can I post it here somewhere? Thanks and sorry to ask so many