Hi there. Im a newbie into the macro world. My purpose is to output from each excels files and sheet an output with columns empty etc and the adress like L1C1 you know. From a tool DIR im taking my .xlsx files and output directly Full Path. Then im connecting into a macro for listing all the excel sheets and get a column names Full Path with C:\Users\Downloads\abc.xlsx|||Sheet1$. Hence from it im connecting into my second macro. My second macro is waiting for full path in control parameters and you have options to include or not empty rows and columns as checkboxes. From my Dir its working but when im adding this kind of excel into it first screenshot. The second one is my first macro for listing excel sheets and to make my column full path. On the third screenshot as u can see my real data is Col 3 and line 6 and the macro is giving an output on L1C1 WHY ? and im also losing Full Path from the macro input to the output. Do u guys have some ideas from that behavior ? TSYM 4 taking time to answer.
Hi Something is incorrectly set up. There is an error on your 2nd macro, what kind of error do you get? Does Alteryx need to calculate the address, L1C1, from the columns or rows? By using a batch macro you will be able to keep the full path.
Hi .
The error is about one of my excel file sheet that i removed and my macro hasn't any problems now but still getting in output the wrong L1C1 for my value as you can see below first screenshot1. And im already in batch macro mode screenshot2. Screen 3 as you can see i have to calculate L1C1
If you would like that it will be raw 4 and not 1, then you should use the RecordID value to be updated in your formula or to update row number value from RecordID. I'm not sure how do you set Column Number and Row Number but they are populated only with 1, so if you can find out the step before they are populated with 1 then you will be able to figure it out.
