Thread: File Path Issue in Excel 2016 for Mac
View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.programming
Patrick[_19_] Patrick[_19_] is offline
external usenet poster
  
Posts: 8
Default File Path Issue in Excel 2016 for Mac
On 2018-03-11 16:27:29 +0000, colglbo said:

I have been using visual basic in Excel 2011 for Mac to open a file
and perform some operations on that file. The code to open the file is

Workbooks.Open Filename:= "Mac Backup:Data Files:Excel Files:Test
File.xlsx"

The difference between Excel 2011 and Excel 2016 for Mac is that you
must now write :

Workbooks.Open Filename:= "Mac Backup/Data Files/Excel Files/TestFile.xlsx"

Reply With QuoteReply With Quote