Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro
is it possible to control Notepad from a macro ie open a new notepad, paste
data in and then save as. If so how do i call notepad in VB thanks in advance |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro
Not sure why you don't just save the Excel file as TEXT, Paste data (use
PasteSpecial Text only") into new Excell Workbook and save as Text. You could open Word and paste data into word and then save word as a text document. "Arnie" wrote: is it possible to control Notepad from a macro ie open a new notepad, paste data in and then save as. If so how do i call notepad in VB thanks in advance |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro
You can open notepad with the following statements and then change the focus
to the NotePad window with these commands Root = Environ("SystemRoot") ID = Shell(Root & "\Notepad.exe") AppActivate ID Use copy commnd from excel to put data into Cliupbord before opening Notepad and changing the focus. Then use "SendKey" commnd to send the key stokes required to Notepad. You can use the ShortCuts in NotePad like Cntl+V to paste. "Arnie" wrote: is it possible to control Notepad from a macro ie open a new notepad, paste data in and then save as. If so how do i call notepad in VB thanks in advance |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro
Thanks i did find this
Shell "notepad.exe", vbNormalFocus Application.SendKeys ("^V") which works for opening and pasting but i can't find anything for SaveAs i am selecting data from different sheets in excel then using notepad to paste this data into. the notepad is then saved as a script file. Hence the need to control notepad "Joel" wrote: You can open notepad with the following statements and then change the focus to the NotePad window with these commands Root = Environ("SystemRoot") ID = Shell(Root & "\Notepad.exe") AppActivate ID Use copy commnd from excel to put data into Cliupbord before opening Notepad and changing the focus. Then use "SendKey" commnd to send the key stokes required to Notepad. You can use the ShortCuts in NotePad like Cntl+V to paste. "Arnie" wrote: is it possible to control Notepad from a macro ie open a new notepad, paste data in and then save as. If so how do i call notepad in VB thanks in advance |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro
My code is equivalent to yours but is more robust by specifying the ID
(incase multiple NotePad applications are open) and wil work if a different folder is the default folder. Root = Environ("SystemRoot") ID = Shell(Root & "\Notepad.exe", vbNormalFocus) SendKeys "^v", Wait:=True SendKeys "^s", Wait:=True SendKeys "%n", Wait:=True SendKeys "c:\temp\abc.txt{Enter}", Wait:=True "Arnie" wrote: Thanks i did find this Shell "notepad.exe", vbNormalFocus Application.SendKeys ("^V") which works for opening and pasting but i can't find anything for SaveAs i am selecting data from different sheets in excel then using notepad to paste this data into. the notepad is then saved as a script file. Hence the need to control notepad "Joel" wrote: You can open notepad with the following statements and then change the focus to the NotePad window with these commands Root = Environ("SystemRoot") ID = Shell(Root & "\Notepad.exe") AppActivate ID Use copy commnd from excel to put data into Cliupbord before opening Notepad and changing the focus. Then use "SendKey" commnd to send the key stokes required to Notepad. You can use the ShortCuts in NotePad like Cntl+V to paste. "Arnie" wrote: is it possible to control Notepad from a macro ie open a new notepad, paste data in and then save as. If so how do i call notepad in VB thanks in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro recorded... tabs & file names changed, macro hangs | Excel Worksheet Functions | |||
Macro to copy and paste values (columns)I have a macro file built | Excel Programming | |||
how to count/sum by function/macro to get the number of record to do copy/paste in macro | Excel Programming | |||
macro to delete entire rows when column A is blank ...a quick macro | Excel Programming | |||
Start Macro / Stop Macro / Restart Macro | Excel Programming |