5 Excel Work sheets are open - 1 macro enabled file

[Rohith1324]

Hi,

Users are having 5 or more excel sheets open in their system and out of which one File is macro Enabled file ( which will be interacting with Web Page ).

when the VBA code is running and interacting with Web Page users are unable to work on any other worksheets open in their system.

do we have any way to free the other Worksheets so that users can do their work in normal worksheets.

Regards,
Rohith M

 

[Joe4]

Did you try opening them in a separate instance of Excel?
See: 4 Ways to Open Multiple Instances of Excel - Excel Gorilla

 

[Rohith1324]

Did you try opening them in a separate instance of Excel?
See: 4 Ways to Open Multiple Instances of Excel - Excel Gorilla

Thanks for letting me know that there is an option of doing it...
I would need your support - Can you help me with VBA Code method included in my existing code....so that when the code execution start it will start in a new Instance... ( or) may be the code enables as soon as this VBA Code Spreadsheet is opened in other instance.

would you please able to help ...

my Code is as below :

Sub tstsitesubmission()
Dim bot As New WebDriver, ele As WebElement
Dim C As Range
Dim i As Integer
Dim OName As String
Dim Aname As String
Dim Tname As String

'bot.AddArgument ("headless")
'bot.AddArgument "window-size=1920,1080"
bot.Start "Chrome", "testsite.com"
bot.Window.Maximize
bot.Get "https:testsite.com"
bot.Wait 500
bot.FindElementByXPath("//*[@id='userNme']").SendKeys ActiveSheet.Range("B1").Value
bot.FindElementByXPath("//*[@id='passwd']").SendKeys ActiveSheet.Range("B3").Value
bot.SendKeys bot.Keys.Tab
bot.SendKeys bot.Keys.Enter
For Each C In Range("A6:A" & Cells(Rows.Count, "A").End(xlUp).Row).Cells
bot.Timeouts.PageLoad = 40000
OName = C.Offset(0, 12).Value
Aname = C.Offset(0, 13).Value
Tname = C.Offset(0, 14).Value
Debug.Print OName
Debug.Print Aname
Debug.Print Tname
DoEvents
bot.Wait 400
bot.FindElementByXPath("//*[@id='createNewForm']/div[3]/div/div/button/span[1]", timeout:=40000).WaitEnabled(True).Click
bot.FindElementByXPath("//*[@id='createNewForm']/div[3]/div/div/div/ul/li[" & OName & "]/a/span[1]", timeout:=40000).WaitEnabled(True).Click
bot.Wait 200
bot.FindElementByXPath("//*[@id='cpoNo']").SendKeys C.Offset(0, 4).Value
bot.Wait 200
bot.FindElementByXPath("//*[@id='reqDesc']").SendKeys C.Offset(0, 5).Value
bot.FindElementByXPath("//*[@id='main']/div[2]").ScrollIntoView
bot.SendKeys bot.Keys.Tab
bot.FindElementByXPath("//*[@id='createFormsubmit']").Click
Next C
MsgBox "Task Completed"
End Sub

 

[Joe4]

I am not sure how to open another instance of Excel with VBA code.
I do a search and found a few old threads on it. This one looked like it might be promising: Open NEw instance of Excel through MAcro

Sorry, that is the best I can do.