#1
|
|||
|
|||
How to open one Workbook from another in VBA 2016
I just downloaded Office 2016 and many of my 2011 Excel workbooks open other workbooks with VBA and use the data in them. They don't work with 2016. The Workbooks.Open pathname instruction just does't do the job. When I try to record a macro to do that I get blank. What's the new way of doing it? |
#2
|
|||
|
|||
I'll answer this one myself. Below are done in Excel 2016
Workbooks.Open ("/Users/OldAl/Desktop/OldExcelTest.xlsm") 'Opens Dialog to Open WB Workbooks.Open ("/Users/OldAl/Desktop/quotes.csv") 'Works - Opens the .csv file It seems .csv files open directly and .xlsm files get the dialog box if workbooks are in the same place/folder Workbooks.Open (ThisWorkbook.Path & "/quotes.csv") 'Works Opens the .csv file Workbooks.Open (ThisWorkbook.Path & ":quotes.csv") 'Doesn't Work - gets "Can't Find..." It's the last one that is in all my Mac Excel 2011 Workbooks. It looks like they missed the fact that Macs are different in describing Paths. Ugh! I didn't figure out how to open an .xlsm file directly without going thru the dialog box. It seems that in some of my attempts it happened but not reliably. |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Attachments do not open automatically in Outlook 2016 | 417144 | Outlook | 0 | 01-10-2016 12:32 PM |
2016 Word for Mac - How open docs bigger? | wmth99 | Word | 0 | 12-25-2015 11:17 AM |
I cannot open .docx files even though I have MS Office 2016 | syeh11 | Word | 1 | 09-14-2015 10:16 PM |
Need to open an Excel WorkBook from Word VBA | Pierre-Hugues | Word VBA | 4 | 10-07-2013 06:27 AM |
Unable to open Excel 97-2003 workbook | J Partridge | Excel | 1 | 11-07-2010 03:26 AM |