file operation

  1. S

    Formula is pulling data from deleted file ? [or #REF error not showing up]

    So yeah I used basic cell reference to other workbook, then I deleted this workbook, but numbers stayed ? When I try renter this formula, all it asks me is to find file path, once I cancel it just take numbers from deleted file. I was expecting it to give an Error..
  2. S

    Have MsgBox show other button than Yes No Cancel

    So currently my code has vbQuestion & vbYesNoCancel. I am trying to figure out if I can replace Yes No Cancel with my own options. Preferably (not necessarily) without editing code too much. If Dir(FPath & "\" & FName & FExt) <> "" Then wAns = MsgBox("The file already exists. Do You...
  3. S

    Need a macro for save as with 2 attempts based on formula output

    I want to save as my file based on value in cell. This value is date calculated by formula. In the same time if this file already exists I want to add _2 to file name. This is what I have so far, but it doesn't work with Formula , neither I know how to add 2nd save as. (Sorry I could not find...
  4. NessPJ

    Variable file operations (move and rename files).

    Hi all, I am actually looking for a way to invoke a few file operations when working in Excel (Using VBA or so). Yet, i want the criteria for the files to be user customisable (the filename differs). (1) In detail, i have a folder with report files from a WMS/PWS server. This folder contains...

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