VBa Code Did't Open Workbook
Closed
azmiismail
Posts
17
Registration date
Thursday 3 March 2011
Status
Member
Last seen
20 July 2011
-
20 Jul 2011 à 02:06
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 22 Jul 2011 à 17:33
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 22 Jul 2011 à 17:33
Related:
- VBa Code Did't Open Workbook
- Cs 1.6 code - Guide
- Vba case like - Guide
- Samsung keypad mobile lock open code - Guide
- Excel online vba - Guide
- Samsung volume increase code - Guide
1 response
smd_excel
Posts
27
Registration date
Saturday 18 April 2009
Status
Member
Last seen
22 November 2012
20 Jul 2011 à 02:29
20 Jul 2011 à 02:29
Capture the file name and location i.e. in variable
file_path = Sheets("sheet1").Cells(1, 2)
file_name = Sheets("sheet1").Cells(2, 2)
Workbooks.Open Filename:=file_path & file_name
file_path = Sheets("sheet1").Cells(1, 2)
file_name = Sheets("sheet1").Cells(2, 2)
Workbooks.Open Filename:=file_path & file_name
22 Jul 2011 à 17:33