hi, i have some 2003 excel workbooks which used solver.xla. now when i open them in 2007 it says 'missing:solver.xla'. when i try to reference solver.xlam for this, it still gives me the error. what is the best way to resolve this? thanks
How to make a fully featured professional form in Excel that is unbreakable. This includes how to use the form to store, view, edit, and delete data from a data storage worksheet.
Send Emails from Excel using VBA and Macros. This course starts from the Basics and builds up to more advanced examples with attaching workbooks, worksheets, PDF's, automatically sending emails, including a signature, error handling, increasing speed, and more. Similar TopicsI have a given length of steel bar...Example(550 feet) I have various cut lengths that I can pick from... 14'-10'.....13'- 9'.. 12'-8'........(up to 6 different lengths) I need to know the best combination of lengths to cut the long bar into to have minimal scrap left when we get to the end of the 550 feet..... Cut as many of the longest cut lengths possiable.....Cut as few of the shortest cut lengths possiable Due to the fact that I will have to convert this to a PLC application when completed, I want to find a mathmatical way to do this inside excel and not use the 'solver'....Assuming that I/we can come up with an equation to do this ..... Any and all advice/help would be appricated..... Hi all, The following code is placed in workbook 'A' and is used to open workbook 'B'. These workbooks will now always be housed in the same directory and i want to change the code to use a relative path reference by determining the path of workbook 'A'. here's what I had: Sub income_statement() Application.WindowState = xlMaximized Application.Workbooks.Open 'C:Documents and Settings.....workbook B.xls', UpdateLinks:=xlUpdateLinksAlways End Sub could you suggest how to change this to use a relative path reference? Hi, I'm trying to get some macros to combine data from two open workbooks, and I can't figure out the commands to switch from the active workbook to the other open workbook and back. I'm new to VBA and just learning the ropes. All I can figure out is how to switch to another workbook with an exact name. If I record the macro to go to a recent file, for example Window > 1 (filename), the code that I get in VBA is Windows('filename').Activate. This doesn't translate to when I have two different workbooks with different filenames open. Make sense? I'm a bit confused myself. Maybe just a list of basic workbook-switching techniques or commands would be useful. - Michael I'm trying to open a pdf file from within excel vba. I have tried using the followhyperlink method but adobe acrobat opens very briefly then immediately closes Code: So then I tried to create an instance of acrobat by setting a reference to the acrobat object but I can't get this to work either! The code I'm using is Code: Any ideas what could be wrong with either approach? Thank-you I get the error message 'reference is not valid' each time I open my spreadsheet. I get this message three times, and once I am done clicking ok on all three of them, my spreadsheet works just fine. The problem is, I have to send it to a bunch people. I havea sheet with raw dataa sheet with pivot tablesa sheet with a dashboardand a simple macro I don't have any #REF cells either. Someone has any idea of what could be the problem? thanks NA
Hello, I have a number of different files that I often need to run a macro on. In order for me to do it on the 75-100 files I have at any given time, I need to open one, run the macro, close and save, then open the next one. Is it possible to write a macro that will start with the first file in a folder, open it and update links, run a macro, save and close, and open the next file in the folder until it has open all the files in the folder. I have experience with creating macros that reference different workbooks, but not sure how to go about opening files with different filenames (without referencing the exact filename). I'd like to be able to have basic code for opening, saving and closing, opening next file, saving and closing, etc. and input the macro I'd need to run in each file in the appropriate location. Is this possible? Any help is greatly appreciated!! Thanks, Jason I am a very advanced Excel user so this is a new one for me. When I open any spreadsheet (new or already populated) the black box that normally frames the active cell is missing (showing which cell you have selected). Likewise when I 'select all' the sheet does not become shaded. In addition: Can not fill series Can not change cell format (specifically to show Currency or Accounting w/$ symbol) And I am sure there is much more that I have not found yet. I have not seen a single thread on this topic anywhere on the internet. Help!
We have a number of Excel users in our office who cannot copy and paste between Excel workbooks. They can copy and paste between worksheets. When you highlight the section to copy and then go to the new workbook both the paste and paste special are 'grayed out'. This is true whether you right-click the mouse, go to the edit menu, or use control keys. This occurs with any data type and the most simple workbooks. I have seen some suggestions here but none have worked for this particular problem. I have reset the menus and renamed the .xlb files and neither helps. You can open the clipboard and the paste will work, but there is no paste special option. Any help would be greatly appreciated. Thanks!
Hi I need to open a password protected workbook using VBA. I've tried the code below but I still get prompted for a password. Code: How do I get it to open automatically???
I have an excel 2007 file sitting in a shared network folder. I only want one user to be able to make changes at a time (any other users would get a read-only). For some reason it currently does not do this, and I have multiple users with the same doc open. I'm concerned that changes will get over-written when 2 people are saving their changes. Can anyone help me with the settings for this.
I have a large spreadsheet in Excel 2007. I am converting it to a .csv file to import in to another program. I need to delete all commas from all data. When I try to replace all commas (with nothing or with another character), I get the error message 'The formula you typed contains an error.' I have tried various formats (text, general, etc.) and various file types (.xls,.xlsx, .csv) and still get the same error. Hello, As the title goes this is as simple as it gets. The macro worked good when I was using excel 2003 but now that I have 2007 everything works for except the resizing (Picture.Width & Picture. Height). Code: I have tried to record some macros while I am resizing the pictures but to no avail the macros are blank. Please help Thanks! I have excel sheets that cross link with each other. I've just migrated to Office 2007. When I open my excel sheet I always get the question at the bottom of the tool bar Security Warning Data connections have been disabled. And then I have to click on option and enable content. My question is, how do I always enable the content? Thanx I did a search in here but didn't find an answer so here goes nothing... I have a spreadsheet with data from A1 to H1 down to A275 to H275. I select all of it, Copy, go into the Sheet2 tab and select A1, Paste Special -> Transpose and it give me the following error message: Quote: The information cannot be pasted because the Copy area and the paste area are not the same size and shape. Try one of the following: - Click a single cell, and then paste. - Select a rectangle that's the same size and shape, and then paste. For the life of me, I can't figure out why it's not working! I have done this many times with other spreadsheets. Has anyone ever experienced this? If so, were you able to resolve it and how? Many Thanks, Mike
Hello I'm quite experienced Excel user. I've never come across this problem but tinkering in every conceivable way within Excel settings and the solution has eluded me. I have added a worksheet created elsewhere (it is a form I need printing, with the data coming from 2 sheets I have created from scratch) which has pre formatted cells for Date and Client Name etc. When I try to reference the cell in this added sheet from my 2 sheets, instead of the result, it always displays the formula, not the result. I have tried doing it from one of my sheets to reference to this new, and that displays the result and not formula. I can't imagine why it's doing this and I've never seen it happen before. Formatting cells, giving cells names rather than the usually adequate of reference to the Cell Number doesn't change things. I wonder if I've picked up some legacy protection from the original form but can't see anywhere in the tools etc that's obvious. There's about 50+ cells that need referencing and I got to get this done for work. Please help me. This is my first need to post on a Excel Forum as I've always found help or answers from other peeps or internet but this one is making me scratch my head big time.
Hi all, I've been getting this error on occasion recently. - It's a shared document - There is usually 10-12 people using the file at the same time I've read on the Microsoft Help site that the issue is that somebody is accessing the file while another is trying to open it. Is there a way, perhaps through VBA, that I can not allow a user to save while somebody else is opening the document? Other suggestions on how to avoid this error? Thanks! Hello, I have two columns of data: column A contains the date and time in the form dd/mm/yyyy. Column B contains a number value. All the times are in order, so column A looks like: 01/01/2007 02/01/2007 03/01/2007 I have data from 2007 to 2010. I need to calculate an average daily value (in column B) for each month, and display it in column C. So, for January, I need to calculate the average of 31 days, February, 28 days, etc. Is there a function I can use to do this? I've been trying the AVERAGEIF formula but can't get it to work. Any ideas would be much appreciated! Many thanks, Caitlin
I have a file that became too big due to phantom bloat, unused range saved by Excel and all that kind of reasons. Thank to previous posts on that board tackling that issue, I was able to find how to proceed to reduce the file back to its normal size. But I did so in a beta file (test file). The real file has become so big (103MB!) that Excel cannot even open it anymore! The file contains archive info that we do not have anywhere else. Is there anyway then to open the file or to reduce its size without opening it (through magics...)? I just honestly don't know how to retrieve that info before deleting that file. Thank you very much for your help. We have an Excel spreadsheet that sits on the network. People need to open the file to be able to sign up for various duty rosters. We would like for the file to open for the first person. And then for any others after that, get a message that the file is in use WITHOUT the option to open a read-only copy. Our staff can't read and they keep opening additional copies of the file! I have read about sharing the file and I don't think that would make things any better. Thanks, Lynn If I am using sendmail in a simple macro, is there any code I can add to actually open Outlook? Some users of the macro are pressing the macro button and do not have Outlook open so the email isn't sent until they eventually open Outlook! Thanks in advance |
Hello all,
Excel 2000.
I have the Add-in 'Analysis Toolpack-VBA installed, and I am trying to access 'atpvbaen.xls' in the VBA windows (per instructions from the website http://www.cpearson.com/excel/ATP.htm refered to on MrExcel's 'Tips' page). Apparently, there is supposed to be a box to check here, but I don't have that. Further, Autosave.xls and tmpltnum.xls require passwords also. I can't even expand them by hitting the + sign.
This is a plain-jane sheet, just opened. There are no passwords set. I have ensured that the Security Level is low and that the Trusted Sources option 'Trust all installed add-ins...' is checked.
What am I missing, other than the fact that I am completely new to VBA?
Thanks,
Starkman
Excel 2000.
I have the Add-in 'Analysis Toolpack-VBA installed, and I am trying to access 'atpvbaen.xls' in the VBA windows (per instructions from the website http://www.cpearson.com/excel/ATP.htm refered to on MrExcel's 'Tips' page). Apparently, there is supposed to be a box to check here, but I don't have that. Further, Autosave.xls and tmpltnum.xls require passwords also. I can't even expand them by hitting the + sign.
This is a plain-jane sheet, just opened. There are no passwords set. I have ensured that the Security Level is low and that the Trusted Sources option 'Trust all installed add-ins...' is checked.
What am I missing, other than the fact that I am completely new to VBA?
Thanks,
Starkman
Password Prompt when open solver.xlam file in VBA Hi, I got a problem about opening solver.xlam file in VBA. I was requested to type in Password. I didn't have any.
Solver Xlam Password Manager
- How to Fix Issues with SOLVER.XLAM (Free Download). Last Updated: Average Article Time to Read: 4.7 minutes SOLVER.XLAM, also known as a Microsoft Excel 2007 VBA Add-in file, was created by Microsoft for the development of Microsoft Office Professional Plus 2013 2013.
- Download Excel File Repair Tool rated Excellent by Softpedia, Softonic & CNET.; Select the corrupt Excel file (XLS, XLSX) & click Repair to initiate the repair process.; Preview the repaired files and click Save File to save the files at desired location.
- Password Prompt when open solver.xlam file in VBA Answers.microsoft.com DA: 21 PA: 50 MOZ Rank: 71 Password Prompt when open solver.xlam file in VBA Hi, I got a problem about opening solver.xlam file in VBA; I was requested to type in Password; You can follow the question or vote as helpful, but you cannot reply to this thread.
- Looking at the title 'Cannot run the macro Solver.XLAM!MainEx' I don't know what you have set up, but one 'Usually' doesn't run this part of the macro. (Unless I mis-understood) Does 'Solver' work ok from the spreadsheet? In the vba editor, go to Tools: Reference: and place a check on 'Solver' Here's a simple example: Sub Demo.