Open an Excel file from aform in VBA
Closed
NAcho111
-
3 Jul 2009 à 09:28
Excelguru Posts 261 Registration date Saturday 11 April 2009 Status Member Last seen 21 June 2011 - 4 Jul 2009 à 03:39
Excelguru Posts 261 Registration date Saturday 11 April 2009 Status Member Last seen 21 June 2011 - 4 Jul 2009 à 03:39
Related:
- Open an Excel file from aform in VBA
- How to open .ps file - Guide
- Excel vba find - Guide
- How to open vba in excel - Guide
- How to open excel file in notepad - Guide
- Open swf file - Guide
1 response
Excelguru
Posts
261
Registration date
Saturday 11 April 2009
Status
Member
Last seen
21 June 2011
307
4 Jul 2009 à 03:39
4 Jul 2009 à 03:39
Hi Nacho111
Change the sequesnce to this
Workbooks.Open Filename:="Z:\06 Elaboración\Prueba 3.0\Agua.xls"
Sheets("Agua").Select
Load Agua
Agua.Show
ThisWorkbook.Close
Change the sequesnce to this
Workbooks.Open Filename:="Z:\06 Elaboración\Prueba 3.0\Agua.xls"
Sheets("Agua").Select
Load Agua
Agua.Show
ThisWorkbook.Close