Hi, please help. Text To Column

Hi, Im a beginner. Can somebody help me to solve my task, so the process is i have to get data from data base and i write the database result into excel. But some of the data is write as a text i have to do text to column manually in excel :frowning: i have to make the data fixed width, and i have to execute the excel for report to my boss can somebody help me?


Untitled2

Connect Database KI.xaml (12.1 KB)

hi seems like your image is still uploading

may take a minute sir, slow connection here :frowning:

hai bang ,
jadi maslah nya di excel seharusnya tidak mau berformat text ?,
untuk mengganti format nya bisa dilakukan menggunakan balareva activity/pacakage

atau jika anda sudah mempunyai EXCEL TEMPLATE yang disediakan untuk menampung data nya , maka bisa diubah di excel template itu sehingga data yg masuk akan mengikuti template yang disediakan

terimakasih

Hi,
Could you please make one text to column macro.
And it execute ui path using invoke vba activity
Thanks
Regards
Sahad

wah orang indo :smiley:

intinya tabel yang aku screen shot itu masi keadaan text jadi harus di text to column dulu, baru bisa di vlookup ke sheet compare jadi tinggal di upload.

masalahnya bro aku ngga ngerti balareva activity / pacakage. kalau opsi ke 2 aku udah muter otak sampe situ tapi ya gabisa di text to column kalo ga ada datanya kalo manual ntar ga bisa di lempar ke orchestrator soalnya mau dibikin daily jadi tinggal report lewat email.

its still not work for me sir :frowning:

Hmmm belum pernah sih saya jumpa case ini ,
Btw coba check post ini

Mana tau membantu

Terimakasih

Hi,

Please copy the respective macro in to a notepad(txt file) and

pass the same file path to the “invoke vba”.

please refer the screen shot below,

Alfredo_Sitompul
February 23


Visit Topic or reply to this email to respond.

To unsubscribe from these emails, click here.

2e6417a4.png

Regards

Sahad KK

Software Engineer - RPA

Alzone Software Pvt Ltd, Technopark, TVM

+919946462825| sahad.kk@alzonesoftware.com | www.alzonesoftware.com

1dee8c95.png

Alzone Software Private Limited | ACE 04, 3rd Floor, CDAC Building, Technopark Campus | India 695581

Hi @Alfredo_Sitompul

Before using invoke vba activity you need to ensure that in excel application that macros are enabled

Go to options in excel —>trust centre—>trustcentre setting

macrosettings–>Enable all macros–trust access to vba

Then use the invoke VBA activity as said before

Sub VBA_Autofit()
With Worksheets("Sheet1").Cells
    .EntireColumn.AutoFit
    .EntireRow.AutoFit
End With
End Sub

Regards

Hi @Alfredo_Sitompul,

You can use VB script to achieve this, follow the steps provided by @pravin_calvin,

Thanks

Hi, sir ive been following all the steps but still not working :frowning:

his sir, Ive been following all the steps but still not working :frowning: ive been watching all the tutorial from youtube but still not works :frowning:

Hi @Alfredo_Sitompul

Have you tried running the script manually from the excel ?

and change the “Main” from the invoke vba to “VBA_Autofit”

and the error clearly mentions that!

Regards

@Alfredo_Sitompul

And cross check once in excel options that macros and trust to Vba are enabled!
Regards