How to expand excel column so values can be visible

Hi All,

I am converting excel to pdf , so after coverting i am getting data as below,

image

Please help

1 Like

You can use vba or use direct actions using hotkeys –
Ctrl+A
then Alt+h+o+i

3 Likes

@amruta_pawar You have to open the particular excel file (use start process activity) and use send hotkeys.

  1. Ctrl+A — Use this hotkeys to select all in the excel file.
  2. ALT + H + O + I — Use this hotkeys for autofit column width.
  3. ALT + H + O + W — Use this Hotkeys for manually entering column width for each column. you will have manually enter the column width for each column and resolve it.
2 Likes

how to use vba, as i dont want to open file

Sub mac1()

Dim sht As Worksheet
ThisWorkbook.Worksheets("Sheet2").Cells.EntireColumn.AutoFit

End Sub

save it in text file
then use Invoke VBA activity
enter parameter as
image

change Sheet name as per your requirement

getting error as
Invoke VBA: Programmatic access to Visual Basic Project is not trusted

@amruta_pawar

Please check below thread to resolve this issue.

https://support.microsoft.com/en-in/help/282830/programmatic-access-to-office-vba-project-is-denied

Do this steps
1.


2.

3.

4.

thanks but still getting error as

image

Check whether the file contains macro or not if available then remove and save file as macro free
Check is your entry method name is ryt or not

if possible pls share workflow