jkfeagle
Codus Confusious
- Local time
- Today, 16:37
- Joined
- Aug 22, 2002
- Messages
- 166
I am a bit puzzled by the behavior of the transfer spreadsheet command that I am using. I am using it in a macro as a test. (forgive me oh mighty Access master for that. right now I'm just testing the results, but I promise I will write the code for the final project) 
I was transferring three tables into an existing excel file. I noticed that the first table went into the worksheet named the same as the table (what I wanted) but for some reason the next two created new sheets. (i.e. Jan table went into Jan worksheet, but Feb and Mar tables created Feb1 and Mar1 worksheets). As I said, I am using the transfer spreadsheet command from a macro. What gives? Is there a way to make ALL the data go into existing worksheets or do I have to result to Automation or what? 
I was transferring three tables into an existing excel file. I noticed that the first table went into the worksheet named the same as the table (what I wanted) but for some reason the next two created new sheets. (i.e. Jan table went into Jan worksheet, but Feb and Mar tables created Feb1 and Mar1 worksheets). As I said, I am using the transfer spreadsheet command from a macro. What gives? Is there a way to make ALL the data go into existing worksheets or do I have to result to Automation or what? 