Threads Replies Last Post 326 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  >>   vba sourcecode to convert pdf to xls Hello, Does anybody know a home page where an example of a vba source code is listed, which enables to convert a pdf file (with tables) into an xls file. I would need some ideas how to do this, in order to write my one little vba programme. Thanks in advance Rudolfo ... 3 28.09.2006 18:14:42 Way to combine 2 cells? Hi, I have the following A B C... I Budgeting I1 cccc I2 dddd I3 eeeee II Office Supply II1 aaaaa II2 bbbb ..... Is there a way to combine Cell A1 with B1 to display 'I - Budgeting' ... 4 28.09.2006 16:52:02 how to Here's the scenario, I have to accumulate hours and days that I work. I am only paid a day rate. yet sometimes I work an hour here and an hour there. When I reach a certain number of hours, I have to bill for a full day rate. Is there a way to keep a running total and when it hits that magic number, it will create an entry the day billing column and reset the hour tracking column to ... 2 28.09.2006 16:18:02 Will excel 2003 format a cell to the year? It seems like it should be obvious, but I am finding it impossible to get excel to do a date format that recognizes a year. Is there some way? ... 2 28.09.2006 15:49:13 transpose columns into rows--with a twist I've got two columns. Column A contains the ID; column B contains a list of subjects, delimited by comma. For example: HappyValley A,B,C,D,E,F What I'd like to do is to break up the list in column B using text-to-columns, but then turn each list item into a separate row, paired with the ID from column A. Thus, the row above should produce: HappyValley A HappyValley ... 4 28.09.2006 14:39:43 Migrating from Excel 2002 to Excel 2003 Hello, Our company is finally moving from Office 2002 (Excel) to Office 2003 (Excel) and I am wondering if there will be any problems, issues using Excel 2003 from files created from Excel 2002. I don't think so unless an Active X is embedded in a marco or in the actual file. Any tips or know issues will be appreciated. Thank you advance. ... 2 28.09.2006 12:51:24 Toolbars hide where? Apologies, I've not kept a note of when you told me before - where do XL toolbars and their custom buttons hide? Universal macros are in PERSONAL residing in Application Data\Microsoft\Excel\XLSTART\ No problem with Word - it's all in Normal - but I don't think they are in PERSONAL since they sometimes disappear when the is no problem with PERSONAL. Thanks again. Francis Hookham ... 7 28.09.2006 12:48:12 Problem with Hyperlinks in Excel 2003 Recently my company has moved to office professional 2003. Since the upgrade, I have experience 2 PC’s with the same issue. That is, opening any new excel file, adding say http://www.microsoft.com to one of the cells and then trying to click the hyperlink to view the http content. Every attempt generates the following error. “Cannot locate the internet server or proxy server.” Attemp... 1 28.09.2006 10:17:19 Speeding up Excel - Large amounts of data, no complex formulas Hi There, I am currently investigating what is the most cost effective way of speeding up excels calculations for large spreadsheets. The sheets do not contain what I would consider to be overely complex formulas with the main tools being VLOOKUP, with maybe a few nested IF statements. No complex maths as it mainly database manipulation type activity. Currenlty it is taking too long to ... 4 28.09.2006 10:03:21 Convert formula imnto values Hi, In a column of my spreadsheet there are only VLOOKUP functions, all working properly. But now I want to replace that function, with the value found by that VLOOKUP function. I found something like doube click (in-cell editing) and then F9, but that only works for one cell at a time. Anyone who has any idea how to do that for a complete column or maybe complete spreadsheet. I e... 3 28.09.2006 09:39:44 Multiple Criteria CountIF Step1: Worksheet KPI: I want to find out the number of appointments made for AMK on 1Sept. [image: http://img.photobucket.com/albums/v99/selfobsessed/excel1.jpg] Step 2: Worksheet MIS: So I used the information: Date of contact, Status and Branch to form a COUNTIF formula. =COUNT((IF((MIS!B11:B7284=MIS!B7285)*(MIS!G11:G7284=MIS!G7285)*(MIS!N11:N7284=MIS!N7285),MIS!AC11:AC7284)))+COUNT... 4 28.09.2006 07:49:45 Referencing only certain cells in a table Hello, I posted this question earlier in the execl.worksheet.functions group, but did not get an answer. I apologize for the repost. I need some help referencing certain cells from one worksheet in another. Here is an example of what I am trying to accomplish: Worksheet 1: Item # Name Value 1 item1 100 2 item2 0 3 item3 0 4 ... 4 28.09.2006 07:11:31 transpose columns into rows--with a twist I've got two columns. Column A contains the ID; column B contains a list of subjects, delimited by comma. For example: HappyValley A,B,C What I'd like to do is to break up the list in column B using text-to-columns, but then turn each list item into a separate row, paired with the ID from column A. Also, a new column should be created, and contain the relative position of the s... 1 28.09.2006 05:53:52 COUNTIF problem COUNTIF problem - I hope this makes sense! A10 heads a column of box sizes: 40 50 .. .. 220 230 B10:H10 contain: Ar Et . . Sl Sy On another sheet are two columns named 'AllLGs' and 'BoxHeights': AllLGs BoxHeights Ar 0001 100 Ar 0002 110 Ar 0004 110 .. .. Sy 2076 120 Sy 0278 50 Sy 0279 ... 4 28.09.2006 03:52:53 Change the size of the sheet? Hi, everyone, I need only 30 rows, 7 columns in my worksheet, and I want column H, I, J, ... row 31, 32, 33, ... to "disappear" from my worksheet, even the column/row indicators (i.e. H, I, J, ... at the top, and 31, 32, 33, .... at the left side of the view). What can I do? Thanks. ... 2 28.09.2006 03:42:20 Still can't get the correct formula for marksheet Dear all, I still cant get the correct formula for this. Please help me. Thaank you. >Thanks a lot, Dave. >But if I leave all the cells blank, the overall result shows the student >'Passed' the exam. >This shouldn't be. How to solve this? Any other formula, Dave. >Thank you again. "Dave Peterson" <petersod@verizonXSPAM.net> wrote in message news:4516C167.940... 7 28.09.2006 03:37:51 Chart Color Defaults I'm not a big fan of Excel's default chart colors. I can change them as needed & experiment w/ what looks best, but are there any downloads that would allow me to conveniently reset the colors in one fell swoop? Thanks. -- Jay... 4 28.09.2006 03:27:01 Adding Comments in a Protected Worksheet (2007 beta) Hi, How can I add comments to a protected worksheet (office 2007 beta). Darrell ... 3 28.09.2006 02:49:38 Run time error executing Excel code (VBA) When I execute the code below on the second iteration reading the file I get run-time error 1004. Can someone help me correct this problem? I don't understand what I'm missing. Thank you - Luis ===============CODE ============================================ Option Compare Database Public HoldRequirement As String Public counter As Integer Public activeCnt As Integer Public parse... 2 28.09.2006 01:48:52 Macro to repeat the same tasks over 180 tabs. Hello all, I have a spreadsheet with about 180 tabs. I've done a Macro to complete a few tasks on the 1st Tab. I now need to complete those tasks on most of the remaining tabs. Is there a way to do this without copying the same Macro and then changing the tab name? There are about 5 tabs that I don't want to Macro to run on, so ideally, the Macro will ignore those. If that can't b... 7 28.09.2006 01:41:32 XML validation I like to import a XML file into excel. In the header of the XML file is a URL for the validation of this file. However the url in the header is not there. This valdiation (XSD) is on my local drive. Is there a possibility to tell Excell where this XSD file is on my local drive? I cant find this there however i saw in other programs that this is mostly possible. ... 2 28.09.2006 01:14:47 How do Count a the number of times a date range appears within a date range!? I'm stumped, I have no real idea on how to do this so any help much appreciated! I have a start date (no year ie, 1st December) and an end date (again no year say 5th Jan), And a date range, eg 11th May 2001 to 1 January 2006 for info late: 1st Dec to 5th Jan = 35 days How do i get a count of the number of 1st Decemebers to 5th Januarys in that date range for example 1st Decemb... 5 28.09.2006 00:14:47 Text to Columns Having used the "Text to Columns" tool once on a worksheet (to separate by spaces), I find I can't switch it off. Every subsequent time I try to copy and paste some other text from a single cell, for some completely different reason, the pasted data gets spread over many columns if there are any spaces in the text. How can I switch off "Text to Columns" after using it? This surely must ... 3 27.09.2006 22:21:30 Grouping rows based on like data in a cell and then separating them Lets say you have a 15,000 line spreadsheet covering about 8,000 different items. Some items have multiple lines devoted to them. Each line is a separate transaction related to that item. After sorting the list by the item name, I now wish to have excel insert a blank line between each different name. So basically this: alpha alpha beta beta beta gamma delta delta would becom... 3 27.09.2006 21:57:11 Copy above row data into blank fields below Hi. Certain fields within my data do not repeat, but I'm trying to find a way to populate the blank cells from the preceding row. Here's an example: Employee_Number Last_Name First_Name 123456 Smith John Judy Ben 123457 Johnson Bill... 3 27.09.2006 20:34:28 326 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  >>