Forum

Hi Maurizio, Can you please supply a sample workbook with data and expected results. It's too hard to guess exactly what you want without knowing ...

Hi Maya, Yes, then use Catalin's suggestion, an add-in will suit you better in this situation. Phil

Hi Dave, I had not seen this before but I can reproduce it. Also, if you leave A1 selected, click in the formula bar, then hit Enter, the data is ...

Hi Nina, Yes the workbook I provided has working event code in it. You just needed to put what code you want into that event handler/sub. But, ...

Hi Nina, The workbook I attached to my last reply contained the event code for you to use. You just need to copy the email code that you were alre...

Hi Maya, I'm a bit confused by your reply. The reference to PERSONAL.XLSB is added to the workbook that you want to use the function in. This f...

Hi Nina, Using Worksheet_SelectionChange the VBA is executed every time you move to a different cell. By using Worksheet_Change you can limit the ...

Hi Maya, This is a bit of a pain and another one of those things in Excel that you scratch your head at and wonder why they did it this way. Tha...

Hi Gene, Can you attach the document so I can have a look? Thx Phil

Hi Marilyn, Outlook stores all its macros in a single file called VbaProject.otm. This file is already part of your roaming profile and is located...

No worries, glad it worked for you. Yes the trailing slash must be included in the saveFolder, otherwise there's no directory separator Cheers ...

Hi Marilyn, You need some VBA to do this, and use a rule to trigger it. First open your VBA editor from within Outlook by pressing ALT+F11. On ...

Hi Sarfraz, Have you looked at this The sheet is attached as a PDF, as you have to save the sheet as something, maybe a PDF or a workbook. Phil

Hi rathanak, why don't you use the built in auto save features, rather than write VBA to do this? Regards Phil

Hi rathanak, In addition to SunnyKow and ConnexionLosts's answers you can read up on time calculations Excel Time Calculation Tricks Calculat...