PDA

View Full Version : How To Create a spreadsheet in excel



thanhvanchi
12-04-2016, 01:33 AM
Hello everybody.
I'm trying to make a spreadsheet with a certain function, but don't know how. I'm guessing it takes two macros.


I'd like the spreadsheet to be able to do the following:


1. There should be a bottom where you can tell the spreadsheet/the macro where the txt-file is located. The content is then copied/imported into the spreadsheet.


2. And another bottom, you can push and the content of the txt-file is then copied/imported into the spreadsheet again (overwritten) without having to tell the location of the txt-file again. Sort of a "refresh" bottom, you can push when the content of the txt-file changes


Hope this makes sense.


Any ideas on how to do this?

Kenneth Hobs
12-04-2016, 05:14 PM
How is the file delimited? If you can attach a short example file, it will be easier to help. Click the Go Advanced button in lower right of a reply. Below the reply block, click the Manage Attachments hyperlink and browse and upload file.

A table query would the the usual way to do that with a the refresh option so (2) would not be needed.

p45cal
12-04-2016, 05:16 PM
See attached and its bottoms.