Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Specifying worksheets to be included in Save As

Status
Not open for further replies.
t16turbo

t16turbo

Programmer
Mar 22, 2005
315
GB
Is this possible?

I have a sub routine that saves the spreadsheet to a hard-coded location for the end users to view.

Is it possible to save the spreadsheet without underlying queries, and without certain worksheets?
 
Sort by date Sort by votes
yes - by saving and then deleting and then saving again

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

K
  • Locked
  • Question
How to resolve define worksheets array
Replies
1
Views
808
combo
combo
Andrzejek
  • Locked
  • Question
Open Word as ReadOnly 1
Replies
6
Views
684
Chriss Miller
C
thanhthanh12
  • Locked
  • Question
How disable save and save as in word vba?
Replies
1
Views
356
macropod
macropod
2009luca
  • Question
put value in input box web page
Replies
0
Views
196
2009luca
2009luca
AncientTiger
  • Locked
  • Question
How to screenshot a userform and save the capture as JPG 1
Replies
7
Views
2K
AncientTiger
AncientTiger

Part and Inventory Search

Sponsor

Back
Top