macro - run

Hi, I've been working on creating a macro to merge data from multiple worksheets to a "master" and found a script that works but rather than putting each sheet's data at the end of the previous it's overwriting it. Does anyone know how to fix this script so it puts the data at the end of the...

Hi, I was wondering whether you can run a macro in workbook 1 upon the event of another workbook (2) opening. For example I click a button to open a webpage withing Workbook 1, I manually manipulate which data on the webpage I want to download, and upon the download it always opens a .CSV...

The userform uses DTPicker from the additional control selection to input dates but it is not present when my colleagues run the Userform code! I have constructed a Userform to collect text, numerical and date information from my colleagues. A forum post suggested DTPicker to ensure consistent...

Hi All, I'm new to doing macros but I'm picking up on their usefullness as i go... I've created a spreadsheet that will be kept on the company server in the templates folder, but to prevent people editing it I would like the "Save As" dialog box to open every time the sheet is opened, that way...

Hello All, Thank you for everyone who has helped me with my current project. It is really appreciated. I do however have one more question and I promise to leave everyone alone. How do you allocate a button (from the control toolbox from the toolbar) to run a macro when clicked?

Please pardon me if these seem like foolish queries, I've been using Excel for years, but the cat knows as much about VBA as I do. My issue: I am constructing a series of macros to format a complex input form that I'm designing to price projects. The macros hide various rows and worksheets if...

I need a macro that replaces all spaces with underscores AND deletes all parenthasis and dashes. For example, <TABLE style="WIDTH: 372pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=496 border=0><COLGROUP><COL style="WIDTH: 372pt; mso-width-source: userset; mso-width-alt...

Hello: I have a macro inside an excel 2007 workbook. I would like to know how I can run this macro from outside excel in a silent mode. I need to run the script (batch or vba) on an scheduler to clean a file that will be imported into access. Thanks in advance for your help. Frank.