Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open workbook "inactive"
I open a workbook which has a different name each month - against this
workbook I run a PERSONAL.xls macro which requires that workbook "Employees.xlsx" is open in the background. How can I as first item in the Personal.xls-macro open this "Employees.xlsx" workbook so it is "inactive" and the rest of the macro runs against the firstly opened workbook which has a different name each month? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open workbook "inactive"
this month yr workbook is "March.xls"
let's presume you only open this a/m file Edit the macro and put the following in the beginnig/as the first command: Workbboks(namethefullpath & "\" & "Employees.xlsx").Open Workbooks("March.xls).Activate then run the macro Hope I didn't miss sth. ;-) |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open workbook "inactive"
Hi Jarek,
What you call "March.xls" is each month different, thus I cannot insert: Workbooks("March.xls).Activate since I don't know the name of the file until I actually get it and open it. To re-itereate: 1. I manually open whatever the mothly file is called 2. I then want to run a PERSONAL.xls "macro1" against that opened file BUT FIRST I have to open "Employees.xlsx". So the PERSONAL.xlsx "macro1" needs to have as its first line: Workbooks("Employees.xlsx").Open BUT NOW I have to make this "inactive" and run the rest of the 'MACRO1' against the other first opened workbook. Understand?? "Jarek Kujawa" wrote: this month yr workbook is "March.xls" let's presume you only open this a/m file Edit the macro and put the following in the beginnig/as the first command: Workbboks(namethefullpath & "\" & "Employees.xlsx").Open Workbooks("March.xls).Activate then run the macro Hope I didn't miss sth. ;-) |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open workbook "inactive"
presume your Personal.xls is hidden
then after Workbooks("Employees.xlsx").Open put this ActiveWindow.ActivateNext does this help? |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open workbook "inactive"
Hi Helmut
One solution would be to open the monthly workbook as part of the macro as follows and assign it to a variable as follows: Dim wkbThisMonthsWorkbook As Workbook Dim bOpened As Boolean bOpened = Application.FindFile If Not bOpened Then Exit Sub Set wkbThisMonthsWorkbook = Workbooks(Workbooks.Count) Call Workbooks.Open("Employees.xlsx") wkbThisMonthsWorkbook.Activate HTH "Helmut" wrote: Hi Jarek, What you call "March.xls" is each month different, thus I cannot insert: Workbooks("March.xls).Activate since I don't know the name of the file until I actually get it and open it. To re-itereate: 1. I manually open whatever the mothly file is called 2. I then want to run a PERSONAL.xls "macro1" against that opened file BUT FIRST I have to open "Employees.xlsx". So the PERSONAL.xlsx "macro1" needs to have as its first line: Workbooks("Employees.xlsx").Open BUT NOW I have to make this "inactive" and run the rest of the 'MACRO1' against the other first opened workbook. Understand?? "Jarek Kujawa" wrote: this month yr workbook is "March.xls" let's presume you only open this a/m file Edit the macro and put the following in the beginnig/as the first command: Workbboks(namethefullpath & "\" & "Employees.xlsx").Open Workbooks("March.xls).Activate then run the macro Hope I didn't miss sth. ;-) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Unable to open a 82 KB XLSM file due to "Too many different cellformats" & "Converter failed to open the file." errors. | Excel Discussion (Misc queries) | |||
Unable to open a 82 KB XLSM file due to "Too many different cellformats" & "Converter failed to open the file." errors. | Setting up and Configuration of Excel | |||
Code exected at "Workbook Open" slowing/stopping file from opening | Excel Programming | |||
Exel 2003, Solver,"Answer" inactive. | Excel Discussion (Misc queries) | |||
Setting default "open" worksheet in a workbook | Excel Programming |