Search results

I have found the issue, my additions were working but I have the row and column around the wrong way on my call to XL.Cells to get the cell data from that cell Thanks to you all for the help, I now have what I was missing to get this to function as I wanted just for the record, this is the...

Finally got some time to try this over the weekend and your code does exactly what I wanted it to do so I guess the key was using 'GetObject' rather than the 'CreateObject' I was using I have expanded this a bit and the next issue I have hit is getting the Worksheet object, this is the code I...

The Data I am reading is down loaded from a portal in an Excel file, at the moment I copy paste records into an Access form, as the process is manual and on a single PC, once I have the spreadsheet open, I will place the cursor on the row I want to read, using ActiveCell.Row I can then read...

Thanks for the responses and ideas. The program is a single user, I download data from the web and add to an existing spreadsheet, currently I manually enter the data into a form in Access based on several criteria. I have automated this in the past by loading into a datasheet from a temp table...

Hi I am sure this has been covered but I cannot find it. I have an Access DB where I create Spreadsheets based on queries and that works well, I also open Spreadsheets to read data into a table, again, it works well. Where I am struggling is to read from an already open Spreadsheet. I have...

Hi Just saying hello, I have been programming in VBA in both Excel and Access for a while, nothing to creative but I have created a membership database for a club I am the membership secretary for that works well. Have been using this forum as a source of info for a while so thought I should...