1. 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
  2. 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 & "." &...
  3. 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...
  4. 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...
  5. 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 =...
  6. 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...
  7. 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...
  8. 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...
  9. 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...
  10. 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...
  11. 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...
  12. 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...
  13. 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...
  14. 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...
  15. 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...
  16. 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.
  17. 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...
  18. 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...
  19. H

    Macro Automatic 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 ' '...
  20. R

    VBA to overwrite cell value using INDEX MATCH and INDIRECT

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

Some videos you may like

This Week's Hot Topics