Search results for query: *

Hi, I'm having problems importing a delimited file (c10k rows) into Excel 2003. Below is a simple example using the pipe as a delimiter (you can guess this data comes from a mainframe report). 003.1270|aaa|bbb |12.00 AA|AAA|BBB|17 I formatted all cells as text prior to the import. The issue...

Hi, I'm using Word2003. Is there any way of viewing only changes made on a certain date? I've tried to save a changed document as a new version, but when I look at the changes I see ALL changes made rather than just the changes made in the latest version.

Hi all, I have created a custom toolbar with two buttons which run a couple of macros. It works fine for me but when I email the file to colleagues, they don't see the toolbar. It doesn't appear on the list of toolbars available. I've searched for information about this and just got...

Hi, I have this code to initialise a label on a splash screen. Private Sub UserForm_Initialize() Label1.Caption = Environ("username") End Sub This can give me fred.flintstone or barney.rubble (says something aabout where I'm working!). How can I extract the first name? Cheers, Henio

Hi, this faq looks interesting - I've never tried to use Solver before. So, I've followed the instructions as given and get the error message Binary constraint Cell Reference must include only Adjustable Cells. As it is unlikely that KenWright's faq is wrong, does anyone have any ideas about...

Hi all, I'm not sure if this is the correct forum, but as you are all multi-skilled... I am using MS Query from Excel to extract data from Oracle tables via the MS Oracle ODBC driver. The following (stripped down) query returns the correct records and values. The item units_pakd/std_pack_qty...

Hi all, I have a worksheet to which I need to apply the same filters to various columns to extract totals. Some of the filters can become quite complex, so I recorded some macros to simplify my life (and reduce keying errors). An very simple example is shown below. Sub Macro1()...

Hi all, I inherited this code which changes the start and end dates on the X axis for a graph. I can't figure out how to change the series ranges to match. As always, any help would be appreciated. Cheers, Henio For Each MyChart In ActiveSheet.ChartObjects MyChart.Select...

Hi all, I have a sheet containing two columns: Date Qty 1 Nov 1 2 Nov 2 3 Nov 1 4 Nov 4 etc When the user enters a date on another sheet, I would like to get the average Qty for the prior 7 days. e.g. User enters date of 12 Nov. I would like to retrieve the average...

Hi all, I regularly receive an Excel file from a host application where all numbers are sent as text. I need to total some of the columns and put the results on a new sheet. I would like this facility to be a macro. I recorded a macro and it gave me the following: Sub Macro1()...

Hi all, I recorded a macro for a simple task. I create a formula to format a cell based on the values of three others. I then copy it down to the end of the range. The recorder gave me: Sub Macro2() ' Columns("D:D").Select Selection.Insert Shift:=xlToRight...

Hi all, I have two tables: order lines and stock The Order lines table contains Customer Code Product Code Qty ordered The Stock table contains Product Code Available qty I need to extract orderlines up to the available qty of stock for each product. Can this be done without resorting to...

Hi all, in Excel I use Vlookup a lot. However, some of my Access tables are too large to export to Excel. Is there any way to do a Vlookup into Access in Excel? Write a function perhaps? But I wouldn't know where to start:-( Thanks, Henio

Hi all, I have a recordset that looks like: Col 1 Col 2 A 1 A 2 A 3 B 4 B 5 C 2 C 3 etc. I want to extract unique entries from Col 1 and the first associated vale from Col 2. i.e. A 1 B 4 C 2 I can do this easily in Excel but I have far...

Hi all, I'm trying to create an index of files in a directory. I've managed to copy filenames into Excel, but I'd like them to be hyperlinks to the files. Can this be done? tia, Henio

It's late on Friday (near deadline). I have a large number of rows which I need to number in groups of 24. ie rows 1 - 24 each have 1001 in a column rows 25 - 48 each have 1002 .. and so on. I'm sure that a formula can be devised for this, but my brain is tired... Cheers, H

I have inherited an application which alledgedly works. When I try to compile it I get a "Compile error - Can't find project or library" message. Two examples of lines that fail: MsgBox "Error during import process." & Chr(13) & "Check CSV file and format match and...

Hi all, yet another urgent user request to test my very limited grasp of VBA.. I have a sheet looking something like: Key1 Key2 Code Selection a1 1 text a1 1 text a1 1 text a2 1 text a2 1 text a2 1 text a3 1 text b1...

Hi all, I am trying to copy record a record n times from one table to another where n is a value in that table. The following code seems to work under Access97 but won't compile under Access2000. It objects to the DAO. in the Dim statements giving a "user-defined type not defined&quot...

Hi all, I have an Excel spreadsheet which could be loaded into a table) which looks like: Description Qty Beer 2 Wine 5 Spirits 8 I need to create a table which looks like: Beer 2 Beer 2 Wine 5 Wine 5 Wine 5 Wine...