Forum Discussion
beikme
Sep 25, 2020Brass Contributor
run micros / vba
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 h...
NikolinoDE
Sep 25, 2020Platinum Contributor
Maybe this approach will help you in your project.
Range("C6").FormulaR1C1 = "=PfadName(3)"
If I may recommend you add a file (without sensitive data).
Thus help yourself to get a quick answer and to be able to propose the best possible solution to all others who want to help you. Win-win for everyone.
With your brief description, I can only guess whether that or this is.
It is also an advantage if you name your operating system and Office version.
Thank you for letting me suggest an approach / solution / help.
Thus help yourself to get a quick answer and to be able to propose the best possible solution to all others who want to help you. Win-win for everyone.
With your brief description, I can only guess whether that or this is.
It is also an advantage if you name your operating system and Office version.
Thank you for letting me suggest an approach / solution / help.
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.
- beikmeSep 26, 2020Brass Contributor
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
- NikolinoDESep 26, 2020Platinum ContributorThere you will find many examples that will help you.
Conditional Printing
https://excel.tips.net/T002372_Conditional_Printing.html
Please note that not everything and not all Sharepoint servers can be executed on VBA macros.
SharePoint capabilities
https://docs.microsoft.com/en-gb/sharepoint/dev/general-development/supported-and-unsupported-features
I would be happy to know if I could help.
Nikolino
I know I don't know anything (Socrates)
I would be happy to know if I could help.
Nikolino
I know I don't know anything (Socrates)