Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > microsoft.public.excel.programming > #110592
| From | "Peter T" <askformy@gmail.com> |
|---|---|
| Newsgroups | microsoft.public.excel.programming |
| Subject | Re: File Path Issue in Excel 2016 for Mac |
| Date | 2018-04-23 22:11 +0100 |
| Organization | A noiseless patient Spider |
| Message-ID | <pbli5o$ig1$1@dont-email.me> (permalink) |
| References | <g2maaddpsctst3hgn6kt5c9u6kt17gpugf@4ax.com> <xvUzC.19673$q_2.14995@fx17.iad> |
"Robert Baer" <robertbaer@localnet.com> wrote in message > colglbo wrote: >> 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" >> >> Mac Backup is the name of a removable drive. >> >> The code has worked fine until I upgraded to Excel 2016 for Mac. Now >> when I run the code I get the message "Sorry, we couldn't find Mac >> Backup:Data Files:Excel Files:Test File.xlsx." >> >> I have changed the colon to back slash and forward slash and still get >> the error message. This same code works fine in Excel 2016 for PC >> using the back slash. Apparently something has changed in the file >> path structure in the Excel 2016 version for Mac. Any help would be >> appreciated. >> > Typical M$ garbage - remove useful functionality and say nothing. Seems it was Apple that changed things - https://macadmins.software/docs/UserContentIn2016.pdf https://www.rondebruin.nl/mac/mac034.htm There's a mountain of related links. > They totally diddled file open/write as follows: > ActivePrinter = "Acrobat PDFWriter on FILE:" > ' Above sets printer in Excel 2003; will crash in Excel 2010. > ' In "modern" defective Excel apps, following prints to default as a > ' file AND prompts file name; file in printer format, NOT in PDF format. > ActiveWindow.SelectedSheets.PrintOut Copies:=1, Preview:=False, _ > ActivePrinter:="Acrobat PDFWriter on FILE:", PrintToFile:=True, _ > Collate:=False, PrToFilename:=pPath + vNam > Kill pPath + vNam 'only PDF left There could be several reasons. Here and when you posted your problem you didn't give any context. You were offered a possible solution but unless I miised it you didn't reply. Peter T
Back to microsoft.public.excel.programming | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread
File Path Issue in Excel 2016 for Mac colglbo <bcolglbo@gmail.com> - 2018-03-11 12:27 -0400
Re: File Path Issue in Excel 2016 for Mac "Auric__" <not.my.real@email.address> - 2018-03-11 18:40 +0000
Re: File Path Issue in Excel 2016 for Mac GS <gs@v.invalid> - 2018-03-11 18:16 -0400
Re: File Path Issue in Excel 2016 for Mac "Auric__" <not.my.real@email.address> - 2018-03-11 22:43 +0000
Re: File Path Issue in Excel 2016 for Mac GS <gs@v.invalid> - 2018-03-11 18:50 -0400
Re: File Path Issue in Excel 2016 for Mac "Auric__" <not.my.real@email.address> - 2018-03-12 03:46 +0000
Re: File Path Issue in Excel 2016 for Mac GS <gs@v.invalid> - 2018-03-12 01:08 -0400
Re: File Path Issue in Excel 2016 for Mac "Auric__" <not.my.real@email.address> - 2018-03-12 06:00 +0000
Re: File Path Issue in Excel 2016 for Mac GS <gs@v.invalid> - 2018-03-12 04:04 -0400
Re: File Path Issue in Excel 2016 for Mac "Peter T" <askformy@gmail.com> - 2018-03-14 17:34 +0000
Re: File Path Issue in Excel 2016 for Mac GS <gs@v.invalid> - 2018-03-15 02:25 -0400
Re: File Path Issue in Excel 2016 for Mac Patrick <patrick@nowhere.invalid> - 2018-03-12 07:59 +0100
Re: File Path Issue in Excel 2016 for Mac colglbo <bcolglbo@gmail.com> - 2018-03-12 07:47 -0400
Re: File Path Issue in Excel 2016 for Mac Robert Baer <robertbaer@localnet.com> - 2018-04-12 19:22 -0700
Re: File Path Issue in Excel 2016 for Mac GS <gs@v.invalid> - 2018-04-13 08:46 -0400
Re: File Path Issue in Excel 2016 for Mac Robert Baer <robertbaer@localnet.com> - 2018-04-16 21:48 -0700
Re: File Path Issue in Excel 2016 for Mac "Peter T" <askformy@gmail.com> - 2018-04-20 19:50 +0100
Re: File Path Issue in Excel 2016 for Mac Robert Baer <robertbaer@localnet.com> - 2018-04-21 00:17 -0700
Re: File Path Issue in Excel 2016 for Mac GS <gs@v.invalid> - 2018-04-21 05:00 -0400
Re: File Path Issue in Excel 2016 for Mac "Peter T" <askformy@gmail.com> - 2018-04-23 22:19 +0100
Re: File Path Issue in Excel 2016 for Mac "Peter T" <askformy@gmail.com> - 2018-04-23 22:11 +0100
Re: File Path Issue in Excel 2016 for Mac Robert Baer <robertbaer@localnet.com> - 2018-04-23 21:07 -0700
csiph-web