Macro challenge: find or create excel-sheet in separate workbooks

  • Thread starter Thread starter Snoopy
  • Start date Start date
S

Snoopy

Hey guys
1) One of my macros pastes a list of various numbers of users -
starting from range A1 into sheet "userlist" in workbook "user.xls"
I try to make a macro to do some things:
Run through the list and create a new userfile (based on predefined
template I have made in folder c:\template) pr user - placed in folder
(c:\users) that is allready made
The folder/pathname is specified of each user in range B1:Bnn.
My challenge is to make the loop that runs through the list A1:Ann
- and ends after last position

2) My pivot-table shows one year at a time.
I wants to make a macro to copy pivot-tablecontent (thas easy)
into another specified workbook
and then do this:
a) open the specified workbook, find the possible sheet named as the
year (Range A3.value) I proceed and paste the copied data here
b) if not recognizing any suitable sheetname - I want the macro to
create a new sheet in the workbook and paste the data.

I know I have asked for help some times, but hope you guys will give
me a lead

Regards
Snoopy
 
Hi,

Try recording the macro, then send us what you get and tell us what isn't
working the way you want.
 
Hi,

Try recording the macro, then send us what you get and tell us what isn't
working the way you want.

--
Thanks,
Shane Devenshire








– Vis sitert tekst –
Click to expand...

Thanks Shane :)
I realy do appreciate your respons.

Maybe the real - but simple - problem (1) is to make my macro run the
loop for each cell in the range A1:Ann.
For each value in this range I create a new file named as
Range.value.xls - and off corse after the last range.value stop the
macro or proceed anorther one.
I cant get this event recorded, neither the next problem (2).

A set of data is to be copied from one workbook to another, the
year.value is placed in Cell A3.
I want my macro to "read" this year.value and find in the receiving
workbook the sheet named year.value - if not finding it: create a new
sheet with this new year.value - then paste the data set into the new
year.value sheet.

I certainly think this is not the big ExcelVBA challenge to the
advanced VBA user, but I'm still a rookie on this.

Regards
Snoopy
 
Back
Top