Hello everyone,
Quick question (i have serched old posts but found nothing) so now I am asking the question..
Is it possible in VB to move from one workbook to another without selecting the workbook name ?
A bit like using Ctrl + Page up/down to move between worksheets, but move between workbooks instead
example:
workbook 1 name = "Main"
workbook 2 name = 2Data 01/01/07"
the reason I am asking is that the second workbook will be a different name each month. So the code will not work each month if the code filename is specfic as the files names will be different ?
thanks in advance
Danno
Quick question (i have serched old posts but found nothing) so now I am asking the question..
Is it possible in VB to move from one workbook to another without selecting the workbook name ?
A bit like using Ctrl + Page up/down to move between worksheets, but move between workbooks instead
example:
workbook 1 name = "Main"
workbook 2 name = 2Data 01/01/07"
the reason I am asking is that the second workbook will be a different name each month. So the code will not work each month if the code filename is specfic as the files names will be different ?
thanks in advance
Danno