Create a txt file and name it thru macro
Closed
abhi
-
Mar 10, 2012 at 12:49 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Mar 24, 2012 at 03:44 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Mar 24, 2012 at 03:44 PM
Related:
- Create a txt file and name it thru macro
- Windows 10 iso file download 64-bit - Download - Windows
- Ping to txt file - Guide
- Create skype account with gmail - Guide
- Kmspico zip file download - Download - Other
- Safari cannot open the page because it is a local file - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Mar 24, 2012 at 03:44 PM
Mar 24, 2012 at 03:44 PM
lastFourChar = Right(Range("A1"), 4)
gives you last 4 characters of cell A1
ActiveWorkbook.SaveAs lastFourChar
gives you last 4 characters of cell A1
ActiveWorkbook.SaveAs lastFourChar