excelvbo

I am getting this error while writing a collection to excel sheet using Write Collection Action in MS Excel VBO. Error Details - Could not execute code stage because exception thrown by code stage: Method's type signature is not Interop compatible.

Hello, I am looking to create a pivot table that calculates max date. Right now I have a code that creates a pivot table, and I can build the dates as columns however I want to know the distinct user and the max date correlated to them. Please find my current code below. Currently it is...

We have a requirement to download an excel file (IE), open it, format columns and save to a directory. Anyone any ideas on the best approach for this? 1. Is it best to save to a location, do editing and save to required directory? 2. Other option is to open and edit directly, in the...

Hi Guys, When i double click on my excel macro-enabled file, there is a pop up which is generated which asks whether to open the excel file in a readonly mode or not. I should click on the 'No' option. I tried to code the action by duplicating the MS Excel VBO- Open Workbook object and...