multiple workbooks opening

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

After spending enough time trying to figure this out I'll ask for help....

My code in in a template. It opens a workbook (created from access) selects multiple ranges and then paste the selection into a new workbook (created from the template) and does some formatting. pretty simple My problem is whenever I open excel now, every workbook I've touched with this process opens, automatically.

tia
 
Hi Jtr,

I suspect that your workbooks are saved to your XLStart directory. If so,
move the relevant files to another directory,

---
Regards,
Norman


jtr said:
After spending enough time trying to figure this out I'll ask for help.....

My code in in a template. It opens a workbook (created from access)
selects multiple ranges and then paste the selection into a new workbook
(created from the template) and does some formatting. pretty simple My
problem is whenever I open excel now, every workbook I've touched with this
process opens, automatically.
 
Norman

Thanks for the idea, I check and nothing in that folder. I did notice that my template code is in every workbook created from the template

John
 
Hi John,

What folder are your files stored in?
Check your alternate startup file location (Tools | Options | General). Are
your files stored in this folder?

---
Regards,
Norman

John said:
Norman,

Thanks for the idea, I check and nothing in that folder. I did notice
that my template code is in every workbook created from the template.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top