Re: $$Excel-Macros$$ How to assign userselected path to variable

2014-10-22 Thread Paul Schreiner
e you can, As long as ever you can.” - John Wesley - > > From: Dr. Schwartz >To: excel-macros@googlegroups.com >Cc: schreiner_p...@att.net >Sent: Wednesday, October 22, 2014 2:57 AM >Subject: Re: $$Excel-Macros$$ How to assign u

Re: $$Excel-Macros$$ How to assign userselected path to variable

2014-10-21 Thread Dr. Schwartz
ll the means you can,In all the ways you > can,In all the places you can,At all the times you can,To all the people > you can,As long as ever you can.” - John Wesley* > - > >*From:* Dr. Schwartz > > *To:* excel-...@googlegro

Re: $$Excel-Macros$$ How to assign userselected path to variable

2014-10-21 Thread Dr. Schwartz
excel-...@googlegroups.com > *Sent:* Tuesday, October 21, 2014 4:05 AM > *Subject:* $$Excel-Macros$$ How to assign userselected path to variable > > In Excel 2010 I was trying to use the GetSaveAsFilename to obtain path and > file name, but not save the file. My problem is that it do

Re: $$Excel-Macros$$ How to assign userselected path to variable

2014-10-21 Thread Paul Schreiner
er you can.” - John Wesley - From: Dr. Schwartz >To: excel-macros@googlegroups.com >Sent: Tuesday, October 21, 2014 4:05 AM >Subject: $$Excel-Macros$$ How to assign userselected path to variable > > > >In Excel 2010 I was trying to use

Re: $$Excel-Macros$$ How to assign userselected path to variable

2014-10-21 Thread Paul Schreiner
: Dr. Schwartz >To: excel-macros@googlegroups.com >Sent: Tuesday, October 21, 2014 4:05 AM >Subject: $$Excel-Macros$$ How to assign userselected path to variable > > > >In Excel 2010 I was trying to use the GetSaveAsFilename to obtain path and >file name, but not save the

$$Excel-Macros$$ How to assign userselected path to variable

2014-10-21 Thread Dr. Schwartz
In Excel 2010 I was trying to use the GetSaveAsFilename to obtain path and file name, but not save the file. My problem is that it does not work in a folder with restricted access. In my example the user only has permission to read and add and the GetSaveAsFilename appears to create a temporary