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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
After OpenText all pastes from external apps use format from OpenText
I use this subroutine to deal with that irritation. Watch for
linewrap. Sub FixTextToColumns() Dim rngO As Range Application.ScreenUpdating = False On Error Resume Next Set rngO = ActiveSheet.UsedRange.SpecialCells(xlBlanks).Cells (1) If rngO Is Nothing Then Set rngO = ActiveSheet.Cells(1, 1) With rngO .Value = "Tim" .TextToColumns Destination:=rngO, DataType:=xlDelimited, TextQualifier:=xlDoubleQuote, _ ConsecutiveDelimiter:=False, Tab:=False, Semicolon:=False, Comma:=False, Space:=False, _ Other:=False, FieldInfo:=Array(1, 1) .ClearContents End With End Sub HTH Paul -------------------------------------------------------------------------------------------------------------- Be advised to back up your WorkBook before attempting to make changes. -------------------------------------------------------------------------------------------------------------- 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 |
Reply |
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 |