Question about Microsoft Windows XP Home Edition

1 Answer

One problem in the application of excel sheet

How we are store data automatically in excel sheet from given this data from only one excel sheet block after time intervels continuously.

Posted by on

  • Brian March May 11, 2010

    Sorry, please be more specific with your problem.

×

1 Answer

  • Level 3:

    An expert who has achieved level 3 by getting 1000 points

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

    Genius:

    An expert who has answered 1,000 questions.

  • Master
  • 1,554 Answers

I can make out that
You are speaking about creating a macro to take data from one constant updated cell and to put that data into another cell or form sheet.
You will need to get precise help from a programmer on this.
If you want to see a little on macros just open a sheet and checkout the help section on macros.
Some macros can take many hours to write and test.Some make take months.
hope this helps.

Posted on Jan 31, 2008

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

2 Answers

What is exel sheet extension in office 2010 ?


Excel Workbook

.xlsx

The default Excel file format. Cannot store VBA macro code or Microsoft Excel 4.0 macro sheets (.xlm files in Excel 4.0).

Excel Macro-Enabled Workbook

.xlsm

Uses the same basic XML format as the Excel Workbook, but can store VBA macro code. Users saving an Excel workbook that has VBA code or Excel 4.0 macro sheets (.xlm files in Excel 4.0) are prompted to use this file format.

Excel Template

.xltx

The default file format for an Excel template. Cannot store VBA macro code or Excel 4.0 macro sheets (.xlm files in Excel 4.0).

Excel Macro-Enabled Template

.xltm

Can contain a VBAProject part or Excel 4.0 macro sheets (.xlm files in Excel 4.0). Workbooks created from this template inherit the VBAProject part or Excel 4.0 macro sheets that exist in the template.

Excel Add-In

.xlam

A supplemental program that runs additional code. Excel add-ins use the Open XML file format to store data, and they support using VBA projects and Excel 4.0 macro sheets.

Feb 21, 2011 | Operating Systems

1 Answer

Different between MS EXCEL & ACCESS


Hi. MS Excel is for spreadsheet. Very useful when creating accounting documents. MS Access is for database. Very useful when collecting data.

Please visit these links to learn more about the 2 applications:
http://www.blurtit.com/q373300.html

http://office.microsoft.com/en-us/access-help/using-access-or-excel-to-manage-your-data-HA001042918.aspx

http://www.thetechfaq.com/2010/03/14/microsoftaccess-and-excel-comparison/

Sep 03, 2010 | Microsoft Windows XP Media Center Edition...

5 Answers

I have lost the excel password and i want to recover or remove the password from that excel file


lost excel password?
Type "excel password recovery" into Google and you'll have a choice of many suppliers who sell software that will reveal an Excel password. I have tested most of their free trial version .Excel password recovery 5.0 is my favourite one,it is 100% recovery rate and easy to use.and most of all,it is the cheapest.just have a try

Jun 21, 2010 | Operating Systems

3 Answers

Export the data from excel to tally


  1. make a sale entry in tally
  2. Export the voucher from tally in xml format (this is to give u how the xml looks)
  3. Open the excel file where all the data is ther.
  4. open a word file, so that we can prepare the xml for mutiple vouchers. For this we will use Mail Merge facility
  5. in the XML which we did in step two, copy the data from "<TALLYMESSAGE xmlns:UDF="TallyUDF">" till the </TALLYMESSAGE>
  6. Now open the word file, go to mail merger, select the fields which needs to be changed, that is the Debtors and the amount (for normal sale entries) which should change for every sale voucher.
  7. create the mail merge.
  8. copy the data what you got in word file to a note pad and name it as sample.
  9. open again the step 2 - copy data from " <ENVELOPE> to <REQUESTDATA>" and paste in the begining of the notepad sample
  10. go the end of the notepad sample and copy the data from first file -"step 2" from " </REQUESTDATA> to </ENVELOPE>" and save the file
  11. Open tally
  12. go to import vocuhers
  13. specify the path of the notepad sample and yes ur data got imported.

Apr 21, 2010 | Microsoft Windows XP Professional

2 Answers

Excel work sheets delete,pls how is it restore


Easiest way would be to use the Undo function to work your way back to the point prior to deleting the worksheets. If you can't back up through the list that far, you could close the file WITHOUT SAVING IT, then reopen the original file again. If you have already saved the document after deleting the worksheets, you will have to restore it from a backup (you do perform backups, right?) and continue working fro there.

Apr 15, 2009 | Microsoft Operating Systems

1 Answer

In visual basic , how to store data or retrive data in or from a various tables


You must not be referencing the second table properly, the reason your first one works is because it is automatically referenced, what I mean is that Me.dataTable and dataTable will both work in the same scope.

Jul 19, 2008 | Operating Systems

1 Answer

DOS Programme to txt file


Assuming that you are not able to export the data from the
original point of sale application, which is obviously the
best choice...

1)
Try to open the file(s) with Microsoft Excel (make sure that all of Excel's input conversion filters have been installed and enabled).

Most database files are organized as a set of (nested)
two dimensional data tables, which can be individually
imported into Excel as spread sheets.

Excel is very good at detecting and converting database tables.
Other spread sheets such as Lotus 123, or Quatro pro may also
be able to do this.

2) Microsoft Access may also be capable of importing
and converting the entire database.

3) Heavy duty data-base modeling suites, such as ER-Win
by Computer Associates (CA) may also be able to import
and export the database.

4) If the files are in the open *.dbf format, then I have the binary
file specifications, which can be used to decipher the files.

5) The files may also be simple tables, which are TAB, SPACE,
or COMMA (etc.) delimited, and you should be able to recover
these with a simple notepad editor or uuedit.

6) Most DOS programs (not all) can also be run under Windows
XP, using the command prompt:

START ==> All programs ==> Accessories ==>
Command Prompt.

========================================
Most importantly, we need to know the name of the application
that created the files, or see a sample of the file, to give you
further advice.

Martin

May 07, 2008 | Operating Systems

1 Answer

Pls hepl me wit Excel VB integration


you can use a OLE object that is available in VB as standard object. Drag the tools to your form that your creating and it will ask for create or link existing object. so now browse to the excel sheet and embed it into the VB form or use run time for manuplating the cells and other info in excel.

Mar 25, 2008 | Operating Systems

2 Answers

How to hide sheet tabs in MS Excel


Do you mean by Visual Basic / Macro?

if so this is what you need:

ActiveWindow.DisplayWorkbookTabs = False

Mar 07, 2008 | Operating Systems

4 Answers

Recovery excel password


http://www.straxx.com/excel/password.html

Feb 28, 2008 | Microsoft Windows Vista Ultimate Edition

Not finding what you are looking for?
Microsoft Windows XP Home Edition Logo

Related Topics:

110 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Operating Systems Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Scott Fryer

Level 2 Expert

80 Answers

Carlos L. Burgos
Carlos L. Burgos

Level 2 Expert

508 Answers

Are you a Microsoft Operating System Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...