macro - autosave

I have created an excel spreadsheet to use as a template for documentation. I have locked the workbook from being changed, with the exception of the cells that need info entered. I then added a macro the counts up every time the file in opened, with the password protection being unlock then...

Hello Please I need someone to help in this!!! I need to add data from excel cell to a ALREADY OPENED web page field.I want to assign file to agents daily for them to review and I am wasting a lot of time in my work by entering this data. I attached a excel sheet to understand you what and...

Hi All Gurus I have a small requirement, which is definately something I am unable to fix myself. I have a workbook, with several worksheets. i want a macro which saves all worksheets of my workbook as a seperate workbook. While saving it, I want the macro to name the workbook as existing...

Hi All, I am looking for a macro which will save out the DATA RANGE as a '.txt' file and for the filepath to be a msgbox pop-up for the user to browse and pick the correct folder to choose where the new '.txt' file should be saved. The new '.txt' filename can be "test". DATA RANGE: starts in...

I am using the below VBA within an Excel .xltm file to save the destination file as a .xlsm file. My problem is that when I open the.xltm fie a second time it overrides the .xlsm fle that it saved the first time I opened the .xltm file. Is there something I can do so that the .xlsm does not get...

Hello! i'm hoping someone can help me as i know the solution to my problem can be solved via a macro of some sort. I have a spreadsheet that containing 3 tabs, sheet1 sheet2 and sheet3. Sheet1 only has data in column A which is the unique values of my data range... there are over 100...

I have an issue whereby every time I attempt to run the macro I've created, the locations I've saved the workbooks to have the existing name of the new updated files, and hence a dialog box appears every time with the 'would you like to replace this...' command. How do I resolve this issue...

Hi guys, I am trying to figure out this macro and can't seem to make it save correctly. I am trying to save this selection to pdf and then make it save the filename as "O'shirts Estimate (value of cell 4f and the current date). It only saves the file as this O'shirts Estimate & WST Screen...

Hi All, I am in desperate need of a macro that can save out a particular worksheet from the current workbook to a new workbook. In addition to saving out this worksheet to its own new workbook, I would like the macro to also value out (remove formulas from) everything except for a specific cell...

Hello Guys, I have created a macro which basically put data from one excel file to main file and than save the main file on desired location. I was using windows XP previously and the macro was working fine. Below is my problem description. Windows XP : After starting macro, it collects data...

I am hoping someone could help me with this, or at least direct me to where I would find help. I have a workbook with about 500,000 rows of data, I need the data divided up into workbooks each containing 300 rows of the data. So I have one workbook with 500,000 rows, I need 1666 workbooks...

Hello, I have 2 days that i try to do this and it just wount work" I have a worksheet called "Menu" that contains in column A each name of the 680 sheets that are in the file. each sheet has same structure-containing daily actions made on that sheet : sheet384: h55="24 Dec" g55=210100...

Dear All, Marry Christmas !!! I have an excel file in which i have a table which is linked through query from another excel. What i want is a macro which should running in the closed workbook to save it automatically in every 1 minute, so the the data refresh in every 1 minute. Thanks,