overwrite

  1. M

    Hyperlinks in data table

    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...
  2. N

    Copy and Paste without deleting existing data

    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...
  3. S

    [VBA HELP] Save file prompt to overwrite, save as or cancel

    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
  4. D

    Overwrite Warning Not Showing Up

    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 & "." &...
  5. V

    Forecast Macro

    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...
  6. V

    Forecast Macro

    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...
  7. D

    saving file not working from web site

    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 =...
  8. T

    Overwrite file with same name

    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...
  9. K

    Repeating cell and overwrite

    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...
  10. P

    formula to overwrite blank lines

    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...
  11. T

    Copying and Overwriting Data from one Table to Another on a Different Sheet VBA

    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...
  12. T

    VBA Save as and overwrite file

    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...
  13. J

    Copy Parts of Array to Certain Table Columns

    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...
  14. G

    Workbook.Saveas Filename issue

    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...
  15. J

    Overwrite msgbox Yes/No issue

    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...
  16. S

    Overwrite data once certain value is reached

    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...
  17. G

    Code error helppp!

    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...
  18. L

    If then with last then being a drop down box with multiple selections

    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.
  19. C

    Using VBA to search workbook and hard code cells containing specific formulas

    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...
  20. mikecox39

    Save Macro didn't answer "already exists" prompt

    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...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top