XL2QIF is an Excel Add-In that converts data to QIF format. It is supposedly a free download however the link to the website is broken http://xl2qif.chez-alice.fr/xl2qif_en.php Can anyone tell me where I can get a copy to install? Subscribe for Weekly Excel Tips and TricksHelpful tutorials delivered to your email!Similar TopicsI can't find this solutions anywhere. I know how to send emails from Excel using VBA. When I get to the Body section, I want to insert a clickable link to a website, and also a clickable link to send an email (not as important as the website). Can this be done? I have found code to insert links to files, but none for website links. Hello, Firstly i haven't used excel to a great extent since my college days. So i'm having to re-learn 99.9% of everything i once new... I am volunteering for a non profit organization and trying to create a reservation system for the rooms that they have - kind of like hotel software, but in excel (i did a similiar thing in college but for plane seats) Please find it attached. What i need it to do: Copy all of the info from the main page to the guest lit (a new row each time). From the guest list to the Gannt chart - i did a few tutorials on dynamic gantt charts using conditional formatting but cannot get them to work when based on data on a different worksheet. Finaly is there a way to check for availabilty on any given date? if just someone could point me in the right direction, i would be appreciate it so much words can't express!!! Best Regards, Jamie P.S for the calender drop down on the main page, i'm using 'microsoft time & date picker 6.0) http://www.2shared.com/file/6521961/...ibsV05b32.html - pop ups on this site http://www.easy-share.com/1906519167/RibsV0.5b3.2.xlsm - same file, better website I was testing the following methods (suggested in another thread) to disable copy/paste on a particular worksheet -- now copy and paste is disabled entirely from Excel and, apparently, from each and every excel workbook I've got. HELP!!!!! http://www.xcelfiles.com/VBA_Quick13.html http://www.mrexcel.com/archive2/75500/87639.htm Taxstar
I know this question has been asked a bajillion times, so I apologize for the redundancy. I am working with an Excel spreadsheet and saving it as a .csv file in order to upload to an application that parses out the .csv data as transactions. The system requires .csv files, so this is how I need to save my doc (with this extension). I have been successful at preventing Excel from coverting that long number into scientific format. I have saved as a TXT file, pasted the longer number and it displays correctly. That is all good. But I have to save as a .csv. So if I do that, close the Excel window, and then open again (as the .csv file), the numbers are back to being displayed in scientific format. I have tried creating an Excel doc from scratch and entering text in Text format, to see if this created a cleaner file. But again, the second I save as .csv, close the window and then open that file up again, that dang scientific format is back. Does anyone have any idea of how to work around this? Once I have successfully gotten the numbers to display as the long-chain number, how can I get them to 'stick' so that they don't revert back to scientific format when I reopen the file? Thanks so much for your help!
i want to retain the data and format, but get rid of the pivot capacity before sharing the spreadsheet. right now if a copy/paste special, i can get the data, but not the formats, any suggestions? I have imported a DBF file into Excel and have a column of dates that are missing the leading zero on single didgit months. When I try to us the custom format of mm/dd/yyyy it doesn't work (interestingly, after I select that format if I click on an individual cell it changes to the right format). Does anyone know a better way to do this? Thanks in advance!
Hi All, I've been struggling with this for a while now and can't believe how hard it is!. I've searched on this site and on others to get some clarification but to no avail. It's pretty simple really. I have a user form which contains a tex box for a user to input the date I want the format to be dd/mm/yyyy but can't find out how to set the format of the text box to this. Please can someone give me a bit of guidence or link me to a good rescource if missed it in the search. Thanks in advance. G
I'm trying to use VBA to go to a website that requires a User Name, Password, and a Submit Button. So far I can get everything to work besides the Submit part. The code runs without errors, but doesn't actually 'hit' the submit button on the webpage. For posting, I removed my actual user name and password and and used the generic ' User Name ' and ' Password ' highlighted in blue. I highlighted another section in green that I took from a previous post hoping it would solve my problem. The link is: http://www.mrexcel.com/forum/showthr...xplorer+submit Here is the code I am using: Sub GoToWebSiteAndPlayAroundNew() Dim appIE As Object ' InternetExplorer.Application Dim URL As String Set appIE = CreateObject('InternetExplorer.Application') URL = ' https://efolio.morgankeegan.com/escripts/defaultLogon.asp?errCode=2 ' With appIE .navigate URL .Visible = True Do While .busy: DoEvents: Loop Do While .ReadyState 4: DoEvents: Loop .document.getelementbyid('fUserName').Value = ' UserName ' .document.getelementbyid('fPassword').Value = ' Password ' End With On Error Resume Next x = 0 For Each mitem In IE.document.all mitem.Value = 'x' x = x + 1 Next x = 0 For Each mitem In IE.document.all If x = 'Submit' Then mitem.Click Exit For End If Next End Sub
Dear Sir, If any one could give me a solution for this its will be a great help for me. I am working in a bank and on every day we receive Month to date data of Loans and advances made by every branch with Region wise total and manager wise total. With Sum of loan and count of loan. In our MIS format the in A coulum branches are sorted and listed in a sequence with sub total Region. I have data where if if do the pivot and change the data the out put should be displayed accordingly in the MIS format. Can any one help me how can we do this or is there any other office addins/softwares are available if so the data is changed on a daily basis and if we do the pivot it will automatically copy the data to the MIS format. Thanks. 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
I would like to copy a small table from Word into one cell in an Excel worksheet. The first column of the table is a list of numbers. I tried converting the table into text with manual line breaks and tab stops to divide columns and rows, but that didn't solve my problem. Excel pastes the data into several rows. When I try to merge them, I get a warning that the selection contains multiple data values, and merging into one cell keeps the upper-left most data only. What I tried that didn't work: * Formatting the Excel cells as text before pasting the data. * The various options for 'Paste Special.' The closest I got was inserting the table as a Document Object, which could be a workaround, I guess. What I am saving for when all else fails: * The obvious solution of copying row by row into one Excel cell. The data in the table is information about my dad's medications. I would like to have reference charts of how to identify the strength of each tablet by its color and markings. I got the info from the manufacturers' websites and entered it into tables in Word, which I would like to copy into a more comprehensive file I am creating in Excel. The first column of each table is the strength of the tablet, entered as 1 mg., 2 mg., etc. The subsequent columns describe the shape, color, and markings. There are 3 tables, each with about 4-5 rows. Is there a way to copy each one - whether as a table or as text - into a single Excel cell without losing data? Many thanks. Dear Sirs, Am in need for this solution very badly and what could be a better place than excelforum ! I have an MS Excel File (2007 version) sample file attached, which has name, designation, blood group and so on. The last column is for hyperlinking photographs of individuals. In the same folder where I have saved this excel file, are lying photographs of individuals. While scanning the photographs, I have saved them serially i.e. 1,2,3 and so on. In the Excel file, in last column, I have given the respective serial numbers. In order to hyperlink one has to select that particular Cell, press Ctrl K and you automatically go to the folder containing individual photographs, you select that photo and OK. Problem : I have to do this hyperlinking one by one and if there 1000 photos, lot of time is wasted. Solution Needed : Just in case of excel formula, which we copy and paste, Can I get a command by virtue of which the column titled Photo or column next to it gets automatically Hyperlinked to respective photo WHEN I copy and paste such command to all cells in that column. Thanks a million and warm regards ::: Jack Hello - I am using Excel 2007. In prior versions of excel, when copying data, if I wanted to copy visible cells only, I would select 'Go To, Special, Visible Cells Only' and then copy a range a cells. The default was always set to copy everything (including hidden cells), unless I specifically selected copy visible cells only. In 2007, the default is somehow set to always copy only visible cells. Sometimes, I want to be able to copy all cells including those hidden but cannot seem to figure out how to swith this default option. I looked under Excel Options and did not see an option there. I don't want to have to unhide and rehide everything each time i copy. I know i could do the hiding and unhiding via VBA but would prefer not to have to. Thanks for your suggestions. I found this solution for 'drop down list with hyperlink' but it did not work. Perhaps a better solution is to use a workaround that relies on the HYPERLINK function to refer to whatever is selected in the drop-down list. For instance, if you have your data validation drop-down list in cell A1, then you might put the following formula in cell B1: =HYPERLINK(A1, 'Goto Link') The solution directly above provides exactly what I am looking for in the field where I write the formula, but it fails to hyperlink. I have created a drop down list and linked each one of them to a specific worksheet. When I select them individually they link to appropriate worksheet. But when I select them in the drop down list I receive the following error when I select the Hyperlink in cell B1 as directed above. 'Cannot open the specified file' Any thoughts? Bob
We have a large (4,000+ rows) excel worksheet from a prior employee that I would like to be able to use, but it is password protected and no one has the password. Is there a way to copy or save it as a different file that will not copy the password protection? It would save me a couple days of work if it is possible. Thanks
Hello, I'd like to be able to copy data from a list of websites into Excel. It would take too long to navigate to do an Excel web query for each site, so is it possible to write a macro that could do that? Thank you! ML
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. I have workbook in which I want to save a specific worksheet to a new file with only the values saved - all data in this worksheet are references to cells on another worksheet, which is using VLOOKUP to pull data from a database. Found the following code and it gets me close, but it copies the cell references, not the values. It also allows me to specify the file name from a cell reference. I want the new workbook file to simply be saved, not opened, and a message box to display stating where the file was saved (will always be in the same location on the LAN). What modifications do I make to this to get this to work per above requirements? Sub CopyMe() Dim SaveMeAs As String SaveMeAs = Sheets('Sheet1').Range('B2').Text Sheets('Sheet3').Copy ActiveWorkbook.SaveAs Filename:='C:My Documents' & SaveMeAs End Sub I have a requirement to change the panes in excel. My excel file will contain more than one tab. I have to free the first two lines in all the tabs except the first one. I tried the following code. Code: But in this I have to change the Active Worksheets in VBA, Which I want to avoid. Is there any method to achieve this without selecting the cells. Something like Code:
Hello everybody, We all know we can change the source of a link of the workbook by clicking Edit>Links>Source>change source but that will change the source of all workbook formulas which are linked to a certain file, what about if i need to change the source of a single sheet? is this possible? I appreciate your support.Thank you !
file locked for editing , can I kick the other user out if its my file? I have made an excel file where other people have to go in and update it. This process takes 2 secs but some people forget and stay in it over lunch etc causing a great annoyance. Is there anyway I can 'kick' them out my file? Im not concerned if they lose any data they've entered as I'm sure this will help them get the message to get out the file quicker.. Its really doing my head in... pls help I did a bit of browsing on this problem. Found others suffering the same but haven't found any conclusive answer yet. Every so often when I attempt to save a file, (including save as), Excel won'r let me. By won't let me I mean: using Save doesn't appear to do anythingusing Save As doesn't either do anything, the dialog is not displayed and if I am doing via the File menu then the File menu is exited and the previous ribbon tab is displayed (i.ethe one I was on before clicking 'File')if I close the workbook I am prompted to save, close without saving or cancel. Clicking save just invokes the same msgbox again.I can't work out when it goes into this mode. Some days I can work without this problem, other days I encounter this 2 or 3 times. The only thing I could suspect was I think this started around about the time I installed xlDennis' code library. I have uninstalled the addin and so far so good, but I cannot categorically say that this was the cause. Anyone have any idea? Cheers Jon Edit: I have read this: http://support.microsoft.com/kb/271513 Doesn't seem to cover the issue I describe
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 there, I have a piece of code called ConvertDates that formats data contained on 6 worksheets. The 6 data sheets all contain a data connection to a website of foreign exchange tables. What I want is for my code to execute as soon as the data connection refresh has finished. When I use the statement Code: The code executes the macro whilst the refresh is still happening, thereby screwing up my results. I don't really want to use a timed wait, because the refresh speed is going to vary from user to user. Is there some way I can tell excel to wait till the refresh has finished and then execute the code? Any help would be hugely appreciated.
I have a co-worker's file that he is having trouble with. He is using Excel 2000 SP3. When copying a cell with a formula in it of '=D6+C6' and pasting it into the next cell down, it will display the same value in the cell as the calculated value from above, but has the correct formula displayed in the formula bar of '=D7+C7'. Example: A1: 50 A2: 10 B1: 60 B2: 20 A3: Formula: =A1+A2 Displays: 60 Right click A3, Copy, right click B3, paste A3 displays 60 When I click save, it will change the display value to 80. I am trying this on his workstation and mine. Mine has Office 2010, so I think there might be an issue with the file itself. Also, not just copy and paste. I can also just click the top cell after filling in the formula and then drag the bottom right of the cell downward and it will do the same of filling in the correct formula, but have the incorrect value. I know that I could get him to just click save each time before really looking at the results, but that is just a band aid to the problem. Any ideas how to fix this? |
Sit down and relax while ASAP Utilities does the rest!
Nov 7, 2018 - How to install and use Excel Add-ins for extra functionality. List of recommended add-ins, and how to save file as add-in.
How it makes YOU rock in Excel
Frequently we write a new tip to show you how to benefit from the tools in ASAP Utilities to save time and speed up your work in Excel.Choose from 10 languages
With clients in over 140 countries, ASAP Utilities is available in:- Deutsch (German)
- Español (Spanish)
- Français (French)
- Italiano (Italian)
- Nederlands (Dutch)
- Português do Brasil (Portuguese (Brazil))
- Русский (Russian)
- 中文(简体) (Chinese (Simplified))
- 日本語 (Japanese)
Supported Excel versions
ASAP Utilities 7.6 works with:- Excel 2000
- Excel 2002/XP
- Excel 2003
- Excel 2007
- Excel 2010 (32- and 64-bit)
- Excel 2013 (32- and 64-bit)
- Excel 2016 (32- and 64-bit)
- Excel 2019 (32- and 64-bit)
- Excel 365 (32- and 64-bit)
Awards & Reviews
Read the awards & reviews from magazines, newsletters and radio shows.Who are our clients?
Our list of clients exceeds 20,000 organizations in more than 140 countries.Pricing & Ordering
Buy your license(s) today. It's only USD 49.00 for a single user license, or save up to 86% with volume discounts.Return on investment
On average ASAP Utilities saves people 30.6 hours each year (measured among 103,778 users in March 2019).“The most popular add-in for Excel users”
ASAP Utilities is a powerful Excel add-in that fills the gaps in Excel.During the past 20 years our add-in has grown to become probably one of the world's most popular add-ins for Microsoft Excel.
“A must have for anyone who spends time in Excel”
Worldwide 750,000+ users and 20,000+ organizations use ASAP Utilities.We truly believe that ASAP Utilities is a must in every office. It's guaranteed that more than a few of the tools will be just what you've been looking for to fill the gaps in Excel.
Download your free trial and discover why. We also offer a free Home & Student edition for home projects, schoolwork and use by charitable organizations.
Do more and save time in Excel with these popular tools
The tools from ASAP Utilities add new functionality to Excel and are guaranteed to save you time and speed up your work.A few of our most popular tools are:
- Change text to UPPERcase, lowercase, etc. etc.
- Insert before and/or after each cell in your selection...
- File import and export tools (txt, csv, dbf, xls, gif, jpg, html, etc.)
- More: list of all utilities and extra worksheet functions
Quick Start: How to get the best out of ASAP Utilities
Discover how ASAP Utilities makes YOU rock in Excel.Frequently we write a new tip on our website and blog to show you how to benefit from the tools in ASAP Utilities.
![Download Download](http://xl2qif.chez-alice.fr/images/screenshot_en.png)
Choose your language of ASAP Utilities
With clients in over 140 countries, ASAP Utilities is used with many different languages.You can choose from the following 10 languages for the ASAP Utilities user interface:
|
|
Download our Business trial or free Home&Student edition
Download our fully functional 90-day Business trial or the free Home&Student edition (for home projects, schoolwork and use by charitable organizations). The latest version of ASAP Utilities, 7.6.2, was released on June 20, 2019.ASAP Utilities installs and upgrades easily and creates its own submenu in Excel from which you can start the tools: