file

  1. P

    VBA: Following Hyperlink that's linked to Sharepoint?

    I've got a list of Hyperlinks, that are all files on a sharepoint site. When I click on one, it opens Microsoft Edge and at the bottom asks if I want to open the file. When I click "Open", the file then opens in the appropriate desktop app. I'm wondering if there is a way around Microsoft Edge...
  2. A

    Add a file to the "Recent Items" listing in Outlook Attachment

    I have an Access program file that manipulates files that are on my network/pc. When I work with an excel file for example, I want to have Access add that file to list of recent Items using VBA. That way, the file that I manipulated in Access is right there in my recent items list so I can...
  3. M

    CopyPaste data from multiple excel files

    Hi Team, I need a macro to Copy and Paste (values) data from multiple excel files to Common Excel file. I have below files which need to get pasted in Main.xlsx file I have a New file called CopyPaste where I will update the file names and range details of copy and paste as below...
  4. D

    Strange "Out of Memory Error" on Close

    I have two files open. Both are pretty complicated with lot's of graphs, Shapes, pictures and formulas. File2 is the Active Workbook. When I simply Save File 2 from the "File" tab - No problem Then, I have a "Button" on File2, that calls a macro in File1, simply: Sub CloseFile2()...
  5. D

    VBA for File save-as XLSM with user folder selection

    Hi, I have a large macro that asks the user to save the file vbYes/vbNo File name is coming from combo of cells in the file I want the user to select a folder on the network. It should ask to overwrite if file exist. It must save as XLSM. I've been trying to get ActiveWorkbook.SaveAs going...
  6. F

    Corrupt/Damaged File Won't Open

    One of my regular (almost daily) excel (.xls) files will not open today. I get this message: "Sorry, we couldn't find D:\Daves Data\....blah.xls. Is it possible it was moved, renamed or deleted? When I ran CHKDSK the result for the file in question says that "first allocation unit is not valid...
  7. S

    Stopping workbook being copied to desktop

    Hey All, I am wondering if someone can help. Is there a way that if a file is copied or moved to a location other than the one i set in-bedded into the VBA it will pop up a message saying "Workbook should not be moved or copied from shared location". And then close? Reason is i have created a...
  8. L

    Temp File Folder in MAC vs Windows

    Hi Experts! I have a line item in my vba that saves an excel file in a temporary folder and then attach in an outlook email. It perfectly works on a normal laptop but when my co-worker tried it in his mac, the vba is debugging showing a run time error '1004': Microsoft Excel cannot access the...
  9. Y

    Find and replce takes 5-6 hours

    Like any software developer, when I make significant changes to my spreadsheet I increment the version (So Ref Stats V7 becomes Ref Stats V8. I then have to change the references in one sheet for a couple of different files. Each file takes up to 6 hours to replace the references. (There's about...
  10. R

    Macros disappeared!

    Hi I have a reoccurring issue with a daily EXCEL file I prepare. Quite often I will open the file after it has been prepared earlier, and all the macros that were stored in the workbook will have disappeared. Any suggestions for how I can rectify this situation? Kind Regards RUMPOLE
  11. B

    Format 51

    Good Evening Looking for some assist here. I am saving a workbook whichcontains several worksheets. When the new file is created there are two issues. 1. Message indicating to save the new file as an xlsx not amacro enabled file. 2. The new Worksheet the sheets have been grouped. How...
  12. K

    Excel formula reverting back to blank once i double click on individual cells

    Please see file below. Any help would be appreciated.
  13. G

    Run-time error 438. Object doesn't support this property or method.

    Hello. I was unable to find any leads on this by searching. I have a workbook with a sheet containing several combo boxes. The combo boxes are populated by code in the This Workbook module when the file opens. Some people can open the workbook without problems. Some other people get a...
  14. DataBlake

    Dictionary Overlap Problem

    Hey i'm having some trouble identifying an issue with a dictionary that is returning a key its not supposed to have I've checked over my code 9 times and tried isolating the problem by commenting out the 2nd dictionary that's causing the problem to no avail. I have a sub that opens a workbook...
  15. A

    Some VBA to beat a repetitive task

    Hi All, I have a task that's very time consuming that I was hoping I could get help with some VBA code. I don't think it's all that complicated, except maybe for the pop-up box I was envisioning, that's a bit beyond me. I'm just not that quick on my feet to get it all written myself. I have...
  16. A

    Mail merge with excel

    I use excel spreadsheets (xls, DDE) as the database for my mail merge in word. After the upgrade to Word 2016, the excel open a new file (Book2) automatically when I open the word file. The main problem is that when the new excel file (Book 2) was opened, all the previous entered data was not...
  17. G

    SaveASUI doesn't work as it's being called by another macro

    Hi all, I have a file that my users are not permitted to save, but I want my staff to be able to modify and save. I have an old macro from mikerikson which works if my team or I wants to save this master file and enters the appropriate password, thus: Private Sub Workbook_BeforeSave(ByVal...
  18. B

    Changing the month in a sheet name

    I have several files that I use every month. I have two sheets which include the current month that I am working on. For example, I'm starting the November file and I need to rename a couple of these sheets from Sept to Oct (I do commissions so we I am preparing the Oct commissions to be paid...
  19. M

    Reference an outside workbook and cell location

    Hello, I saw similar functions with INDIRECT but could not get any to fit my needs (even combining with concatenate) In A1 through A20 I have file names. In A35 I have the file location. So I use concatenate(A35,A1,”.xlsx”) to get the file and location and location in the file (sheet1 C9) I...
  20. V

    Copy active sheet range and paste into new workbook

    I've seen various threads where many different variations of what I'm trying to do are explained but all seem to be just a tad bit different. What I'm trying to accomplish is write a script that will copy columns A:L in the active worksheet and paste into a new workbook. I would also like to...

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