Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Paradox then paste into excel
Hello from Steved. Please is the below possible.
The below VBA will allow me to type City and it will change to 1-City. Can the below be taken one step further, I copy from Paradox then paste into excel worksheet which has the below VBA. Is it possible when I paste it from Paradox into the excel worksheet it will find City then change it to 1_City. Thankyou. Private Sub Worksheet_Change(ByVal Target As Range) Application.EnableEvents = False On Error GoTo ws_exit With Target Select Case UCase(Left(.Value, 4)) Case "CITY": .Value = "1-City" End Select End With ws_exit: Application.EnableEvents = True End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel to Word : Paste specialPaste Link Excel Chart Obj doesn't | Charts and Charting in Excel | |||
Excel 2007 Pivot Table from a Paradox File | Excel Discussion (Misc queries) | |||
Paste and Paste Special No Longer Working - Excel 2003 | Excel Discussion (Misc queries) | |||
data from Paradox to Excel | Setting up and Configuration of Excel | |||
import paradox database into excel | Excel Discussion (Misc queries) |