Recent content by kevinonearth

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