1

I am trying to call a python script via a macro in excel. This script needs to reference the excel file it is being called from.

I know that this question offers help regarding how to call the script in vba: How to call python script on excel vba? However, my python script immediately tries to reference the excel docs path/name. Is there a way to assign a variable to these values? My python code (see below) needs a reference path/doc to pull the correct data from excel.

workbook_path = r'C:\Users\jrwaller\Documents\Automated Eve' workbook_name = r'PMT Project 13.xlsx' import openpyxl wb = openpyxl.load_workbook(fr'{workbook_path}\{workbook_name}')

Where the path and name could be changed from project to project. Is there a way to assign the workbook ordering the script to run as wb?

Improve this question
1

1 Answer 1

Reset to default
2

Pass them as command-line arguments.

from argparse import ArgumentParser import openpyxl parser = ArgumentParser() parser.add_argument("-f", "--file", dest="filename", help="the full path of the Excel workbook to work with", metavar="XLWB") args = parser.parse_args() wb = openpyxl.load_workbook(args.filename)
Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.