How Do I Automatically Delimit Refreshable Web Query

**eichstadt28** · 04-09-2009, 09:30 PM

Hello,

I've got a web query that refreshes every time I open my spreadsheet. I initially formatted and sorted/filtered this query the way that I wanted it, but every time it automatically refreshes, the data needs to be delimited. Is there any way that I can have this data automatically sorted and delimited every time I open the spreadsheet?

Thanks, in advance, for your help.

**JBeaucaire** · 04-10-2009, 01:36 AM

Record a macro of YOU sorting and delimiting the data. Then take the guts of that macro and put it inside of a Worksheet_Change event macro, insert that macro into the worksheet module where this data query is coming in.

Then, when the query updates the sheet, that will trigger the macro to resort and delimit the data. Might take some tweaking but it's a good chance to learn and play with the VBA editor.

**eichstadt28** · 04-12-2009, 12:10 AM

thanks. it worked.....somewhat. i've never used the macro recorder before and when i got done with my delimiting, formulating, etc., it said that the string was too long. is there an approximate number of calculations that you can complete for one macro? Thanks, again.

**mudraker** · 04-12-2009, 12:15 AM

It sounds like 1 command within the macro causing the prolem

Post a copy of the macro & also state which command is causing the error

P.S Don;t forget to wrap your macro code when you post it

**eichstadt28** · 04-13-2009, 10:46 PM

It worked!! Thanks. I've never done much with macros, but this recorder seems pretty easy. I've got one more question that I can't seem to find the answer to; I'll post it in another thread. Thanks, again, for helping me out with this.