Uploading from excel to post in a forum

[Jhdd]

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

[venkat1926]

not clear what you need.

do you want to post your workbook in the forum.
there is facility in this newsgroup you can upload your file. see "Manage attchment".

[arlu1201]

To Attach a File:

1. Click on Go Advanced
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.