Recent content by teasugar

the loop did the job, i'm very thankful to the suggestion and to its expansion by bob. just with the code bob, you forgot a last 'end with' statement. and when i wanted to refer to a specific cell i used this method: to past [field1] starting from D3 and [field2] from E2, i did the...

thats about half of my problem, and thats why you were seeing me using the recordset.field(x) method over in my first code you rejected...i wanna to refer to only speficic fields in the recordsets and copy that, but with copyfromrecordset you can't specify fields and thats why i meant it can't...

thanks bob, what you showing me is what dcrake is suggesting. looks like thats my only way - making about 30 recordset for the massive no. fields i have :eek:

@ dcrake: lol i thought about that once myself, but that just kills the whole purpose of 'automation' and programming. i'm nearly doing everything myself and it becomes really inconvenient ...the true thing is i want to find a code that will prevent me from doing that, couz with it other...

thanks for the reply the sad thing with copyfromrecordset, i have tried it before, is that it doesn't support Automation. e.g: xlsheet.columns(1).copyfromrecordset recordset.fields(0) i get an error telling me you can't Automate it, ie, i can't tell the procedure to only copy that specific...

hi there, i looked around the internet and this forum to find a solution but was unable to do so. so here is the question: i make this SQL based recordset and then want to copy specific field data into a specific excel column ( say for example i have this field called Sender_Name in the...

hello everybody, really excited to learn and gain some help from this forum :D