python

Hi all, i have an excel column of 4000 rows that contains internet website and i want to know if this internet website have inside them relations with their facebook, twitter or linkedin page. Is that possible? and if it were possible how can i automate the compilation of another three...

Hi guys, I have an excel question. So I’m using excel as a bridge between python and my trading platform ninjatrader. I’m getting values from another data source and processing those values in python and then sending those values to a file in excel (file 1). Then, I have another file (file 2)...

Hi Just curious if anybody knows why this happens. I have python code that triggers and runs a macro in a workbook. The macro can take several hours to run. If I run the macro without the use of Python, my workbook is open and for the time it takes the macro to run I am unable to use excel...

I know in Python you can assign a value to an array index that doesn't exist yet. That's what I want to mimic in VBA if possible. For example, I have a list of accounts and items they map to: 40100 => 1 42000 => 2 43000 => 8 44456 => 27 What i want is an array that I can get values from like...

This may be a python question, not sure. I am using the following vba code to create and save a new workbook with information from the first. Range("u3", Range("u3").End(xlToLeft).End(xlDown)).Copy ' copy some data from open workbook Set dealbook =...

I am attempting to use a basic example of xlwings. I have the following VBA script: Sub Test() RunPython ("import VBAtester; VBAtester.test()") MsgBox ("Script has run.") End Sub Which is in the same directory as the python script VBAtester.py: import xlwings as...

Hello, I have a basic VBA program which randomly selects data from a larger set into multiple smaller sets, then based on these smaller sets takes an average of the values and gives a performance rating. As of now I can make a simple Do While loop that will continuously run the randomization...

I am currently developing a tool for a client that interfaces with both python 2.7 and excel 2013 and as a result running into a problem. As background, I have a python code I want to run as a executable. The client doesn't have python on their computers so it's vital that the exe runs without...

Hi, I am designing Python code that would dump the excel contents into CSV file on Unix server and have a problem with numbers When the values are dumped into CSV, I want to have the values that appears in the cell to be dumped rather than the real values of double precession's which is...

Recently I came across a piece of software called DataNitro. It integrates python into excel. Their website is at https://datanitro.com/‎ . Has anyone installed it and played with it? What are your reviews about it .... Thanks

I'm thinking of a way to do things faster and I find VBA and Python programs a great ease. However I am still in a slowwwww and long way of learning both. So I don't have a clear idea which is better to use in this process that I am thinking of: I want to send inquiries to a websites and...