overwrite

Hello, I have two sheets, first of them has a data table with the income of a list of 14 companies during 2018 and 2019. The other sheet I've a data table with a list of these companies and next to the name an hiperlink. When it's selected, it transports you to the cell located in the row of...

Hello All, I'm looking to copy the data cells A28:N46 through to the range of A58:N106 with a button click macro without deleting any data that had previously been put into the range of A58:N106. + I would also love to be able to then clear contents on the data that was copied if possible. So...

Hello, I need help on VBA for the following requirement. Pop up message with 3 button of choices 1. Overwrite file 2. Save as different file name 3. Cancel operation. Thank you so much for your help. Cheers..... Sasils

Folks, I wrote some VBA code to save files with a certain naming convention. However, the overwrite warning is not showing up and I would like it to. Below is my code. Thanks! 'save as dialog Dim fname As String fname = "Wafer " & WID & ".Ellpis." & ReadType & "." &...

Hello, I am building forecast model and want to be able to forecast with formula inexcel, hard code or a formula in a macro. The spreadsheet it set up sothe user can update it with a hard coded number or enter a formula. However, I would also like to be able to adda macro that will overwrite...

Hello, I am building forecast model and want to be able to forecast with formula inexcel, hard code or a formula in a macro. The spreadsheet it set up sothe user can update it with a hard coded number or enter a formula. However, I would also like to be able to adda macro that will overwrite...

Dim myURL As String myURL = "http://test/Fxrates.xlsx" Dim HttpReq As Object Set HttpReq = CreateObject("Microsoft.XMLHTTP") HttpReq.Open "GET", myURL, False, "username", "password" HttpReq.send myURL = HttpReq.responseBody If HttpReq.Status = 200 Then Set oStrm =...

Hi there, I try to overwrite a file when I save it. I have put the following code but it doesn't work, it asks me if I want ro replace the file. Application.DisplayAlerts = False I have also tried ActiveWorkbook.Application.DisplayAlerts = False Here the full code ActiveWorkbook.SaveAs...

Hi Guys, Can someone assist with this issues that I am having, Right now I have this on Excel in columns FGH and I have it filtered by 1090150 in column F for now for simplicity. <tbody> F 1090150 G SP33 H SP33 1090150 SP33 1090150 SP33 1090150 SP33 1090150 SP33 1090150...

Hi, I have the following formula.. =IFERROR(IF(ROWS($1:1)<=COUNTA('Pre-Packaged Beer'!A:A)*2,INDEX('Pre-Packaged Beer'!A:A,MOD(ROWS($1:1)-1,COUNTA('Pre-Packaged Beer'!A:A))+2),""), "") Which cycles through a list of products twice... Is there anyway of adding to this formula so that if the...

Good afternoon, After loads of googling I can't solve the problem I'm having. I want to (as the title states) copy data from one table to another where the second table is on a separate sheet. In the case where there is already data in the second table, I want to wipe out the table and paste...

Hi Guys, I have the below code which works great but is there a way to overwrite the files if they already exist Sub Run() Dim ws As Worksheet, newWb As Workbook Application.ScreenUpdating = False For Each ws In Sheets(Array("Bethan", "Hannah")) ws.Copy Set newWb = ActiveWorkbook...

I feel like there has to be an easier way to do this than what I have tried so far. I have working code that copies a table's values into a 2D array. The table is 10 columns wide. What I am doing is copying the table into this array and doing some calculations and sorting on it. What I need...

Hey All: Total newb to macros question, so please be patient, trying to learn I recorded a macro that opens and formats a worksheet then saves as a .csv and .xlsx in a specific file path. I sandwiched this recoded macro inside an Application.FileDialog. The problem occurs when running the macro...

Hello I am in need of your help, I am trying to add a message box popup in VBA that when a user selects file>save or ctrl+s, it prompts them with a message box that states "Do you really want to overwrite this file?" Yes button to continue to save, No button to cancel and close the message box...

Hi All, I have some code which takes some data and then matches it to a specific column and then inputs that data on the next available row. What I want to happen is that when the data gets to 8 rows, I would like it go back to the first row in that column and overwrite the data back to the 8...

Hi All. I have some code below, which always errors on the paste special line. If anyone can help i would appreciate it. It basically copys data from a hidden sheet and pastes the values into another sheet (which is determinted based on the value of a cell). Sub Export() If MsgBox("Are you...

Hello I need one cell to hold this formula: =if(a2="A","Yes",if(a2="B","No",if(a2="C",(dropdownlist with 3 values to select from) When a2 = C then the drop down would be available and if the user selects one of the 3 options but changes a2 to B it does not overwrite the formula.

Hi, I've seen some similar posts, and attempted to tweak the VBA in order for it to work for mu purposes, but I am relatively new to this and I haven't come up with anything that works properly yet. I am looking to search through my workbook (quite a few sheets) to select and hard code all...

ActiveWorkbook.Save ChDir "C:\Users\mikec\Documents\XL" ActiveWorkbook.SaveAs Filename:= _ "C:\Users\mikec\Documents\XL\Budget Personal.xlsm", FileFormat:= _ xlOpenXMLWorkbookMacroEnabled, CreateBackup:=False I created this macro to backup my budget. It works, but when...