Hello,
Stumped on this one. I have a userform with a textbox to input item number(s) and two option buttons "upload" and "retrieve". when the code is run I would like it to doe the following:
If optionbutton1.value = true then
I'd like it to take the item number(s) to be put into a textfile (C:\Users\jmckibb\Desktop\My Stuff\text.txt) and include the Environ("username") and today's date in three columns, for example:
[TABLE="width: 500"]
<tbody>[TR]
[TD]Item_Nbr[/TD]
[TD]UserID[/TD]
[TD]Date[/TD]
[/TR]
[TR]
[TD]123456789[/TD]
[TD]klj1001[/TD]
[TD]12/19/18[/TD]
[/TR]
</tbody>[/TABLE]
The catch is if the item number already exists on the sheet then the userID and name need to be replaced with the current Environ("username") and today's date. This way we always have the last to update but do not have duplicates.
Elseif optionbutton2.value = true then
a new workbook is created and the texfile is imported into sheet1 into columns 1, 2 and 3.
End if
Any help appreciated. Thanks!
Stumped on this one. I have a userform with a textbox to input item number(s) and two option buttons "upload" and "retrieve". when the code is run I would like it to doe the following:
If optionbutton1.value = true then
I'd like it to take the item number(s) to be put into a textfile (C:\Users\jmckibb\Desktop\My Stuff\text.txt) and include the Environ("username") and today's date in three columns, for example:
[TABLE="width: 500"]
<tbody>[TR]
[TD]Item_Nbr[/TD]
[TD]UserID[/TD]
[TD]Date[/TD]
[/TR]
[TR]
[TD]123456789[/TD]
[TD]klj1001[/TD]
[TD]12/19/18[/TD]
[/TR]
</tbody>[/TABLE]
The catch is if the item number already exists on the sheet then the userID and name need to be replaced with the current Environ("username") and today's date. This way we always have the last to update but do not have duplicates.
Elseif optionbutton2.value = true then
a new workbook is created and the texfile is imported into sheet1 into columns 1, 2 and 3.
End if
Any help appreciated. Thanks!
