How to prevent my Macro from opening up another Excel App when I open any other excel file

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Peter (ichu7199_at_yahoo.com)
Date: 11/12/04 

Date: 12 Nov 2004 09:41:54 -0800

HI:

I created an Excel VBA (VBATest.xls) and I put the xls file in the
XLStart Directory and whenever I load other excel file, I can run the
macro that is defined in my VBATest.xls file. The only problem is when
I load any excel file, it also opens up another blank excel
application (which says VBTest.xls). I think there is a way to prevent
that to startup while the sub function in my VBATest.xls is still
available to other excel files. Any ideas?

Thank you.

Peter

Relevant Pages

  • Re: Docs2Go v9
    ... manually with Filez and deleting as appropriate. ... Formatting is retained, which is nice, and one Excel file ... that would never load under previous versions now does. ... A Word file that has graphics embedded in it ...
    (comp.sys.palmtops.pilot)
  • Re: Import excel but selected column for selected table
    ... Do you other method where user can browse the excel file and then load it in ... the table with selected field to appear? ... Append query and append to table 1. ... For example i want to be able to specify column 1,2,3 to load in table 1 ...
    (microsoft.public.access.formscoding)
  • reading a large xls file
    ... Also, xlsread permits you to load only certain rows and columns, so I thought ... Have you tried saving the excel file as a Tab delimited ...
    (comp.soft-sys.matlab)
  • Re: Windows XP Repeated Crashes
    ... Excel file. ... The exact address will almost certainly not be listed. ... load address and extending up to but not including the load ... Using a recent PSTAT report from a different machine I find that ...
    (microsoft.public.windowsxp.help_and_support)
  • Re: How to open a large excel file?
    ... Die Tastatur von alex lee wurde wie folgt gedrückt: ... Excel can onle open no more than 65000 row data.I also try to load ... the excel file from Access,but it also cann't run.So how can I load ... the data in the file without 65000 row data? ...
    (microsoft.public.excel)