Exporting Data From Query Into Excel

  • Thread starter Thread starter Ronald Dodge
  • Start date Start date
R

Ronald Dodge

How can I have this process automatically done to have the data from a query
after it's been ran to be exported into Excel in a specified location?

--

Sincerely,

Ronald R. Dodge, Jr.
Master MOUS 2000
 
I have done some research on this method. While this method looks
promising, there's one limitation. It states one MUST leave the "Range"
argument as blank, when exporting data. The other thing I'm looking for,
putting data from a query into a worksheet, which the name of the worksheet
would be different from the name of the query. Based on the various things
I have seen with the research I have done, it looks like both names are
required to be the same to use this method, which then breaks up my naming
conventions.

--

Sincerely,

Ronald R. Dodge, Jr.
Master MOUS 2000
 
Back
Top