| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open workbook(s) using VBA
Dear All
can you help me with the code of opening one or multiple workbook which are used daily Thanks & Regards Jeyakumar |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Open workbook(s) using VBA
hi Jeyakumar,
Sub test() Dim Wk As Workbook, FD As FileDialog Set FD = Application.FileDialog(msoFileDialogFilePicker) FD.AllowMultiSelect = True FD.Filters.Clear FD.Filters.Add Description:="Excel Files", Extensions:="*.xls;*.xlsx" FD.Show If FD.SelectedItems.Count 0 Then For i = 1 To FD.SelectedItems.Count Application.Workbooks.Open FD.SelectedItems(i) Next End If Set FD = Nothing End Sub -- isabelle Le 2012-09-21 10:48, TIMOTHY a écrit : Dear All can you help me with the code of opening one or multiple workbook which are used daily Thanks & Regards Jeyakumar |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Open workbook(s) using VBA
On Sep 22, 1:19*am, isabelle wrote:
hi Jeyakumar, Sub test() Dim Wk As Workbook, FD As FileDialog Set FD = Application.FileDialog(msoFileDialogFilePicker) FD.AllowMultiSelect = True FD.Filters.Clear FD.Filters.Add Description:="Excel Files", Extensions:="*.xls;*.xlsx" FD.Show If FD.SelectedItems.Count 0 Then * *For i = 1 To FD.SelectedItems.Count * * *Application.Workbooks.Open FD.SelectedItems(i) * *Next End If Set FD = Nothing End Sub -- isabelle Le 2012-09-21 10:48, TIMOTHY a écrit : Dear All can you help me with the code of opening one or multiple workbook which are used *daily Thanks & Regards Jeyakumar thanks again for reply |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to: Open closed workbook/Search data tables/Return data to open workbook | Excel Discussion (Misc queries) | |||
| Opening Excel, Book1 opens, remains open with other workbook open | Excel Discussion (Misc queries) | |||
| how do i open a data workbook when i open a timesheet workbook | Excel Discussion (Misc queries) | |||
| Open a specific workbook...find value from other open workbook and then insert cells values in cell next to it. | Excel Programming | |||
| How do you program so that Workbook B cannot be open unless Workbook A is open? Plus I need to validation | Excel Programming | |||
Linear Mode
