<div>
Ok, will give that a try. Thanks
</div>


<div>
I've requested that this question be closed as follows:<br />
<br />
Accepted answer: 0 points for jtencha's comment <a href="https://www.experts-exchange.com/questions/28569105/Access-vba-copy-to-excel.html?anchorAnswerId=40485048#a40485048" rel="ugc">#a40485048</a><br />
<br />
for the following reason:<br />
<br />
it worked
</div>


I've requested that this question be closed as follows:

Accepted answer: 0 points for jtencha's comment #a40485048 [https://www.experts-exchange.com/questions/28569105/Access-vba-copy-to-excel.html?anchorAnswerId=40485048#a40485048]

for the following reason:

it worked

<div>
I think you may have chosen the wrong comment when selecting your answer. You chose <a href="http:#a40485048" rel="ugc">http:#a40485048</a>, which is your last comment.
</div>


I think you may have chosen the wrong comment when selecting your answer. You chose http:#a40485048 [http:#a40485048], which is your last comment.

<div>
Both mine and Helen's answer should be accepted:<br />
<br />
<a href="http:#a40465129" rel="ugc">http:#a40465129</a><br />
<a href="http:#a40472483" rel="ugc">http:#a40472483</a><br />
<br />
Each provides details of how to delete the file, and how to transfer the file
</div>


Both mine and Helen's answer should be accepted:

http:#a40465129 [http:#a40465129]
http:#a40472483 [http:#a40472483]

Each provides details of how to delete the file, and how to transfer the file

<div>
<div class="content wysiwyg-content">
I need an access vba code to copy a simple table from access into a shared excel workbook. I need access to overwrite any data in the target destination also. Lets say my table is called MyTable, and i need to copy it into MyWorkbook.xlsx on Sheet1. Please note, i had such a code, but access did not resave excel in shared mode.
</div>
</div>


I need an access vba code to copy a simple table from access into a shared excel workbook. I need access to overwrite any data in the target destination also. Lets say my table is called MyTable, and i need to copy it into MyWorkbook.xlsx on Sheet1. Please note, i had such a code, but access did not resave excel in shared mode.

Access vba copy to excel

A spreadsheet is an interactive computer application program for organization, analysis and storage of data in tabular form. Spreadsheets developed as computerized simulations of paper accounting worksheets. The program operates on data represented as cells of an array, organized in rows and columns. Each cell of the array may contain either numeric or text data, or the results of formulas that automatically calculate and display a value based on the contents of other cells.

Spreadsheets

Productivity software is application software dedicated to producing information, such as documents, presentations, worksheets, databases, charts, graphs, digital paintings, electronic music and digital video. Most common programs and suites such as Microsoft Office and LibreOffice have their own topics. Office suites, which brought word processing, spreadsheet, and relational database programs to the desktop in the 1980s, are the core example of productivity software, but they can include communications software, personal information managers, groupware and log analysis software.

Productivity Apps

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.