Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-16-2023, 09:48 PM
soroush.kalantari soroush.kalantari is offline Error when moving (copying) a excel sheet to another workbook. Windows 10 Error when moving (copying) a excel sheet to another workbook. Office 2016
Competent Performer
Error when moving (copying) a excel sheet to another workbook.
 
Join Date: Jun 2021
Posts: 124
soroush.kalantari is on a distinguished road
Default

Thank you for your reply. I have added one of my macros which sometimes encounters this error. (as I told, this issue is not related for a particular macro. And strangely it sometimes even occurs when I try to copy (move) sheets manually (without using macro))

Option Explicit



Sub saveboursview()
Dim ws0 As Workbook
Dim name0 As String
Application.DisplayAlerts = False
Set ws0 = ActiveWorkbook
Windows("tempalatecodal.xlsb").Activate
UserForm1.Show
name0 = Range("a1").Value
ws0.Activate
ActiveSheet.Copy Before:=Workbooks("tempalatecodal.xlsb").Sheets("u serform")
ActiveSheet.name = name0
Application.Run "'Personal.xlsb'!bourseview"
Application.Run "'Personal.xlsb'!replace0"
ws0.Close
Application.DisplayAlerts = True
End Sub

Last edited by soroush.kalantari; 10-17-2023 at 07:51 PM.
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
One veryhidden sheet, one hidden sheet and two visible sheets - how to saveas into .xlsm workbook kiwimtnbkr Excel Programming 4 06-26-2019 11:30 AM
Error when moving (copying) a excel sheet to another workbook. Copying a Sheet in a Workbook to Another with Destination-Need Values Instead of Formulas rsrasc Excel Programming 4 08-19-2018 04:00 PM
Error when moving (copying) a excel sheet to another workbook. Can a Data Source be one sheet in a multi-sheet Workbook nfotx Mail Merge 1 07-01-2015 12:55 AM
Error when moving (copying) a excel sheet to another workbook. Browse to a specific sheet in an excel workbook Sinister Excel 4 04-08-2014 05:53 PM
Range(Cell1,Cell2) Error on another workbook controlling some other workbook? tinfanide Excel Programming 1 02-09-2012 04:08 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:33 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft