saved

  1. B

    Extracing a value from one paticular cell in multiple workbooks and listing them in order.

    Hello, I have a workbook that records new files saved into a folder and generates a hyperlink to that file. In each workbook file that is saved there is one cell that advises if the value is Low, Medium or High ( in this instance cell is D3). I need my workbook that stores these hyperlinked...
  2. S

    How to fill a multiselect listbox from a cell

    Hi I have found this code on the net Dim arrItems() Dim cnt As Long Dim I As Long For I = 0 To ListGateWay.ListCount - 1 If ListGateWay.Selected(I) Then ReDim Preserve arrItems(cnt) arrItems(cnt) = ListGateWay.List(I) cnt = cnt + 1 End...
  3. C

    save excel file as copy to current folder VBA issue

    Hi, I wonder if anyone could help me please. I have a code below which saves the excel file as a copy to its current location and renames the file 'customer copy' This works fine the first time, but when a file with the same name exists in the current location and I chose the option 'No' or...
  4. J

    Calculating with numbers saved as text?

    Is it possible to calculate with numbers saved as text? Like for example a SUMIF-function so that the numbers to sum are saved as text? Or is the only option to convert the text to numbers first, and then to calculate?
  5. B

    Saving an Excel Template with Macros

    I need to create an Excel template for our admins but I have a couple of macros that I need to include for them. I noticed when I saved the the file as an xlt file the module with macro wasn't saved with it. The only workaround I can thing about is to export the macro that I have then have them...
  6. I

    Recovering previous data

    A coworker of mine made some changes to a workbook and saved those changes. She is now trying to recover the initial workbook (before she made the new changes and saved it). Can someone assist me with how to recover the old file. Thanks
  7. C

    VBA to copy Columns A-F into new work book keeping formatting

    Hi, I wonder if anyone could help me. I am trying to copy columns A-F into a new workbook and save new workbook in the current folder. I currently have the code below which does what I want except it copies the whole sheet, not just my specified columns Sub Customer Copy() ' Copy...
  8. M

    Distributing a Excell file with Macro

    I have a Excel file saved on my desktop which has a macro to import csv from another file saved on my desktop. I would like to distribute my excel file to other colleagues which will have both files saved on their desktop. My Macro refers to my user and user name Users\123456\, therefore I...
  9. T

    VBA to open .msg saved to Hard Drive

    I have a need for a user to click a button that will run a Macro that opens an outlook .msg file saved to a specific location. It's an email template. Just needs to open that .msg file in outlook that already has the To Address and Subject and partial body they can alter. I have code...
  10. G

    Save web page to Excel

    All, I have a situation where I saved a web page locally which has an table type data. Once saved I drag the html into an empty excel sheet I have a perfect excel page with beautiful icon ( png ) that represent certain values. The issue is : Once I save the page to xlsx and move the excel...
  11. P

    Saving old and new Excel files

    I have been using Excel for years. I have made changes and saved my files with no problems. I've created new files and saved them with no problem. Now no matter what I do, it will not save my changes or my new files. It says there is already a file by that name, but there isn't. When I try...
  12. E

    Difference in writing code in worksheets vs modules?

    What is the difference between writing your VBA code within the worksheet itself vs having it saved in a module (or class module)?
  13. C

    Link File to Multiple Workbooks

    I have a 'Summary' Excel file that is to read information from numerous other workbooks. These other workbooks are all set up identical. They are basically forms filled out by each employee (Name, address, education, experience, etc.) and saved in the same common folder. The 'Summary' file...
  14. V

    Need urgent advise on workbook lost

    Dear All, I have one workbook, very very mistaken, I delete the data and got saved....data was all about, employee presence and absence... can you all, who know, any possiblity, to get that file again before saved...Pls suggest..
  15. I

    Saving data based on time(not with vba)

    Hello first time poster here, I have a bit of a head scratcher here. I am trying to save data based on a time stamp that it was entered. I know if I where to use VBA it would be a simple matter of creating an array and updating it at certain time stamps. However I would like to avoid using...
  16. M

    Need my Personal.xlsb saved on a network drive instead of c:\\XLSTART - Possible?

    Need my Personal.xlsb saved on my network drive as we are required to use network drives for all files. I tried moving my file but it does not show up under View Macros. Is this possible?
  17. V

    Problem with macros

    Hello, Recently I started using macros and I automated a few tasks like formatting and formulas. However, I deal with large volumes of data ordered on columns and rows, in excess of 1800 rows. But the file I am talking about can have 1800 rows this month, 1765 next month or 1850 the month...
  18. G

    Delete File by Creation Date

    Hi, I am currently using the code below within the "this workbook" section to save a file to one location and also create a backup copy of a file to a different location adding the date to the end of the filename. "filename dd/mm/yy.xls" Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean...
  19. S

    Save button that indicates Save status

    In Notepad++, the Save button is "greyed-out" if there are "no changes" or the file has been "saved". This is kind of useful. Is it possible to do this in Excel 2010 somehow?

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