Hi everyone
I have joined this forum to seek help in my hour of need! I am using Excel 2003 at home but Excel Mac 2004 which does seem to be a little..special at times.
I am just starting to learn VB and I have decided I need some expert help. If I describe what I am trying to do first...
What I want is to be able to;
Open a workbook
Click a form control button (Sheet 1)
This prompts several Web Queries to be executed (Approx 8 of them Via VB)
1st set of data that is downloaded to be listed on Sheet 2
Sheet 2 is renamed and then hidden
Sheet 3 is also renamed and a pivot table appears
A new sheet (Sheet 4) is opened with a new name
Second set of data loads
Tab for sheet 4 is renamed and Sheet becomes hidden
New Sheet (Sheet 5) is displayed
Tab for sheet 5 is renamed and pivot table appears
And so on for the remaining queries.
I have had limited success with various aspects of this. I have managed to input a form control which then loads 1 web query. However it won't load more than one web query!
Further to this, when I open the workbook the macro runs automatically and downloads it onto sheet one. Even though within the code I have managed to get it to select sheet 2 and even get it to rename, it seems unless I click the button it does its own thing. Unfortunately I do not have any code as it is at work!
I am a little stumped as to what to do next. I am going to post what code I have but I think as none of it worked properly I deleted it all!
I appreciate this is a large task. I would appreciate any help!
Thank you very much.
Regards
Peter
Bookmarks