pubfert.blogg.se - Flatout 2 runtime error

FLATOUT 2 RUNTIME ERROR UPDATE
FLATOUT 2 RUNTIME ERROR PRO
FLATOUT 2 RUNTIME ERROR CODE
FLATOUT 2 RUNTIME ERROR WINDOWS

TemplateSheet.Copy After:=indexSheet 'LOCATION OF ERROR!!! 'Copy template sheet to after traceability matrix sheet

FLATOUT 2 RUNTIME ERROR UPDATE

'If test case name is unique, update workbook MsgBox ("This test case name is already in use. 'If test case name already exists, show error message If ThisWorkbook.Worksheets(i).Name = TestCaseNameBox.Value Then 'the same name exists, set boolean to true 'If the userform fields are completed and a worksheet with If ScenarioNameBox.Value = "" Or TestCaseNameBox.Text = "" Then 'If the userform fields are empty then show error message

'Get file path of this workbook and set it to string Set Tbl = indexSheet.ListObjects("TMatrix") Set templateSheet = ThisWorkbook.Sheets("TestCase_Template") Set indexSheet = ThisWorkbook.Sheets("Traceability Matrix") ShowShapes = Array("TextBox 15", "TextBox 14", "TextBox 13", "TextBox 11", "StatsRec", "Button 10") HideShapes = Array("TextBox 2", "Rectangle 1") 'Create array of shapes based on visibility rules 'Dont update the screen while the macro runsĭim indexSheet As Worksheet, templateSheet As Worksheetĭim templateCopy As Worksheet, newSheet As Worksheetĭim hideShapes() As Variant, showShapes() As Variantĭim hideGroup As Object, showGroup As Object

FLATOUT 2 RUNTIME ERROR CODE

I have included all the code from my UserForm. Any suggestions to my code, relevant to this issue or not, are greatly appreciated. I found this code online: wb.SaveĪpplication.OnTime Now + TimeValue("00:00:01"), (filePath)Īs I stated, I am new to VBA, coding, and this site. Obviously, this is time consuming and not efficient. The only thing that prevents this error is code to save, close, and reopen the file.

Made sure all calls to sheets included specific "path" (ThisWorkbook.).

Copy and paste the new template sheet without specifying where to put it.

Create a separate Excel template file and call that from the userform.

Keep templateSheet visible at all times.

At first, I thought it may be a memory issue but I think this is a pretty simple file, something excel and my desktop should be able to handle. The code I provide at the end of this post is the majority of the code within the file.

FLATOUT 2 RUNTIME ERROR PRO

Bizzarly, the file works PERFECTLY on my 2013 MacBook pro with Excel 2011.

FLATOUT 2 RUNTIME ERROR WINDOWS

This happens on windows with Excel 2010, 2011, and 2016 (I've yet to test other versions on Excel) on a range of Windows versions. On the 22nd run, without fail, the automation error pops up and Excel crashes.

There is additional code that adds values to cells on multiple sheets and formats that text.Īll of this works perfectly for 21 runs.

A table on the homepage gets a new row and a hyperlink to the new sheet is added.If the name doesn't exist, a hidden template sheet (templateSheet) is copied and pasted after the homepage sheet (indexSheet) and renamed based on the user input.If the name exists, it tells the user to choose a different name.The code (all in the userform) checks all worksheet names. The userform has two fields asking the user to enter names. I've created a userform and a form control button. TemplateSheet and indexSheet are defined references to specific worksheets The gist of what happens within this part of my file:

SO frustrating! I have managed to locate the line of code that causes this: templateSheet.Copy After:=indexSheet If I click debug, end, or help, Excel crashes and (sometimes) reopens an recovered file. The object invoked has disconnected from its clients." I have searched this site (and many others) and found many people with this same error, but their resolutions are irrelevant and/or don't solve my problem. I am trying to complete and refine my file, but I have run into a error that I cannot seem to fix or even understand. I am new to VBA (and Excel for that matter) so please keep that in mind when reviewing my code.