Search results

Hi there, any one out there created a World Cup 2014 score tracker to use for an office sweepstakes? Thanks Kevin

Hi there, I've used this post by Hui: http://chandoo.org/wp/2011/02/17/printing-excel-reports-via-a-word-document/ to create my own word docs from Excel. But how do I set up the macro so that at the end the desired word document opens rather than just sits in the folder? Thanks Kevin

Hi there, I've used this post by Hui: http://chandoo.org/wp/2011/02/17/printing-excel-reports-via-a-word-document/ to create my own word docs from Excel. But how do I set up the macro so that at the end the desired word document opens rather than just sits in the folder? Thanks Kevin

Hi, thanks all for replies. It is working now Thanks again

Silly of me! Sorry password now removed! https://dl.dropboxusercontent.com/u/90990975/Timesheet%202014.xlsm

Hello, I have a workbook with 53 work sheets in it. 52 of these work sheets are hours worked and leave days taken for every week of the year. The 53rd sheet calculates the amount of days worked, leave days, sick days etc over the year by using...

Ok, this works, but what if the initial value is a date? I should have initially said that I wanted to take in a date value. Let me explain: I'm doing an employee time sheet for every week of 2014, I want to take the first Friday of Jan 2014 as the last day of the first week of 2014. I'm then...

I just realised that when I use option explicit and declare 'response' as a string I get an error, when I don't use option explicit it works fine Do you know why that is?

Thank you but an error message appears at: If response = FalseOr response = ""Then

Hi there could anyone help me with writing some simple code? All I want to do is run an input box which will take in a string and rename the active worksheet with that string

Ok, thanks, but having captured it, what is the code to use to email it? ' Save new file objWord.ActiveDocument.SaveAs cDir + NewFileName at this point do I create a new variable? And how do I get VBA to send it to outlook? Would it help if I attached the file here? Thank you

Hi Bobhc yes I've checked that already. What I'm really asking is when using the code supplied bu Hui here: http://chandoo.org/wp/2011/02/17/printing-excel-reports-via-a-word-document/ At what point can I capture the new word file generated and send it to the Outlook application? Thanks Kevin

HI there, I use Hui's VBA macro to generate a word document in a specific folder (http://chandoo.org/wp/2011/02/17/printing-excel-reports-via-a-word-document/) But what if I want to email the word doc rather than save it to a folder? How do I go about that? Thanks Kevin

Hi there, I've got a named range, a list of employees, it includes their title, name, address, employee number, contract start and contract finish date. It contains say 52 employees. I've named my list Emp_list But if I add a new employee to my list (number 53), how do I insure that they are...

Do I have to save my macros in personal folder or do I place the macro in the worksheet? I'm not quite sure how to manage my macros, how or where I should save them

Thanks for the reply but I've saved it as a Macro enabled workbook and I've enabled all macros on the recipient's computer, but they still get the same error message!

Hi, If I send a workbook containing a macro, it will not work on the recipients machine. How do I set up my workbook so that when I send it the macros will work on the recipient's computer?

Hello, how do I create a macro which will add the current worksheet I have open to a new email as an attachment? The to field in outlook can be blank. Any assistance greatly appreciated. Thank you

Hello, I've created a spreadsheet where I want certain cells to be password protected and non modifiable, simple, you would think. Unlock what you want to be able to modify and click protect sheet. However there is one entire column which I have verified as locked, that simply will not lock no...

okay thanks

Hi, thanks, yes I googled that too, but the link appears to be dead! Plus I'm hoping not to pay for it!

Hi, I'm trying to create a league for a tennis competition. There are 12 players, each player plays one different player every week. So 11 games over 11 weeks. Does anyone have a macro that can look at a list of 12 players and produce 11 lists where each player plays everyone else once? Thank you!

Hi, how can massive numbers be displayed in Excel? question broken down 29^289 = 7.2215E+413 now get the modulus of that huge number by 33 so mod 33 of 7.2215E+413 should = 8 but excel cant do it numbers max out at 109E+105 or somethinng like that See this file for a better...

Hi Narayan, that hasn't worked I'm getting 481 instead of 25. Thanks Kevin

Hi, I've a spread sheet which is meant to calculate the amount of overtime hours an employee has worked up over a year. The formula works fine until overtime hours worked exceeds 24 hours. For example: current overtime hours are: 22:00 Employee works another: 03:00 excel reverts to 24 hours...