Auto create sheets and web query using VBA

**claytorm** · 05-08-2005, 10:43 AM

Hi

In a main sheet I have a list of around 300 three letter codes (representing company names).

1.)I want to create 300 individual sheets, still within the same workbook, named with these codes.

2.)In each of these sheets I want to create a web query. The web query address in each sheet will be the same, apart from the three letter code by which the sheet is named.

e.g. ABC in column A of main sheet, creates new sheet called ABC, with web query address www. xyz.co.uk/ABC.

I guess this will need some VBA. I would be very grateful for any solutions or suggestions.

Bertie.

**Leith Ross** · 05-09-2005, 03:55 AM

Hello Claytorm,

Since you didn't mention which column the list is in, or the name of the main sheet, I am calling the mainsheet "Main" and the list "A:A" (Column "A"). You can change these accordingly. Also, I assume that the web query is actually a hyperlink. So each entry is created as a hyperlink in cell "A1". Clicking it will take you to the web address. You will have to change WebAddx in the code to web address you want.

Please Login or Register  to view this content.

If you have any questions or problems, let me by e-mail. My e-mail address is [email protected].

Sincerely,
Leith Ross

Auto create sheets and web query using VBA

LinkBack

Thread Tools

Rate This Thread

Display

Auto create sheets and web query using VBA

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions