Recent content by AndyKeen

Thanks 1DMF. I have tried everything I can think of and double checked my version the code - even put in the fix for the remainder handling. I am confident that the code is fine - and it has always worked in the past. I was grasping at straws I guess, just wondering if there was some...

Ref thread705-1703957 I am using code based on 1DMF's method in a database I wrote a number of years ago. This code has been working perfectly ever since for a client company transferring .csv order files created in an access database and then passed to their suppliers for fulfilment. The...

Sorry Skip. My use of language is at fault. The "chart" is a user term for the entity which in Excel terms is simply a worksheet on which the data is laid out in a form which the user requires. All I need to do is trap the cell being selected by the user, pick up the value of the record key...

Thanks again Skip. Sounds just the thing. Will see how I get on tomorrow. Hopefully I won't have to bother you again.

I have a small Access (Office 2007) application which uses Excel to display a "room chart" from data held in the Access tables. The Excel workbook and sheet are automatically opened and populated/updated as changes are made within the Access forms. When the Access form is closed the Excel sheet...

OK Found it - Although still not quite sure why it works as it does! The original references in the matches were in the format "UniqueValues!F2063". "UniqueValues" is the current sheet that contains the formulae. Everything worked fine until the database is sorted. I have modified the...

No, that is not the case but I am going to put together a small test sheet to try to prove the problem one way or the other. I should have done so before wating your time - sorry. If I can reproduce the error in another smaller sheet I will repost here and (if I can) attach the sample workbook...

No Skip. I am saying that If I have a database table spreading across 30 columns or so and that contains the row specific version of the above formula on each row it works perfectly. If I then click on the row ID for the headings and then data, filter it allows sort/filter on all columns of...

I have a database in Excel which consists of a couple of thousand rows or so which users need to sort, filter and manually amend regularly. I need to include a calculated value on each row based upon the results of a combined match,index,index formula as follows...

Thanks Christiaan. As I have no experience of either I guess this will be another good learning curve on a supposedly small app. There will never be more than 10 concurrent users. Which do you think would be the best/quickest method to read up on first? I don't want to make this into a...

A very small part of my current app requires me to read an existing Access 97 table containing a single record and to display the contents of a field as soon as they are changed. I have no control over how or when the data is placed into the Access table (it is a call logging output)...

Thanks Combo. You are of course correct I can "control" the name if I wish. However, as a test after your first post, I changed the name of the file manually to .txt and I am afraid got the same "automatic conversion" problem as I got with the .csv extension so in this case there isn't much...

Thanks to HughLerwill & PHV. Will remove the 2nd refresh and try the delete as suggested. As it happens the CSV files are relatively small and the sheet is only active for a very short time (usually less than a minute) during the conversion process so neither is really an issue in real life...

Just to complete the story. The final syntax I got working was: Set wsInqt = wsIN.QueryTables.Add(Connection:="TEXT;g:\vas\sage\trans.csv", Destination:=wsIN.Range("a1")) With wsInqt .TextFilePlatform = 437 .TextFileStartRow = 1 .TextFileParseType = xlDelimited...

Thanks again to Skip and Combo for your assistance. I will try the solutions tomorrow. Unfortunately I don't control the naming of the import file so Combo's solution might not be ideal for the user. However I am sure one solution or the other will work for me and at least I have learnt...