Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
After OpenText all pastes from external apps use format from OpenText
I've used the OpenText method to open a txt file as space
delimited. The problem is is that after this macro has been run, whenever I try to paste into Excel from another application (Impromptu, Arthur), the data I'm pasting is inserted as if it's space delimited also. It's as if some property was altered with the OpenText method and was not reset, but I can't find any documentation on it. I have to exit out of Excel in order to get the pastes to work again. Any ideas? FYI: Excel 2000, Windows XP. TIA, Jim |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help - Alt-E hotkey does not work in MSOffice apps, no prob in other apps | Excel Discussion (Misc queries) | |||
Workbooks.OpenText | Excel Programming | |||
Using Workbooks.OpenText to read a tab-delimited file into a worksheet | Excel Programming | |||
How do I unprotect cells when using OpenText function? | Excel Programming | |||
OpenText bug ? | Excel Programming |