saved

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

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

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

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?

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

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

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

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

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

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

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

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

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

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

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

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?

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

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

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?