Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Opening Notepad application from Excel macro
Hello,
How can I do the following: - Open Note pad application from an excel macro - Copy data from an excel worksheet into the newly opened Wordpad - Save as a name and close the Wordpad file Thanks!! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Opening Notepad application from Excel macro
Rafael,
Do you really need to use NotePad/WordPad ? It would be easier to save you data as a .csv or .txt file. Or write you own file with Open. Or even use a Rich Text Box. Depends what data/format you need, but using NotePad/WordPad should be your last option. NickHK "Rafael" wrote in message ... Hello, How can I do the following: - Open Note pad application from an excel macro - Copy data from an excel worksheet into the newly opened Wordpad - Save as a name and close the Wordpad file Thanks!! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Opening Notepad application from Excel macro
I agree with you. So How could I save a specific worksheet in excel in a txt
format, into a specific location? My data is in XML format and must be exactly the same format as is in the excel worsheet because it will serve to be input into another program which is very case sensitive. I would be interested however, out of curiosity, to know how to do the long the longer process I described previously. Thanks! "NickHK" wrote: Rafael, Do you really need to use NotePad/WordPad ? It would be easier to save you data as a .csv or .txt file. Or write you own file with Open. Or even use a Rich Text Box. Depends what data/format you need, but using NotePad/WordPad should be your last option. NickHK "Rafael" wrote in message ... Hello, How can I do the following: - Open Note pad application from an excel macro - Copy data from an excel worksheet into the newly opened Wordpad - Save as a name and close the Wordpad file Thanks!! |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Opening Notepad application from Excel macro
Excel 10 and up have built in support for XML.
Record a macro as you perform the save and see the code. Would that work ? NickHK "Rafael" wrote in message ... I agree with you. So How could I save a specific worksheet in excel in a txt format, into a specific location? My data is in XML format and must be exactly the same format as is in the excel worsheet because it will serve to be input into another program which is very case sensitive. I would be interested however, out of curiosity, to know how to do the long the longer process I described previously. Thanks! "NickHK" wrote: Rafael, Do you really need to use NotePad/WordPad ? It would be easier to save you data as a .csv or .txt file. Or write you own file with Open. Or even use a Rich Text Box. Depends what data/format you need, but using NotePad/WordPad should be your last option. NickHK "Rafael" wrote in message ... Hello, How can I do the following: - Open Note pad application from an excel macro - Copy data from an excel worksheet into the newly opened Wordpad - Save as a name and close the Wordpad file Thanks!! |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Opening Notepad application from Excel macro
I had tried this method before but the macro does not record the procedures
once I ckick outside Excel. What code should I use to get this process done automatically? "NickHK" wrote: Excel 10 and up have built in support for XML. Record a macro as you perform the save and see the code. Would that work ? NickHK "Rafael" wrote in message ... I agree with you. So How could I save a specific worksheet in excel in a txt format, into a specific location? My data is in XML format and must be exactly the same format as is in the excel worsheet because it will serve to be input into another program which is very case sensitive. I would be interested however, out of curiosity, to know how to do the long the longer process I described previously. Thanks! "NickHK" wrote: Rafael, Do you really need to use NotePad/WordPad ? It would be easier to save you data as a .csv or .txt file. Or write you own file with Open. Or even use a Rich Text Box. Depends what data/format you need, but using NotePad/WordPad should be your last option. NickHK "Rafael" wrote in message ... Hello, How can I do the following: - Open Note pad application from an excel macro - Copy data from an excel worksheet into the newly opened Wordpad - Save as a name and close the Wordpad file Thanks!! |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Opening Notepad application from Excel macro
Rafael,
Excel can only record actions within itself, not everywhere in Windows. It will give you code to .SaveAs in XML format. What you with the generated file is not a matter for Excel, although you can (probably) use VBA. Depends what you are doing. More details otherwise how can anyone answer NickHK "Rafael" ... I had tried this method before but the macro does not record the procedures once I ckick outside Excel. What code should I use to get this process done automatically? "NickHK" wrote: Excel 10 and up have built in support for XML. Record a macro as you perform the save and see the code. Would that work ? NickHK "Rafael" wrote in message ... I agree with you. So How could I save a specific worksheet in excel in a txt format, into a specific location? My data is in XML format and must be exactly the same format as is in the excel worsheet because it will serve to be input into another program which is very case sensitive. I would be interested however, out of curiosity, to know how to do the long the longer process I described previously. Thanks! "NickHK" wrote: Rafael, Do you really need to use NotePad/WordPad ? It would be easier to save you data as a .csv or .txt file. Or write you own file with Open. Or even use a Rich Text Box. Depends what data/format you need, but using NotePad/WordPad should be your last option. NickHK "Rafael" wrote in message ... Hello, How can I do the following: - Open Note pad application from an excel macro - Copy data from an excel worksheet into the newly opened Wordpad - Save as a name and close the Wordpad file Thanks!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel opening from other application | Excel Discussion (Misc queries) | |||
Create a macro to launch notepad while in Excel. | Excel Programming | |||
Opening a different application from Excel | Excel Programming | |||
Opening Notepad from Code | Excel Programming | |||
opening and writing into notepad | Excel Programming |