Excel Macro
I am having a bit of a problem doing my first office automation with VB, and I could use some help. It is a relatively simple project but I am having a bit of trouble navigating the office objects today.
Background
The application my company makes uses a CSV format file to automate some data as outputted by PBX systems.
The PBX system outputs its files as a tab separated text file.
Someone has an excel spreadsheet witha special macro that takes all the files formats them properly and saves them to an alternate location.
My Task
I need to take this spreadsheet with the macro and either get it to open automatically and run itself and close itself while giving the right answers to the dialogue boxes, or else I need to rewrite this in to a VB program that stands on its own.
What I am hoping to do is use the connector to get an external VB program to open the spreadsheet run the macro, answer the boxes, close the spreadsheet and then close itself. Any feedback or advice that anyone can give me would be great. I am digging through the object browser and stuff, but I figured you guys might be able to point me in some right directions. I have built a program previously to open excel and build some data and format cells, but this is past what I normally do. To be quite honest I am fairly proficient, but by no means an excel expert.
Background
The application my company makes uses a CSV format file to automate some data as outputted by PBX systems.
The PBX system outputs its files as a tab separated text file.
Someone has an excel spreadsheet witha special macro that takes all the files formats them properly and saves them to an alternate location.
My Task
I need to take this spreadsheet with the macro and either get it to open automatically and run itself and close itself while giving the right answers to the dialogue boxes, or else I need to rewrite this in to a VB program that stands on its own.
What I am hoping to do is use the connector to get an external VB program to open the spreadsheet run the macro, answer the boxes, close the spreadsheet and then close itself. Any feedback or advice that anyone can give me would be great. I am digging through the object browser and stuff, but I figured you guys might be able to point me in some right directions. I have built a program previously to open excel and build some data and format cells, but this is past what I normally do. To be quite honest I am fairly proficient, but by no means an excel expert.
