Hello!
I've got a worksheet with around 47 names. This will vary as staffing fluctuates.
I've got a secure website where each of these names are entered and/or searched for, at least once or twice a day.
Hitting alt+tab, I can copy from the worksheet, move to IE, move back to Excel while IE does its thing to recognize the name and moves it into a separate listbox, then go to the next row and repeat the process. It's fast but painstakingly redundant.
How would one use VBA to...
1) put the name from the active cell (a1, in most instances, unless there's an error--see below)
2) grab the next name while IE recognizes that name
3) put that name into IE
While...
1) waiting for the userform to recognize the name before entering another
2) stopping if there is an error (sometimes names are sent to me spelled differently than in the program in IE)
3) stopping the cycle at the last name on the list (a47 or so, right now)
The website isn't something I can share but I did pull this off the form in question:
[FONT="]
[/FONT]
I've got a worksheet with around 47 names. This will vary as staffing fluctuates.
I've got a secure website where each of these names are entered and/or searched for, at least once or twice a day.
Hitting alt+tab, I can copy from the worksheet, move to IE, move back to Excel while IE does its thing to recognize the name and moves it into a separate listbox, then go to the next row and repeat the process. It's fast but painstakingly redundant.
How would one use VBA to...
1) put the name from the active cell (a1, in most instances, unless there's an error--see below)
2) grab the next name while IE recognizes that name
3) put that name into IE
While...
1) waiting for the userform to recognize the name before entering another
2) stopping if there is an error (sometimes names are sent to me spelled differently than in the program in IE)
3) stopping the cycle at the last name on the list (a47 or so, right now)
The website isn't something I can share but I did pull this off the form in question:
[FONT="]
Rich (BB code):
<input class="item-entry-control-[/FONT]<wbr style="font-family: "Times New Roman", serif; font-size: 16px;">[FONT="]class add-edit-action-item-item-[/FONT]<wbr style="font-family: "Times New Roman", serif; font-size: 16px;">[FONT="]entry" id="singleLookup" type="text" placeholder="Search" data-bind="SingleItemEntry: {
Position: 'bottom',
[/FONT]<wbr style="font-family: "Times New Roman", serif; font-size: 16px;">[FONT="] ItemEntryDataProvider: ItemEntryDataProvider,
[/FONT]<wbr style="font-family: "Times New Roman", serif; font-size: 16px;">[FONT="] SelectedKey: SingleSelectedKey,
[/FONT]<wbr style="font-family: "Times New Roman", serif; font-size: 16px;">[FONT="] PlaceHolderText: $.t('wfo.Common:wfo.Search'),&[/FONT]<wbr style="font-family: "Times New Roman", serif; font-size: 16px;">[FONT="]#10; ReadOnly: IsLoading,
[/FONT]<wbr style="font-family: "Times New Roman", serif; font-size: 16px;">[FONT="] IsLoading: IsLoading,
[/FONT]<wbr style="font-family: "Times New Roman", serif; font-size: 16px;">[FONT="] ItemEntryName:'[/FONT]<wbr style="font-family: "Times New Roman", serif; font-size: 16px;">[FONT="]SingleItemEntryInMultiItemEntr[/FONT]<wbr style="font-family: "Times New Roman", serif; font-size: 16px;">[FONT="]y'
}">