Good day all,
Struggling with this 'click' functionality. I have seen some instances where vba can be used to call a click function to occur. I am currently struggling with it. Mimicing lines of code is not working and I am curious if this is due to a naming issue, or that I have too much else taking place with the other vba routine that there is generated conflict.
I am recieving a Run-time error '424':
Object required
This occurs when the searched for information is not appearing in the requested file. It is hung up when trying to close the document. Here is the code:
Here is the code that looks like it should perform the click function but clearly is not:
I have tried everything I can think of to get this switch to function correctly. I can import data from the original file with other instances of Excel open. I can also have 1 instance and other workbooks open. So that doesn't seem to be my hardship, I'm hoping someone may have another idea. FYI the buttons name is 'Import' and in the same case as referenced. Is 'Import' and illegal term to use for a button name?
Struggling with this 'click' functionality. I have seen some instances where vba can be used to call a click function to occur. I am currently struggling with it. Mimicing lines of code is not working and I am curious if this is due to a naming issue, or that I have too much else taking place with the other vba routine that there is generated conflict.
I am recieving a Run-time error '424':
Object required
This occurs when the searched for information is not appearing in the requested file. It is hung up when trying to close the document. Here is the code:
Code:
If ia > 16382 Then
MsgBox "SN was not found in the document(s), ensure the SN and Issue# match output file(s)."
Application.ScreenUpdating = True
Range("A3").Select
SRC_Workbook.Save 'need to store when import_click functionality is present
SCR_Workbook.Close
GoTo Leave
End If
Here is the code that looks like it should perform the click function but clearly is not:
Code:
Worksheets("DATA").Select
Worksheets("DATA").Activate
ActiveWorkbook.Sheets("Data").Import.Value = True ' Import_Click from Tabulated Data sheets
I have tried everything I can think of to get this switch to function correctly. I can import data from the original file with other instances of Excel open. I can also have 1 instance and other workbooks open. So that doesn't seem to be my hardship, I'm hoping someone may have another idea. FYI the buttons name is 'Import' and in the same case as referenced. Is 'Import' and illegal term to use for a button name?