Drivingman
New Member
- Joined
- Jan 26, 2012
- Messages
- 19
- Office Version
- 365
- 2019
- Platform
- Windows
Hi All
Hoping you can help a VBA beginner.
I have data that I am copying from EXCEL 16, and pasting into EXCEL 07. Unfortunately no way around this backward paste. Customer still on old version.
I can manually paste the data in, but repetitive as have 5 days of data to paste.
When I use the following macro, it pastes it in as an image and not into the cells directly.
Sub TextBox1_Click()
'
' TextBox1_Click Macro
' Paste into Monday
'
'
With Sheets("Control")
.Range("d8").PasteSpecial xlPasteAll
End With
End Sub
When I have tried the following amended macro it generates an error.
Sub TextBox1_Click()
'
' TextBox1_Click Macro
' Paste into Monday
'
'
With Sheets("Control")
.Range("d8").PasteSpecial Format:="Text", Link:=False, DisplayAsIcon:= _
False
End With
End Sub
The data should be pasted into cells D8:L57 on sheet Control.
Once I have that sorted I then need to amend to paste Tuesday into D61:L110, and so on through to Friday.
On my front sheet I have 5 text boxes which I am hoping to have the 5 macros assigned to.
Hope this all makes sense.
TYIA.
Hoping you can help a VBA beginner.
I have data that I am copying from EXCEL 16, and pasting into EXCEL 07. Unfortunately no way around this backward paste. Customer still on old version.
I can manually paste the data in, but repetitive as have 5 days of data to paste.
When I use the following macro, it pastes it in as an image and not into the cells directly.
Sub TextBox1_Click()
'
' TextBox1_Click Macro
' Paste into Monday
'
'
With Sheets("Control")
.Range("d8").PasteSpecial xlPasteAll
End With
End Sub
When I have tried the following amended macro it generates an error.
Sub TextBox1_Click()
'
' TextBox1_Click Macro
' Paste into Monday
'
'
With Sheets("Control")
.Range("d8").PasteSpecial Format:="Text", Link:=False, DisplayAsIcon:= _
False
End With
End Sub
The data should be pasted into cells D8:L57 on sheet Control.
Once I have that sorted I then need to amend to paste Tuesday into D61:L110, and so on through to Friday.
On my front sheet I have 5 text boxes which I am hoping to have the 5 macros assigned to.
Hope this all makes sense.
TYIA.