run micros / vba

%3CLINGO-SUB%20id%3D%22lingo-sub-1713710%22%20slang%3D%22en-US%22%3Erun%20micros%20%2F%20vba%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1713710%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20after%20some%20help%3C%2FP%3E%3CP%3EI%20need%20to%20run%20print%20vba%20when%20cell%20is%20updated%20(%20i%20have%20that%20vba%20)%3C%2FP%3E%3CP%3Ebut%20when%20i'm%20trying%20to%20share%20the%20file%20and%20open%20on%20the%20laptop%20so%20i%20can%20go%20around%20and%20scan%20bar%20code%20i%20have%20problem%26nbsp%3B%20whit%20opening%20the%20file%20i%20can%20only%20download%20copy%20%2C%20i%20need%20it%20to%20be%20live%20update%20so%20my%20other%20pc%20can%20print%20the%20labels%20as%20i'm%20going%20and%20updating%20cell%26nbsp%3B%3C%2FP%3E%3CP%3Eany%20suggestions%20%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1713710%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1714041%22%20slang%3D%22de-DE%22%3ESubject%3A%20run%20micros%20%2F%20vba%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1714041%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F722142%22%20target%3D%22_blank%22%3E%40beikme%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMaybe%20this%20approach%20will%20help%20you%20in%20your%20project.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3ERange(%22C6%22).FormulaR1C1%20%3D%20%22%3DPathName(3)%22%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CDIV%20class%3D%22text-wrap%20tlid-copy-target%22%3E%3CDIV%20class%3D%22result-shield-container%20tlid-copy-target%22%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%20class%3D%22%22%3EIf%20I%20may%20recommend%20you%20add%20a%20file%20(without%20sensitive%20data).%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3ESo%20help%20yourself%20to%20get%20a%20quick%20answer%20and%20to%20be%20able%20to%20propose%20the%20best%20possible%20solution%20to%20all%20others%20who%20want%20to%20help%20you.%3C%2FSPAN%3E%20%3CSPAN%3EWin-win%20for%20everyone.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3EWith%20your%20brief%20description%2C%20I%20can%20only%20guess%20whether%20that%20or%20this%20is.%3C%2FSPAN%3E%3CBR%20%2F%3EIt%20is%20also%20an%20advantage%20if%20you%20name%20your%20operating%20system%20and%20Office%20version.%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3EThank%20you%20for%20letting%20me%20suggest%20an%20approach%20%2F%20solution%20%2F%20help.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FDIV%3E%3C%2FDIV%3E%3CDIV%20class%3D%22tlid-result-transliteration-container%20result-transliteration-container%20transliteration-container%22%3E%3CDIV%20class%3D%22tlid-transliteration-content%20transliteration-content%20full%22%3E%26nbsp%3B%3C%2FDIV%3E%3C%2FDIV%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20be%20happy%20to%20know%20if%20I%20could%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CFONT%20size%3D%221%202%203%204%205%206%207%22%3E*%20Kindly%20Mark%20and%20Vote%20this%20reply%20if%20it%20helps%20please%2C%20as%20it%20will%20be%20beneficial%20to%20more%20community%20members%20reading%20here.%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1715646%22%20slang%3D%22en-US%22%3EBetreff%3A%20run%20micros%20%2F%20vba%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1715646%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F722750%22%20target%3D%22_blank%22%3E%40Nikolino%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%26nbsp%3B%3C%2FP%3E%3CP%3Eso%20the%20idea%20is%20that%20when%20i%20scan%20slp%20in%20the%20are%20where%20is%20123%26nbsp%3B%3C%2FP%3E%3CP%3Eand%20s%2Fn%20where%20is%20456%3C%2FP%3E%3CP%3Eon%20a%20laptop%26nbsp%3B%3C%2FP%3E%3CP%3Eits%20live%20updates%26nbsp%3B%20to%20my%20main%20pc%20where%20i%20have%20this%20file%20open%20and%20have%20my%26nbsp%3B%20printer%20and%20print%20out%20the%20label%26nbsp%3B%3C%2FP%3E%3CP%3Ei%20have%20the%20vba%20for%20printing%20the%20lable%20as%20soon%20as%20you%20scan%20s%2Fn%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ehope%20this%20helps%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Contributor

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 ?

3 Replies
Highlighted

@beikme 

 

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.
 

 

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.

Highlighted

@Nikolino 

 

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 

Highlighted
There 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-featur...

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)