Previous Topic Next Topic

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
Hello,
I am trying to copy content of a worksheet to a text file. What i want to know is how can i name the text file based on a given string in a particular cell. And the issue is that i do not need the complete cell content I want to drop/trim last 4 characters of the cell.
Eg: value in my cell A1 is "abhimanyu_wk2" and i want to create a text file with name only
abhimanyu.
I need script to copy content to text file from a worksheet and name the text file based on the cell A1(as in the example given above).

Any help would be highly appreciated.

Thanks,
Abhimanyu
Related:

1 response

Answer 1 / 1
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Mar 24, 2012 at 03:44 PM
lastFourChar = Right(Range("A1"), 4)

gives you last 4 characters of cell A1

ActiveWorkbook.SaveAs lastFourChar

Similar discussions

Hi Guys how to create an account for facebook with my company em
Ramu -
Ahmadzai -

Hello,
I am Facing a problem while signing up in facebook with my company email so please let me know how to create an account for facebook with my company email
i am getting this error message

It looks like you're trying to create an account for a business, organization or character. Please note that Facebook accounts are used to represent your real identity. Please create a Facebook Page instead.


Configuration: Windows Vista / Firefox 15.0

2 responses
How to create a .bin file?
lwm1017 -
dwebb -

I need to create a new .bin file by combining a mp3 file and a cdg file for playing on my daughter's karaoke machine. Any suggestions?

3 responses
Corel Draw: Error Reading file problem
clinton_fields2 -
clinton_fields2 -

Hello,

I have a group of files that I cannot open in CorelDraw. They were created a long time ago in Corel Draw 7.0 on a computer with windows 98. I re-installed Corel Draw 7.0 on my computer with windows2000 and now I get the error message "error reading /..../XXX.file CDR"
On the most critical file are loaded to 40% and then appears an error message. I can basically upload and store new files without any problems, but some (but not all) old files will be unreadable. I found an old hard drive and installed windows98 and CDR does not affect this. Also I installed the driver for the printer that (I think) has been used then no effect. Any suggestion ?

...

2 responses