Question about Computers & Internet

2 Answers

Excel 2007 (Exporting info from MRI)

Hi. I am trying to export accounting information from MRI to Excel 2007, but am getting a 'Run Time Error '6' overflow' Do you have any solutions or settings that I should have on my computer? There were no problems exporting from MRI to Excel 2003.

Thanks!

Posted by on

2 Answers

  • Level 1:

    An expert who has achieved level 1.

  • Contributor
  • 1 Answer

In excel options, under trust center settings, macro settings, check the box that says 'trust access to the VBA project object model'.

Posted on Jan 19, 2015

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    MVP:

    An expert that got 5 achievements.

    Sergeant:

    An expert that has over 500 points.

    Champion:

    An expert who has answered 200 questions.

  • Expert
  • 329 Answers

I suggest that you should you Office 2003 much better. office 2007 has a very hard time to use, even if its user friendly. but i dont waste time just to configure such DELICATE Problems like office 2007. if theres any problem just contact me sir/mam. thanks!

Posted on Mar 28, 2008

  • robertdour Jan 26, 2011

    My accounting staff came up wih this..

    Click Excel options:



    Click on Trust Center

×

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

How to export in tally 7.2


This applies to Tally 7.2 and above.
1. You can export only registers and not masters
2. In any view register mode the export / import option becomes availble.
3. Click export.
4. Tally prompts you for a file name. The default name is always Tally.txt.
5. Pl rename the file to represent the ledger you are exporting else Tally will over write an existing file.
6. Tally will always save the file in the same drive / folder where Tally data resides. You cannot change this.
7. The file saved is the CSV file.
8. Open this file with Excel and map the fields.

Jan 20, 2015 | Tally Office Equipment & Supplies

1 Answer

I'm exporting photos to my camera roll,and its not doing anything a stuck loading, it says 'Exporting to camera roll.'


Try re-installing the app. In the case of the new iOS 6, it should ask you whether it is allowed to access your camera roll, if you declined then, that may cause problems. Re-install the app and see if that fixes it?

Nov 03, 2012 | tap tap tap Camera+ …the ultimate photo...

2 Answers

How can i export the data tally to excel


Hi,

There are 2 ways to do it..

Step 1
You can export as text and import it back to excel using the text file you created.
Or
You can select HTML and give the file name as eg-XYZ.xls


Step 2

You can export all reports and statements. For this a separate export button is provided in right hand button bar. To do this go to any report e.g. day book you to export or any statement e.g. balance sheet. You would see export button on top right hand side on button bar. Press it and a screen would pop up with export related options.

The first option is format of data to be exported namely ASCII, HTML, SDF, and XML. Which ever application you are importing this data in would decide in which format you should export the data.
For statements like balance sheets and trial balance which we use to send and import file in word and excel etc. HTML format is good. We need minimum formatting in this format while using it in MS Word and MS Excel.
certain applications accept continuous data where we have defined field length. Then ASCII format is better.
For application which accept SDF and XML format these formats can be chosen.

Give a file name and the exported file is saved in the parent Tally directory on your computer. You can now use that file to import its contents into another program, send it as it is (say if it is HTML file) to a colleague or view it using a browser.

Step 3

Consider exporting day-book.Go to day book press export button or use shot cut key Alt+E. Exporting screen will displayed.

tally-export-screen-300x82.gif

Press Back space on your keyboard. And select Format as ASCII (comma delimited). Now give output File Name as Daybook.csv, now select some other option you want to export from the bottom of the screen.

tally-export-ready-screen-300x81.gif

Press enter to accept screen. Day book is exported in to tally program folder. Check program folder for file daybook.csv,

csv-file.gif

Double click on it, the file will open in excel program. If you want it in excel work sheet file, use the option Saveas, and save it in Microsoft excel workbook (*.xls) format.



Hope this is helpful. Let us know if the issue is resolved.





*Rating and Comments are invited for this solution

Nov 24, 2010 | Tally T2245 Matrix Printer

1 Answer

I HOW I EXPORT TALLY 7.2 DATA IN EXCEL FORMAT


Hi,

There are 2 ways to do it..

Step 1
You can export as text and import it back to excel using the text file you created.
Or
You can select HTML and give the file name as eg-XYZ.xls


Step 2

You can export all reports and statements. For this a separate export button is provided in right hand button bar. To do this go to any report e.g. day book you to export or any statement e.g. balance sheet. You would see export button on top right hand side on button bar. Press it and a screen would pop up with export related options.

The first option is format of data to be exported namely ASCII, HTML, SDF, and XML. Which ever application you are importing this data in would decide in which format you should export the data.
For statements like balance sheets and trial balance which we use to send and import file in word and excel etc. HTML format is good. We need minimum formatting in this format while using it in MS Word and MS Excel.
certain applications accept continuous data where we have defined field length. Then ASCII format is better.
For application which accept SDF and XML format these formats can be chosen.

Give a file name and the exported file is saved in the parent Tally directory on your computer. You can now use that file to import its contents into another program, send it as it is (say if it is HTML file) to a colleague or view it using a browser.

Step 3

Consider exporting day-book.Go to day book press export button or use shot cut key Alt+E. Exporting screen will displayed.

tally-export-screen-300x82.gif

Press Back space on your keyboard. And select Format as ASCII (comma delimited). Now give output File Name as Daybook.csv, now select some other option you want to export from the bottom of the screen.

tally-export-ready-screen-300x81.gif

Press enter to accept screen. Day book is exported in to tally program folder. Check program folder for file daybook.csv,

csv-file.gif

Double click on it, the file will open in excel program. If you want it in excel work sheet file, use the option Saveas, and save it in Microsoft excel workbook (*.xls) format.


Hope this is helpful. Let us know if the issue is resolved.



*Rating and Comments are invited for this solution

Nov 10, 2010 | Tally T2245 Matrix Printer

3 Answers

Export tally data to excel


tally data to excel converting . i have some data export to excel but no excel formating you have some tally data to excel spred sheet software

Aug 27, 2009 | Tally T2245 Matrix Printer

1 Answer

Cannot export from OMNIPAGE SE (mac), 10.1.0 to WORD


Hello,
I believe I can help you with this. What is the format of the page you are exporting from? Also, how many images files are there and what is the size of the file you are exporting from?
I know that MSWord has size limitations on documents which is 32MB, so most like the exporting document contains images that in total is greater than the size limit.
Check out this article by Microsoft--> http://support.microsoft.com/default.aspx?scid=kb;en-us;211489
I hope this helps,
Thanks, Raph30

Jan 27, 2009 | ScanSoft OmniPage Pro X 10.0 for Mac

2 Answers

Import data from access into excel where one column go into one worksheet and other into next


Can't be done.

Access will only put the data into one worksheet. It is very picky when it comes to exporting data into an Excel spreadsheet.

There are two ways to get around it:

1) You can export the data from Access into two files. One for the the first worksheet and another file for the second workshet.

2) You can import everything into one spreadsheet and build a macro into Excel to cut the information one spreadsheet and paste it into the other if this is a redundant task to do all the time.

Hope that helps you out.

Jun 10, 2008 | Microsoft Office Access 2003 (077-02871)...

4 Answers

How can i export tally data to excel format?


Export to Excel With new release now you would get one more options while exporting data. One added format option is Excel format. excelexport.jpgIf you export in this format then file would be saved in xls format. More over if you put Excel formating option to Yes then tally would automatically format the data in presentable format. Tally would automatically bold the headlines and main fields for you and format data in a good way. Take a look at excel snapshot of balance sheet exported from Tally.

excelexport2.jpgThe special thing here is that you can do the calculation on any amount figure or any row or column, which was earlier not possible. The only drawback which i could find was that amount figures are not right aligned which is must for numbers for easy calculation, although you can do it by selecting the amount figures and putting them right aligned.

Feb 27, 2008 | Computers & Internet

15 Answers

Export tally data to excel format


Select ASCII. Give output file name Eg:d:/exp Open the file using EXcel.Select Delimite  nexxt comma finish.Export is completed

Jan 02, 2008 | Tally T2245 Matrix Printer

Not finding what you are looking for?
Computers & Internet Logo

Related Topics:

1,232 people viewed this question

Ask a Question

Usually answered in minutes!

Top Computers & Internet Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

kakima

Level 3 Expert

101516 Answers

David Payne
David Payne

Level 3 Expert

14160 Answers

Are you a Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...