ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Help about macros (https://www.excelbanter.com/excel-programming/392962-help-about-macros.html)

Laininha

Help about macros
 
I have around thirty different .txt files that I have to import to excel,
exclude lines, format cell, and make a graphic. Can I use a macro to format
these many files? Or I have to record a macro for each excel file? I'm
somewhat new at macros, then I would like some help with this issues, please!

Tom Ogilvy

Help about macros
 
http://www.rondebruin.nl/tips.htm

Look under
Copy/Paste/Merge examples

section for items about text and CSV files.

For charts

John Peltier
http://peltiertech.com/

http://pubs.logicalexpressions.com/P...cle.asp?ID=209
Charting FAQs

--
Regards,
Tom Ogilvy



"Laininha" wrote:

I have around thirty different .txt files that I have to import to excel,
exclude lines, format cell, and make a graphic. Can I use a macro to format
these many files? Or I have to record a macro for each excel file? I'm
somewhat new at macros, then I would like some help with this issues, please!



All times are GMT +1. The time now is 12:30 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com