Hi, please help. Text To Column

[Alfredo_Sitompul]

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 i have to make the data fixed width, and i have to execute the excel for report to my boss can somebody help me?

Connect Database KI.xaml (12.1 KB)

[Ahmad_Rais (Ahmad)]

hi seems like your image is still uploading

[Alfredo_Sitompul]

may take a minute sir, slow connection here

[Ahmad_Rais (Ahmad)]

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

[sahad.kk]

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

[Alfredo_Sitompul]

wah orang indo

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.

[Alfredo_Sitompul]

its still not work for me sir

[Alfredo_Sitompul]

[Ahmad_Rais (Ahmad)]

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

Text to Column

Hi guys, I have a text file with thousands of data. I wanted to copy the data into excel file and split the data into multiple column (dynamic) depends on the delimiter which is comma (,) without using hotkeys. I managed to do the read text file and paste it inside excel for every row in one column only. Now I’m stuck with split that column A into multiple column by using delimiter comma(,) and the columns should not be fixed since it depends on the data after the splitting.

Mana tau membantu

Terimakasih

[sahad.kk]

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.

Regards

Sahad KK

Software Engineer - RPA

Alzone Software Pvt Ltd, Technopark, TVM

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

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

[pravin_calvin (pravin kumar)]

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

[Shikhar_Tandon]

Hi @Alfredo_Sitompul,

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

Thanks

[Alfredo_Sitompul]

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

[Alfredo_Sitompul]

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

[pravin_calvin (pravin kumar)]

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

[pravin_calvin (pravin kumar)]

@Alfredo_Sitompul

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