Search results

Hi , I am having a similar need. Did you find a solution for this.

@Hany ali : Sorry for being blunt. What I would like to know is that , is there a way to connect to Linux using excel macros. Currently I am connecting to a linux box using putty and getting values from files. I would like to know if I can write a macro to connect to linux server?

Any help here

Hi - Has anyone written a VBA code to connect with Linux and get the value from the files. I have a requirement where I need to connect with Linux and extract the values using the grep command.

Hi All, I am using excel macro to connect to JIRA API. The response status appears as 201 created whereas the responseCode gets returned as ? ?????????????????????????????????????????? ???] . Could anyone let me know why. Below is the code:- <<CODE>> As many times, You've gotten a note...

HI, Has anyone worked in getting JIRA data using excel VBA. I am struggling for the past few months. I would be immensely grateful if anyone can help me here.

Hi, I am getting the below error. Could anyone let me know how to solve it. Actually I am working to connect with JIRA using excel macro.

Hi All, I used the below code to connect to JIRA hosted in cloud in my organization. It connects but the response I get is not complete. I get incomplete response. But when executed using postman, I get lot many projects. Could anyone let me know what is the issue. Also...

Thanks all for your responses. Will try and get back.

Although I search in google , I am not getting the answer whether it is possible or not. Also I am not able to see Informix database in the From Database list. Has anyone connected power query with Informix.

HI All, Has anyone connect excel power query with BM Informix database. If yes, how have you connected. Please let me know.

Hi All, I want to connect to Jira using Jira API and get the response. I have to pass in the user id and password [login credentials] in the script. The below is the code, I am using. I am getting Automation Error when I execute the below code. Could anyone help me in the below...

Thanks for the response.

Hi, I learnt how to do custom cell formatting for number using the formula [color1];[color3];"Zero";test. I have a requirement. I have two texts Pass and Fail. For Pass it should be green and for Fail it should be Red. Is that achievable using cell formating or I should do it using...

Hi, I have a database with millions of records to which I am connecting. When I make the connection It is taking a long time to bring the data in the worksheet. After refreshing for a long time, excel sheet gets hanged. What to do in this kind of tables with millions of records.

Hi Chihiro. I am able to connect. Thanks very much for your help.

Thanks Chihiro. Will check and get back.

Hi, Below is the URL I use to connect to Oracle database in Squirrel SQL. What is the Server name that I need to give for connecting to Oracle Database from Power Query. Kindly help here. I have installed Oracle Addin and Power Query add in. URL : jdbc:eek:racle:thin:mad:(DESCRIPTION...

Can anyone help me connect to Inforxmix database using excel ADODB object. if anyone has already done it I need your help and assistance

Hi All, Has anyone connected Informix database using excel macros ADODB object. If yes, could someone tell me how.

Hi Chihiro, I am actually updating the database. Not just select.

Chihiro - Thanks for your response. Will check on REST API for Informix and get back.

Hi, I would like to connect Informix database using ADODB object. I am provide with the below details by my java REST API developer. Please provide some light as I am new to connecting to informix database...

Hi, The above link you shared has no information on Informix database. Could you share me the right link please

Hi, I would need to connect my excel power query with informix database. I dont see Informix database as the default option. Could you kindly help me if it is possible. I have the URL and credentials of Informix database