overwrite

Hi The simple macro below works fine but asks to overwrite, which in this instance is an unnecessary delay. I will use this macro 100s if not 1000s of times so would really like to solve this issue. Any help really appreciated Sub savepreset() ' ' savepreset Macro ' '...

Hello, I would like some help with some VBA to overwrite a cell. In the first worksheet, I have a list of vocabulary covered in Term 1 (worksheet called "Term1"), with a difficulty rating assigned to each word. There will be other worksheets called, eg "Term2" and "Term3". <tbody> Word...

I have a template Excel file with multiple sheets. Each sheet is Protected (for formula-based cells & graphs), with unprotected areas to enter data. Each sheet has some "dummy" data loaded in the unprotected areas as a reference for users. Users are having an issue whereby if they delete the...

I have the following code to create and save a new workbook. If there is a file that is already open by the same name, I get an error. Is there a way I can force it to close the open file and automatically overwrite the previous file with the same name? Where DirPath is string indicating the...

Hello Everyone, I've been searching for a few days for the solution to my problem, but nothing fits the bill. Imagine a system for recording Invoices. The invoice number cannot be re-used, and must not change after it has been entered (or rather, looked up from a counter). Is there any way to...

I want to set a custom number format for a set of numbers that appears like this: "0000,00000,00000" So they are separated by commas into groups of 4, 5, 5. However when I try to set this, Excel keeps thinking I mean groups of 3 (standard number separator) and wont' let me set it to what I...

I wanna overwrite my active workbook Any ideas? Application.EnableEvents = False filename = Application.GetSaveAsFilename ThisWorkbook.SaveAs filename & ".xls" ThisWorkbook.Saved = True Application.EnableEvents = True I have this few lines of codes.However , it...

I am trying to build a form to submit data to a second worksheet (basically a database) but would like to be able to recall existing entries to update. I cannot figure out how to overwrite an entry with a given field. So sheet1 has 12 cells and sheet2 will have 20-30 entries, each row having...

Good Day all! Here is the situation I have data in single rows, about 60 col wide and each row has a unique serial # I need to open a master database, and copy the rows in the first file into the db That is all simple enough, but: If there is already a row in the master db with the same...

Forgive me if this question has already been asked, but I can't find an answer anywhere. Seems to be plenty of info about how to save and overwrite a file that already exists, but I need the opposite. Just a simple save as, and if there is no file, then I want to save it with xxx, but if the...

Hi there. It has been years since I wrote my last VBA code, and hence I would really appreciate some help. I've searched forums, but no matter what I do I can't get the examples I find to work. I feel kind of stupid and assume that this is a very simple problem, and I would be grateful if...

We I run the below code: Sub Macro1() Sheets("Historyt").Select Sheets("Historyt").Copy Before:=Workbooks("Merg.xlsm").Sheets(1) End Sub and a worksheet called "Historyt" already exist in the file Merg.xlsm it always create Historyt(2). I dont want that. I want is to overwrite...

Hello, hoping I can get some help with this problem. I am trying to make it so I can copy some data in an excel worksheet and transfer it to an existing table in Access. I was this to overwrite all the data in the access table with the new information from excel. I would like all of this to be...

(Why hasn't Access fixed this? It's been a problem since the beginning of MS Office!!!) I'm tracking calls to customers. So I've got a form including customer info (name, address, etc), and a subform within it for recording call data (date, caller, result code [1-10], notes, etc). The top form...

This is not a VBA question. We switched to 2007 just last Summer (I know, don't ask). We have noticed that for files created in Excel2007, when the file is opened, it creates a temp file in the same directory with today's date and the original file is still shown separately with the original...

Hi there, I have a workbook: Sheet1: Has all the calculations and output graphs - I'm using it as a data processor really. Sheet2: Source data for the calculations in Sheet1. I have multiple other tests (test1.csv, test2.csv) which I'd like to copy and paste into Sheet2. The problem is, is...

Hi, I have an issue with a macro that I do not know exactly how to solve, and hope there are some clever heads out there that can help me out. Just a quick input on what I'm currently doing: I have a monthly report that contains loads of numbers. These are numbers per city per month per...

I have a macro running that creates a new version on each save and then overwrites a master file. It’s a way to handle version control so that I always have access to the revised versions and the master is always the latest file.<?xml:namespace prefix = o ns =...

Hi everyone, I have my VBA code running like I want. The problem is that the spreadsheet I am making the macro for is overwritten every week with the new weeks data added on to it. I am not in charge of the process of overwriting. Is there a way that I can make another macro to give to the...

Hi, This is my first real userform since leaving college 3 years ago and I must've forgotten 90% of what I learnt. I've made a simple userform for my company to manage their stocktake with but for some reason it occasionally doesn't input the data on the worksheet, or overwrites the previous...