Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > microsoft.public.excel.programming > #110509 > unrolled thread

File Path Issue in Excel 2016 for Mac

Started bycolglbo <bcolglbo@gmail.com>
First post2018-03-11 12:27 -0400
Last post2018-04-23 21:07 -0700
Articles 2 on this page of 22 — 6 participants

Back to article view | Back to microsoft.public.excel.programming

Contents

  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

Page 2 of 2 — ← Prev page 1 [2]

#110592

From"Peter T" <askformy@gmail.com>
Date2018-04-23 22:11 +0100
Message-ID<pbli5o$ig1$1@dont-email.me>
In reply to#110574
"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

[toc] | [prev] | [next] | [standalone]

#110594

FromRobert Baer <robertbaer@localnet.com>
Date2018-04-23 21:07 -0700
Message-ID<O3yDC.12898$nq5.7141@fx36.iad>
In reply to#110592
Peter T wrote:
> "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
>
>
>
   So far, the ONLY solution that actually worked, was the one i posted, 
and only in Excel 2003.
   Certainly NOT in Excel 2010 that was purported to "do everything".

[toc] | [prev] | [standalone]

Page 2 of 2 — ← Prev page 1 [2]

Back to top | Article view | microsoft.public.excel.programming

csiph-web