Macro-Launch Notepad from Excel and save data in notepad and save with naming conventio

**hjaspaul** · 05-26-2016, 11:07 PM

**hjaspaul** · 05-27-2016, 02:03 AM

On second thought is this possible?

**cytop** · 05-27-2016, 02:06 AM

Yes, but why even bother with NotePad when you can save the text directly into a plain vanilla TXT file?

**hjaspaul** · 05-27-2016, 02:31 AM

Not sure what does plain vanilla TXT files mean..

I need it in TXT file because I will import these notepad files data to another application..

Not ure if that application can import this Vanilla TXT files.

**cytop** · 05-27-2016, 02:41 AM

Plain Vanilla

Yes, it can import them. Copying to NotePad to save is just introducing 2 additional steps.

Save a Range as Text

**hjaspaul** · 05-27-2016, 10:09 AM

HTML Code:

[/HTML]Thanks, This solves one part of my problem(which is copy/paste data in txt format).

Can you help me modify macro to add this feature -
I need to create macro where
a)It should automatically copy paste 1-1500 rows and paste them in Notepad and save notepad as Notepad 1.
b)Then it should copy paste values from 1501 to 3000 and paste them in Notepad and save notepad as Notepad 2.
c) Then it should copy paste values from 3001 to 4500 and paste them in Notepad and save notepad as Notepad 3.
d) and so on till the end of the Column1 values.

Here

Please Login or Register  to view this content.

**hjaspaul** · 05-27-2016, 10:20 AM

HTML Code:

[/HTML]Thanks, This solves one part of my problem(which is copy/paste data in txt format).

Can you help me modify macro to add this feature -
I need to create macro where
a)It should automatically copy paste 1-1500 rows and paste them in Notepad and save notepad as Notepad 1.
b)Then it should copy paste values from 1501 to 3000 and paste them in Notepad and save notepad as Notepad 2.
c) Then it should copy paste values from 3001 to 4500 and paste them in Notepad and save notepad as Notepad 3.
d) and so on till the end of the Column1 values.

Here

Please Login or Register  to view this content.

**hjaspaul** · 05-28-2016, 06:37 PM

Can someone help me to find the solution for the problem

Can you help me modify macro to add this feature -
I need to create macro where
a)It should automatically copy paste 1-1500 rows and paste them in Notepad and save notepad as Notepad 1.
b)Then it should copy paste values from 1501 to 3000 and paste them in Notepad and save notepad as Notepad 2.
c) Then it should copy paste values from 3001 to 4500 and paste them in Notepad and save notepad as Notepad 3.
d) and so on till the end of the Column1 values.

**cytop** · 05-28-2016, 08:21 PM

The link I posted shows you exactly how to do it, complete with a detailed explanation; all you need to do is loop for 1500 rows or until you reach the end of the list - and that is probably the most basic of programming in VBA

**hjaspaul** · 05-29-2016, 01:19 AM

Hi Cytop,

Thanks for the response, I dont now programming at all, thats why was seeking for help. I dont know how to modify the given code to abend it as per my requirements. Can you help me with that please?

**hjaspaul** · 05-29-2016, 11:00 PM

Need help on this problem. Kindly help experts

**cytop** · 05-30-2016, 01:51 AM

Cross posted.

**hjaspaul** · 06-01-2016, 09:19 PM

Following code solves my problem -

Please Login or Register  to view this content.

Macro-Launch Notepad from Excel and save data in notepad and save with naming conventio

LinkBack

Thread Tools

Rate This Thread

Display

Macro-Launch Notepad from Excel and save data in notepad and save with naming conventio

Re: Macro-Launch Notepad from Excel and save data in notepad and save with naming conventi

Re: Macro-Launch Notepad from Excel and save data in notepad and save with naming conventi

Re: Macro-Launch Notepad from Excel and save data in notepad and save with naming conventi

Re: Macro-Launch Notepad from Excel and save data in notepad and save with naming conventi

Re: Macro-Launch Notepad from Excel and save data in notepad and save with naming conventi

Re: Macro-Launch Notepad from Excel and save data in notepad and save with naming conventi

Re: Macro-Launch Notepad from Excel and save data in notepad and save with naming conventi

Re: Macro-Launch Notepad from Excel and save data in notepad and save with naming conventi

Re: Macro-Launch Notepad from Excel and save data in notepad and save with naming conventi

Re: Macro-Launch Notepad from Excel and save data in notepad and save with naming conventi

Re: Macro-Launch Notepad from Excel and save data in notepad and save with naming conventi

Re: Macro-Launch Notepad from Excel and save data in notepad and save with naming conventi

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Save Notepad through VBA Macro, having Copied Range of Cells, Pasted into notepad

[SOLVED] Export data to notepad, save and close

Using Send Keys to move data from Excel to Notepad and save as CSV

[SOLVED] Macro that Copy/paste a column to Notepad and Allows me to Save As in a specified folder

Help me in Copy the Values from Excel to Notepad and Save the Same.

Macro to Launch Notepad

[SOLVED] Create a macro to launch notepad while in Excel.

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions