View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Rhonda[_3_] Rhonda[_3_] is offline
external usenet poster
 
Posts: 17
Default Deleting a query

Hi,

I hope someone could help me this, I have a feeling this
is not possible but anyway, here goes, is it possible to
create a routine for a command button that would prompt
the user to enter a query name(achieved when you right
click on a query and then open Data Range Properties,
this is the actual name of the iqy file)and when the user
enters the name, he can then delete it from it's place on
the spreadsheet(in my case it would be somewhere in sheet
2) and the iqy file stored in the Microsoft/Queries
default folder? Maybe you know another way of handling
it. Either way, I would be truly grateful!!!! Thanks
for your help!