How to open Transformation file using VBA button

[former_member495414]

Hello All.

Is it possible to open Transformation file using VBA button. If yes could you please share some sample code.

Thanks,

Sameer

[former_member186338]

Sorry, but what for? If you can provide a scenario I can help with workaround!

[former_member495414]

I need to open specific transformation file using VBA button. ex click on button and it should open any specific transformation file like for transaction data load or master data load.

[former_member186338]

"I need to open specific transformation file using VBA button"

There is no way to open "specific transformation file"

But can you explain, what for do you need to open it? Why you can't use menu???

[former_member495414]

Because some business user what us to do in that way only.They don't want to use menu option.

That why I have created each task from uploading data file to run package using vba button only. we have multiple location based on selected location user wants to open specific transformation file and validated.

[former_member186338]

sameer9994

I am still unable to understand why users need to open transformation file???

Transformation files has to be created at once and not changed in general...

Why users need to validate it?? Something is wrong with business process

Data upload can be done using VBA button, no issues here!

[former_member495414]

Thanks, Harsha for the solution.

[former_member186338]

It's better to explain, what do you want to achieve!

harsha.jalakam correctly mentioned that DataManagerOpenTransformationFileDialog API will simply open dialog to select file, not some specific file...

[harsha_jalakam]

Hi,

I'm not sure if there is a way to open a way to open a specific transformation file, but the API

DataManagerOpenTransformationFileDialog() can be used to open "Transformation File" dialog box.

Cheers,Harsha