@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?
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 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...
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,
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...
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,
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...
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,
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