$$Excel-Macros$$ Re: Idle timer that saves, closes and logs off user after 5 min

HI Lalit Thanks for the link. I had seen this post before tried it, it logged off ok, but no timer. Now that I revisited the site (thanks to you) I noticed a web address in the discussion text for the original thread. It *did* have a timer and now the problem solved! Guess I didn’t see it at

Re: $$Excel-Macros$$ Help needed in Excel

Thanx for your great help. Only one issue - I was able to merge the contents of the 2 columns as needed by me. But when I paste the content of the resultant cell in a text editor I get " " in the beginning and the end of the text. Why is it appearing and how to prevent it from appearing? On Tue

Re: $$Excel-Macros$$ check date on open file

Try code in ThisWorkbook Private Sub Workbook_Open() If Now() > #8/14/2013# Then End If MsgBox "HELLO NEW DAY" End Sub 2013/8/14 pawel lupinski > thanks Mate working great. > regards, > Pawel > > *From:* De Premor > *To:* excel-macros@googlegroups.com > *Sent:* Wednesday, August 14, 2013 11:

Re: $$Excel-Macros$$ how i can heading text in a list box

Thanks Van for your reply, but i need to add header text by vba code, where item will be add on user need at run time. On Wed, Aug 14, 2013 at 9:57 PM, Bé Trần Văn wrote: > Select the data and put it to one name, such as *DataList*, Copy *DataList > * name in the Properties window and paste it i

Re: $$Excel-Macros$$ how i can heading text in a list box

Select the data and put it to one name, such as *DataList*, Copy *DataList* name in the Properties window and paste it into the RowSource. 2013/8/14 Divaker Pandey > > > hi expert, > > please help me to add heading text in a list box. > > Thanks & Regards, > > Divaker > > -- > Are you =EXP(E:RT)

Re: $$Excel-Macros$$ Pivot Table Running Balance - Grand Total

Respected GopiNath, Please check the following youtube video for your answer http://www.youtube.com/watch?v=Rr9dK5bDWcE Regards, Vijaykumar On Wed, Aug 14, 2013 at 3:09 PM, Gopinath wrote: > Dear Shri Satendra Kumar, > Thank you for your suggestion. However, what I wanted is "Running > Bal

$$Excel-Macros$$ how i can heading text in a list box

hi expert, please help me to add heading text in a list box. Thanks & Regards, Divaker -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use con

Re: $$Excel-Macros$$ Macro for COPY Paste

try this see if it helps Option Explicit Sub merge_multiple_workbooks() Dim fldpath Dim fld, fil, FSO As Object Dim WKB As Workbook ' SHOW FOLDER DAILOG BOX With Application.FileDialog(msoFileDialogFolderPicker) .Title = "Choose the folder" '.InitialFileName = "c:\" .Show End With On Error Resum

$$Excel-Macros$$ Macro for COPY Paste

Dear All I want a macro for following 1. I receives workbook (4 to 5) every week 2.Work book contains only one sheet 3.I stores all this in a folder 4.I want a macro which will open folder and open workbook one by one 5.Copy a particular range (eg Range B5 To B20) from every workbook 6. Paste all

Re: $$Excel-Macros$$ check date on open file

thanks Mate working great. regards, Pawel From: De Premor To: excel-macros@googlegroups.com Sent: Wednesday, August 14, 2013 11:07 AM Subject: Re: $$Excel-Macros$$ check date on open file Try This Private Sub Workbook_Open()     If Now() > #8/18/2013# Th

Re: $$Excel-Macros$$ check date on open file

Try This Private Sub Workbook_Open() If Now() > #8/18/2013# Then AnotherCode Else CurrentCode End If End Sub Sub AnotherCode() MsgBox "This Your Another Code" End Sub Sub CurrentCode() MsgBox "This Your Current Code" End Sub On 14-08-2013 16:45, pawel lupi

$$Excel-Macros$$ check date on open file

Hi All,   is anyone can help me on this:   I'd like to run macro base on following criteria: when I open file, macro is checking today's date and if today is greater than e.g. 18/08/2013 macro is execution another code.   if anyone give me some few lines of the code I'll be appreciated.   Regards

Re: $$Excel-Macros$$ Pivot Table Running Balance - Grand Total

Dear Shri Satendra Kumar, Thank you for your suggestion. However, what I wanted is "Running Balance" for each Bank - Datewise as well as "Grand Total Balance" available for each Bank, both in One Column of the Pivot Table. Thank you once again for your assistance. Gopinath A K On Tue, Aug 13, 20

Re: $$Excel-Macros$$ Screen Updating

Ok. Tx Sent from my BlackBerry® smartphone from Airtel Ghana -Original Message- From: vba Sender: excel-macros@googlegroups.com Date: Wed, 14 Aug 2013 10:32:51 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Screen Updating This me

Re: $$Excel-Macros$$ Re: Run time error 6

Hi, Got the solution for this problem I have declared variable to integer then I changed it to Long. Now macro is working fine. Thanks, Chandra On Wed, Aug 14, 2013 at 10:25 AM, Lalit Mohan Pandey < mohan.pande...@gmail.com> wrote: > Instead of sharing Screen shot it would be nice if you can s