Hi all,

I had a search around within this forum for what I want to do first but couldn't find anything similar, this makes me wonder if it is possible.

The essence of it is that I have an excel document full of data with roughly 1000 entries coming in at a time throughout the year. Each of these rows in my spreadsheet I then manually post as a new topic in my forum using ColA as the topic title, ColB as the main body of the text. As you can imagine this is tedious, I was wondering if there is a possibility that VBA or something similar would be able to automate this for me and save me countless hours?

The data can also come in a group (declared in ColD) so a number of rows will fit under a grouping, this grouping is then the topic then rows in the group are the main body of text.

I guess the steps would be a bit like this in basic form (sorry about the syntax, my last and only venture into programming was briefly with c++ a few years ago)

click on first new row to upload

start

(n)=current row

if
ColD has data

copy D;(n)

change to browser

start new topic

paste in topic

change to excel

copy cell from A;(n)

change to browser

paste in body of text

if D;(n+1) = D;(n)

repeat transfering A;(n+1) B;(n+1) into body of text

else

post topic

else

copy A;(n)

change to browser

start new topic

paste in topic

change to excel

copy cell from B;(n)

change to browser

paste in body of text

post topic

repeat until A is empty

Any help would be much appreciated, a point in the right direction as to what kind of code I should try and get my head around would be brilliant

Kind regards

J