Hi, I have looked around and haven't found a workable solution for what I am trying to achieve.
I have a query (importA) importing data from txt files, and I have a sheet (ManualData) for data to be put in manually.
I want to add a setting option (toggle/radio button) to set the query source as either the imported txt files OR the manual entry sheet.
I have looked mainly at adding an IF statement to the query (if radio toggle is true then set source to txt files else use table), and changing the source through vba (on radio button click, replace formula Name in specified query) - both of these threw errors that I didn't have the ability to fix - the IF statements weren't read by the query and gave issue with converting to binary or from binary, something like that. The vba version gives subscript out of range issues. (have tried troubleshooting both to no avail.
Any guidance would be greatly appreciated, thanks in advance.
Scott.
I have a query (importA) importing data from txt files, and I have a sheet (ManualData) for data to be put in manually.
I want to add a setting option (toggle/radio button) to set the query source as either the imported txt files OR the manual entry sheet.
I have looked mainly at adding an IF statement to the query (if radio toggle is true then set source to txt files else use table), and changing the source through vba (on radio button click, replace formula Name in specified query) - both of these threw errors that I didn't have the ability to fix - the IF statements weren't read by the query and gave issue with converting to binary or from binary, something like that. The vba version gives subscript out of range issues. (have tried troubleshooting both to no avail.
Any guidance would be greatly appreciated, thanks in advance.
Scott.