View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Adam Harding Adam Harding is offline
external usenet poster
 
Posts: 9
Default 3 Questions - No Answers - Help me please

1) I need to open up some source workbook on opening my main form but would
like it hidden if possible, can't even open it yet!
2) I keep getting the following message on saving "Excel cannot complete
this task with available resources. Choose less data or close other
applications" on clicking OK i get "Unable to save external link values" I
don't want to save external link values how can i stop it doing this at all.
It still saves properly regardless so i don't see the point.
3) On close I need to sort an area of 7 columns by 500 lines by column A
with the sort regarding text as numbers, can i get that to work?

Cheers Adam, In gratitude