Re: $$Excel-Macros$$ How to clear clipboard effectively?

'Enable & Disable cut copy paste windows api ''module code Option Explicit Sub ToggleCutCopyAndPaste(Allow As Boolean) 'Activate/deactivate cut, copy, paste and pastespecial menu items Call EnableMenuItem(21, Allow)' cut Call EnableMenuItem(19, Allow)

Re: $$Excel-Macros$$ How to clear clipboard effectively?

Have you tried turning off the Office Clipboard: [image: Hide All]Hide All 1. On the *Clipboard *taskpane* * click *Options*. 2. Clear the *Show Office Clipboard Automatically* check box. 3. Clear the *Show Office Clipboard When Ctrl+C Pressed Twice* check box. **Cheers! AJ On T

Re: $$Excel-Macros$$ How to clear clipboard effectively?

Thank you, Kavita, for your help. I placed the code in Private Sub Workbook_SheetSelectionChange() and also run it under a sub, but still cannot stop the copied object to appear on the clipboard or clear the clipboard. It seems like wheneve the clipboard pane is displayed, there is no way to stop

Re: $$Excel-Macros$$ How to copy a range from another sheet

Thanks mate.. It works Harpreet Gujral On Mon, Mar 8, 2010 at 12:58 PM, rf1234 rf1234 wrote: > Dear gurpreet > Have a look on following code. > >

Re: $$Excel-Macros$$ Need of VBA

If I follow your question correctly, you're asking:  "why would I need vba?" the answer is directly related to time, and repetition. At our location, we had an employee that spent 2 MONTHS gathering and organizing data related to Access Control for file shares Then, generate 228 reports of nearl

$$Excel-Macros$$ Need of VBA

Hi, Good evening to all, I am working as a RTA (Real time analyst) in FIS, my job is to Prepare data for a team of 80 members in excel, i am looking for a job of analyst. Can anyone one tell me what is the need of VBA or why VBA is required when i can complete my all tasks in excel. Sunil -- -

Re: $$Excel-Macros$$ A macro that closes and saves the open excel project

Dear Sacha, Open VBA > ThisWorkbook and paste this code - *Private Sub Workbook_Open() Application.OnTime TimeValue("20:20:00"), "Close_and_Save" End Sub* Now modify your Close_and_Save module as below - *Sub Close_and_Save() Application.OnTime TimeValue("20:20:00"), "**Close_and_Save**" A

Re: $$Excel-Macros$$ A macro that closes and saves the open excel project

Hello Dear Please explain briefly or attached sample copy with detailed comment,so that we can help you accordingly. What you meant to do with transform. Hope it Will Help Happy To Help :) Shyam. On Mon, Mar 8, 2010 at 6:01 PM, Sach1810 wrote: > Hi, > > I would like to transform the following

Re: $$Excel-Macros$$ Excel Index Query

Hi Malek, Please check the attached file. I've used Sumproduct. Let me know if it solves your purpose or you need any further help with this. Cheers! AJ On Mon, Mar 8, 2010 at 4:27 PM, wrote: > Please find attached my query, can anyone solved my query?? > > > > Thanx in ADVANCE. > > > > M

Re: $$Excel-Macros$$ DD/MM/YYYY Excel Query

Hello Dear date format 01/10/2009-31/10/2009 i.e date/month/year-date/month/year is not feasible. Hope It will Help Happy To Help :) Shyam On Mon, Mar 8, 2010 at 4:22 PM, sachinp1...@googlemail.com < sachinp1...@googlemail.com> wrote: > Hello Members, I want help regarding this in which we re

Re: $$Excel-Macros$$ Create Multiple copies of the same file and rename as per a list

Hello Dear, Try to savecopyas ''' Sub Saving_A_Copy_Of_Workbook() Dim i,

$$Excel-Macros$$ Re: DD/MM/YYYY Excel Query

Hi Sachin, You may use below formula to get desired output : =TEXT(DATE(LEFT(B1,4),MID(B1,5,2),MID(B1,7,2)),"dd/mm/")& "-"& TEXT(DATE(MID(B1,12,4),MID(B1,16,2),MID(B1,18,2)),"dd/mm/") * The above formula use the input in cell B1. Let us know if any further help is required. Best Regards

$$Excel-Macros$$ DD/MM/YYYY Excel Query

Hello Members, I want help regarding this in which we receive the data in below mentioned date period format.where we have to convert in actual dd/mm/ format manually. Is there any shortcut formula to derive this ? Requested to send the same as early as possible, if any. Actual Data

$$Excel-Macros$$ A macro that closes and saves the open excel project

Hi, I would like to transform the following macro so that it will work at a set time Sub Close_and_Save() ActiveWorkbook.Close SaveChanges:=True End Sub help would be much appreciated thanks Sacha -- -- Some imp

$$Excel-Macros$$ Excel Index Query

Please find attached my query, can anyone solved my query?? Thanx in ADVANCE. Malek DISCLAIMER: Please note that this e-mail and its attachments are intended for the named addressee only and may contain information that is confidential and privileged. If you have by coincidence or m

Re: $$Excel-Macros$$ How to copy a range from another sheet

Dear gurpreet Have a look on following code. '' Option Explicit Sub Copy() Dim wb As Workbook Dim ws As Worksheet

Re: $$Excel-Macros$$ How to clear clipboard effectively?

  Hi All,   You can try the following code in vba to clear clipboard.        Dim ClipBoard As DataObject Set ClipBoard = New DataObject ClipBoard.SetText "" ClipBoard.PutInClipboard   Regards Kavita --- On Thu, 4/3/10, Excel 009 wrote: From: Excel 009 Subject: $$Excel-Macros$$ How