save as separate

there seem to be lots of codes for this out there and I'm really close to getting it figured out.. I have a workbook that has 26 sheets, I want to create a macro that saves all sheets as hardcodes (completed) and creates a draft email in outlook with each sheet as an attachment. Created a...

Hoping someone can advise me. Firstly for some advice. Can I do this in excel. Secondly: how do I go about it. This is for collecting data for a non-profit org. I have a "Client Analysis" spreadsheet that collects data. 1. I would like the Carers to be able to click on a client name, this...

Hi Excel gurus, I've been pulling my hair out trying to do a potentially easy code for some experienced people, if anyone can help! I'm looking to : 1) Open multiple file names from my F drive. Details - With the file name of "issue303661.txt" the following file would typically be consectuive...

Hi All, I think I'm going about this right but there's just something slightly wrong with my code.. I'm trying to have excel save a copy of my workbook to a specific directory when the active file is saved. Here's what I have.. Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel...

Hello! I'm trying to generate individual timecards for people based on data entered into a data range for a single week. I have a timecard worksheet that is filled with values from data on another sheet. I want to be able to create a copy of each persons' timecard and put them all into a new...

I have a workbook with payroll actuals data for all our managers to review and assure we are not making mistakes in our process and that we paid people the correct amounts. It is approximately 19MB large and is shared on a network drive that takes WAY too long to open. I want to: Export each...