This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Having an issue that I shouldn't be having but can't seem to get the output functioning correct.
I need to write a specific value to a specific cell in a specific sheet in a specific workbook.
Initially the worksheet would be populated for columsn A:G and then a conditional runner would create the value of '1' in Z2 which would be used as a trigger for a VBA code that runs on workbook opening. The text is generated via a text input tool at the beginning of the conditional workflow.
This is probably simple but can't seem to get anything working.
@AndrewPoole So when you save my workflow and try to run it, it creates an XLSM file but there is no data in Z1 and Z2? Here is my experience. I changed the path to C:\Data for the demonstration. If my example works but your file doesn't, by any chance are you writing over the entire sheet/workbook later in your workflow?
@AndrewPoole Can you send along any sort of workflow with dummy data or screenshots of your setup/where issues are coming up? Here would be my initial questions in the meantime:
1) When you write to A:I, are you specifying those columns in your output tool or are you just specifying the sheet?
2) Which option do you want to output A:I (append, overwrite sheet, overwrite file)?
3) Is your output to A:I currently successful?
4) Is your output to Z1:Z2 currently successful? I assume you're not trying to append existing to this runner. You would want to overwrite the sheet, which would only affect Z1:Z2 and won't actually overwrite the sheet (since you've specified a range it only overwrites the range).