Sep 25 2020 09:33 AM
Hi all
I'm after some help
I need to run print vba when cell is updated ( i have that vba )
but when i'm trying to share the file and open on the laptop so i can go around and scan bar code i have problem whit opening the file i can only download copy , i need it to be live update so my other pc can print the labels as i'm going and updating cell
any suggestions ?
Sep 25 2020 11:14 AM
Maybe this approach will help you in your project.
Range("C6").FormulaR1C1 = "=PfadName(3)"
I would be happy to know if I could help.
Nikolino
I know I don't know anything (Socrates)
* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.
Sep 25 2020 11:10 PM
Hi
so the idea is that when i scan slp in the are where is 123
and s/n where is 456
on a laptop
its live updates to my main pc where i have this file open and have my printer and print out the label
i have the vba for printing the lable as soon as you scan s/n
hope this helps
Sep 26 2020 09:07 AM