drtopserv
asked on
formattig excel from access
Hi
I am using this code from access vba that apply format column from 1 excel to another :
xlsheet2.range("E7:E50000").Copy
Set xlSheet = xlBook.Sheets(3)
xlApp.Visible = True
Set rsCurr = CurrentDb.QueryDefs("qtblS ubtractedB iWeeklyRep ort").Open Recordset
xlSheet.range("A7").CopyFr omRecordse t rsCurr
xlSheet.range("E7:E50000") .PasteSpec ial Paste:=-4163, Operation:=-4142, SkipBlanks:=True
i got pop-up massege that ask me to confirm OK :
"Data on the clipboard is not the same size and shape as the selected area. Do you want to paste the data anyway?"
How can i solve and cancel this massege?
I am using this code from access vba that apply format column from 1 excel to another :
xlsheet2.range("E7:E50000").Copy
Set xlSheet = xlBook.Sheets(3)
xlApp.Visible = True
Set rsCurr = CurrentDb.QueryDefs("qtblS
xlSheet.range("A7").CopyFr
xlSheet.range("E7:E50000")
i got pop-up massege that ask me to confirm OK :
"Data on the clipboard is not the same size and shape as the selected area. Do you want to paste the data anyway?"
How can i solve and cancel this massege?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Great , works!
Open in new window