Skip to content

UiPath invoke VBA Script 2way(Excel Macro, Invoke VBA) ๐Ÿ”ฌ

Notifications You must be signed in to change notification settings

labft3231/VBABasic

Folders and files

NameName
Last commit message
Last commit date

Latest commit

ย 

History

5 Commits
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 

Repository files navigation

UiPath invoke VBA 2way(Excel Macro, Invoke VBA) ๐Ÿ”ฌ

UiPath์—์„œ VBA๋ฅผ ํ™œ์šฉํ•˜๋Š” 2๊ฐ€์ง€ ๋ฐฉ๋ฒ•์œผ๋กœ ๋‚˜๋ˆ„์–ด์ ธ ์žˆ๋‹ค. ์–ด๋–ค ๊ฒƒ์„ ํ™œ์šฉํ• ์ง€์— ๋Œ€ํ•ด์„œ ์•„๋ž˜์˜ 2๊ฐ€์ง€ ๋ฐฉ๋ฒ•์„ ๋ณด๊ณ  ํŒ๋‹จํ•˜๋ฉด ๋œ๋‹ค.



  1. Excel Macro Activity ํ™œ์šฉ
- ์ด๊ฑด VBA๊ฐ€ ์ด๋ฏธ ์ž…๋ ฅ์ด ๋˜์–ด ์žˆ๋Š” Excel์—์„œ ํ™œ์šฉ์ด ๊ฐ€๋Šฅํ•˜๋‹ค.
- ๊ธฐ์กด ์—‘์…€์— ์ž…๋ ฅ๋œ VBA๋ฅผ ํ™œ์šฉํ•˜๊ธฐ ๋•Œ๋ฌธ์— ์—‘์…€ ๋‚ด๋ถ€์˜ Alt + F11 ๋ฅผ ํ†ตํ•ด์„œ 
ํ™œ์šฉํ•  VBA ์†Œ์Šค์˜ ํ•จ์ˆ˜๋ฅผ ๊ธฐ์–ตํ•˜๊ณ  UiPath Studio ๋‚ด์— ์‚ฌ์šฉํ•  ๋ฉ”ํฌ๋กœ ํ•จ์ˆ˜๋ช…์„ ์ž…๋ ฅํ•˜๋ฉด ์‹คํ–‰๋œ๋‹ค.
- Excel Macro Activity๋Š” ํ•ญ์ƒ Excel Application Scope์— ํฌํ•จ๋˜์–ด์•ผ ํ•œ๋‹ค.
- ์—‘์…€์— ์ด๋ฏธ Macroํ˜•ํƒœ๊ฐ€ ์ €์žฅ๋˜์–ด ์žˆ๋Š” ํ˜•ํƒœ์ด๊ธฐ ๋•Œ๋ฌธ์— ์—‘์…€์˜ ํ™•์žฅ์ž๋ช…์ด .xlsm์ด์–ด์•ผ ํ•œ๋‹ค.

  1. invoke VBA Activity ํ™œ์šฉ
- ๋น„๊ต์  ์“ฐ์ž„์ด ์ž์œ ๋กญ๋‹ค. 
- txt ํŒŒ์ผ์— VBA Script๋ฅผ ์ž…๋ ฅํ•˜๊ณ  Studio ๋‚ด์—์„œ ์ ์šฉํ•  Excel ํŒŒ์ผ๊ณผ VBA ํŒŒ์ผ๋‚ด์— ์žˆ๋Š” ํ•จ์ˆ˜๋ช…์„ ์ž…๋ ฅํ•œ๋‹ค.
- invoke VBA Activity ๋˜ํ•œ Excel Application Scope ๋‚ด์— ํฌํ•จ๋˜์–ด์•ผํ•œ๋‹ค.
- ์—‘์…€์—์„œ ์™ธ๋ถ€ ๋ฉ”ํฌ๋กœ ์‚ฌ์šฉ์„ ํ—ˆ์šฉํ•ด์ค˜์•ผ ์‹คํ–‰๋œ๋‹ค.
(์„ค์ • -> ์˜ต์…˜ -> ๋ณด์•ˆ์„ผํ„ฐ -> ๋ณด์•ˆ์„ผํ„ฐ ์„ค์ • -> ๋งคํฌ๋กœ ์„ค์ • -> VBA ํ”„๋กœ์ ํŠธ ๊ฐ์ฒด ๋ชจ๋ธ์— ์—‘์„ธ์Šค ์ฒดํฌ)
- ์ฃผ์˜์ ์€ ์ด๋ฏธ ์ž…๋ ฅ๋œ ๋ฉ”ํฌ๋กœ์™€ txt์—์„œ ๋ถˆ๋Ÿฌ์˜ฌ ๋ฉ”ํฌ๋กœ ์ค‘๋ณต์ด ๋˜๋ฉด ์ถฉ๋Œ์ด ๋‚œ๋‹ค.



RPA๋ฅผ ํ™œ์šฉํ•˜์—ฌ ๋‹ค์ˆ˜์˜ Excel ํŒŒ์ผ์— ๋ฉ”ํฌ๋กœ๋ฅผ ์ ์šฉํ•ด๋ณด์ž ๐Ÿš€

์‹คํ–‰์ด ๋˜์ง€ ์•Š๋Š”๋‹ค๋ฉด ์—‘์…€ ํŒŒ์ผ์„ ์—ด์–ด๋ณด๊ณ  ๋ฌธ์„œ๊ฐ„์˜ ์ถฉ๋Œ๋„ ํ™•์ธํ•ด๋ณด๊ณ  ์ž‘์—…์ค‘์ธ ์—‘์…€ ํ”„๋กœ์„ธ์Šค ์ข…๋ฃŒํ•˜๊ณ  ๋‹ค์‹œ ์‹œ๋„ํ•ด๋ณธ๋‹ค.

how to use?

https://labft3231.github.io/rpa/update/2020/03/20/UiPath-invoke-VBA-Script/

About

UiPath invoke VBA Script 2way(Excel Macro, Invoke VBA) ๐Ÿ”ฌ

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published