Exporting to Excel (Macro)

  • Thread starter Thread starter Harddrive747
  • Start date Start date
H

Harddrive747

I have done a lot of coding, so I know what commands to use, but I have a
couple of questions.

1. I have tables in Access that have spaces in the name, such as Lexington
Park. When I export that to Microsoft Excel, the transfer converts that to
Lexington_Park in the spreadsheet. Why is it doing this and how do I get it
to stop putting the "_" in where the space is suppose to be. This is messing
up a lot of other things I do with the name.

2. I know that I can import data from Excel using a range or starting at a
specific location. I haven't done it, but would like to. I have a dozen
sheets in a workbook and each of them have a different length of data in
them. I would like to be able to pull it directly from workbook, instead of
having to create a seperate file, which I'm doing right now. Along with that
changing to the next worksheet to get the next set of data.

3. This follows along with question 2 about exporting from Access to Excel.
Is there a way that I can export only data to a spreadsheet with different
sheet names and then start at say cell A20 and paste the data in?

Thanks for letting me know on these questions
 
importing isn't the problem. The problem is when I export from Access to
Excel. One of the two applications is causing the space between names to be
replaced with an "_". So like I said, I have a unit name like Lexington
Park. When I export the result of a table called Lexington Park to Excel, I
end up with a worksheet name of Lexington_Park. I'm wondering which
application is doing this and what, if anything, can be done about it?

I'm thinking about doing a case statement to rename the workstheets, copy my
data and then rename them back, which is a lot of work.

So any help or suggestions would be greatly appreciated.
 
Back
Top