macro help

I seen a macro that if the workbook set idle or was left open for a set amount of time it would save the workbook. I really need that macro or if someone can give me one I would really appreciate it. Thanks in advance

Hi, I am stuck up in following condition using macro... I have large data in worksheet having 200 Columns and 60 rows in "sheet1". Concept is - User inputs some number where that number's column only be visible and rest 199 columns and their data will be invisible. ( Eg - number entered 2...

Hi, Wondering if anyone can help with 2 macros I have that work but both have kinks that I would like to check 1) Number format macro ................ Selection.NumberFormat = "#,##0;[Red](#,##0);-;" This macro is for formatting numbers in a way I like. However if I inadvertantly use it on...

hi guys. kindly need your generous assistance for creating macro to open multiple files on particular folder. Whereas the file names should be opened are defined first on a worksheet. Then, i want to combine/merge the content of each file (all in sheet1) on different single sheet as summary. Is...

I'm trying to copy part of the text in a document then go to save as and paste that text as the file name. I'm not sure what the correct code is, and if I actually paste then the code just has the text as the file name. Can someone help me out?

I've done a handful of macros in excel before, but it's been awhile and I'm kind of blanking. I'm essentially looking to have a macro that will insert a blank row between each other row (a list of names with information, and I want there to be spaces between). Then I want it to stop when it...

I'm trying to create a macro that will analyze all my emails in Outlook, parse them to only pay attention to certain emails with very specific subject lines, then make a list of the emails for me, and open outlook and look at that email when i click an item on that list in excel. I can do...

I have two lists, both on separate sheets. They both contain ID numbers, but with different data in them. I want to know if there is a way to create a macro that will look up the id number in sheet 1, see if there is a matching one in sheet 2, if there is leave it alone. If there isn't I want it...

Hello, I'm trying to write a macro or formula that will sum the following =(D2+B3)-C3 on the first day of the month. I need this for each month. Each month will change, so for October 1 2008 I need it to sum =237+B2-C2 November 1 2008 I need it to sum =(D2+B3)-C3 December 1 2008 I need it to...

I am trying to create a Macro to Select all the cells in B:G And assign them the range name "List." But my macro won't work...I was wondering if somebody could tell me if there is something wrong with my macro...here's what it looks like: Sub MasterInventoryList() ' ' MasterInventoryList Macro...

What I am trying to accomplish is have a macro that runs from "personal" searches through multiple folders and sub folders, which are set up identical for all agents, and runs the predefined macro on each workbook in a folder with a defined name. What I would like the macro to open, run, save...

Hi Guys... I recieve a daily report that gets filtered onto a spreadsheet. What I would like to do is be able to set up a macro that would take this daily filtered information and insert it into a master sheet that holds 6-8 weeks worth of work. The issue I am having at the moment is that I...

Hi Guys... I really need some help... I receive a daily report as a txt file. Then I use: ChDir "C:\Users\Mon&Ant\Desktop" Workbooks.OpenText Filename:="C:\Users\Mon&Ant\Desktop\0.txt", Origin:= _ xlWindows, StartRow:=1, DataType:=xlDelimited, TextQualifier:= _ xlDoubleQuote...

Hello... Can an yone help me please? I have two excel files that laid out exactly the same. The two files are: MB.xls and CT.xls. I need to check each of the columns starting at C3 in the CT file with the column C3 in the MB file, if the rate if 5% less in the CT than in the MB (in C3 cell) then...

I created a database that is on our network and shared throughout our company that I am responsible for. Despite my advanced warnings that I needed everyone to be logged out of the database last night so I could do upgrades this morning, someone of course went home without logging out. I need...

I have a user-input sheet created with one cell set to control which image is displayed to the right of the table. To accomplish this, I simply stacked all the images and have a macro written to bring the appropriate image to the front. This works fine if I modify the trigger cell, but as soon...