11-14-2011, 02:04 PM
Is there a way to get a list of all the spreadsheets open in Excel? I can only get the worksheets.
Excel Spreadsheet Names
|
11-14-2011, 02:04 PM
Is there a way to get a list of all the spreadsheets open in Excel? I can only get the worksheets.
11-14-2011, 02:34 PM
11-14-2011, 03:24 PM
thanks. I thought you could use a string to call the workbook; is that not the case?
Macro Macro
11-14-2011, 03:42 PM
11-14-2011, 04:05 PM
that's what I've been doing but as one of me spreadsheets changes each week and may not know how the name changes at the end, I was hoping to regex the prefix and then feed in the variable.
11-14-2011, 04:41 PM
Member function ExcelSheet.FindWorkbook
function! $name [flags] [str&getName] [Excel.Workbook&getWorkbook] ;;flags: 2 wildcard, 4 beginning, 8 end, 16 partial, 32 rx
11-14-2011, 05:22 PM
Rats...everything seems to work just fine. I get a return of '1' on the 'FindWorkbook' function and the correct name of the spreadsheet gets passed but it doesn't actually pull Excel to the forefront (though when it is visible and another spreadsheet is showing I can see that it is switching the visible spreadsheet to the correct one just not bringing Excel up to the act place.
Shouldn't 'Init' still do that or did I monkey something up?
11-14-2011, 05:48 PM
flag 2 activated workbook in Excel. To activate Excel use act.
|
« Next Oldest | Next Newest »
|