Trevor3007
Well-known Member
- Joined
- Jan 26, 2017
- Messages
- 667
- Office Version
- 365
- Platform
- Windows
Hi,
I have heard that it is possible to save a Excel workbook as the tab name & to a specific location ( example c:\data\testme\ . xls or *.xlsm) If this is possible,
can the coder please include a 'message/ input box' to give the option to save as either
if not MACRO workbook
= c:\testdata\workbook\*.xls
If macro
= c:\testdata\workbook\macro\*.xlsm
If Both
= c:\testdata\workbook\*.xls
and
= c:\testdata\workbook\macro\*.xlsm
If not to save
Stop
Hoping this makes sense and I thank you all , but especially the person or persons who takes steps up to the challenge.
I have heard that it is possible to save a Excel workbook as the tab name & to a specific location ( example c:\data\testme\ . xls or *.xlsm) If this is possible,
can the coder please include a 'message/ input box' to give the option to save as either
if not MACRO workbook
= c:\testdata\workbook\*.xls
If macro
= c:\testdata\workbook\macro\*.xlsm
If Both
= c:\testdata\workbook\*.xls
and
= c:\testdata\workbook\macro\*.xlsm
If not to save
Stop
Hoping this makes sense and I thank you all , but especially the person or persons who takes steps up to the challenge.