Can I automate Wizard options in a macro?

T

Tony Sinclair

My experience level is high with computers in general, but low with
Excel. I am proficient in C#, but don't have a clue in VBA. I'm
using Excel 2007.

All I want to do is automate a paste operation. There is a website
that has historical data on sports stats, and I want to copy some
stats into a worksheet so I can do various analyses.

The paste requires a Paste Special/Text, and then using the Text
Import Wizard to specify delimited data, set a combination of
delimiters, and skip a few columns.

Sounds simple, but when I used the Record Macro function, all it did
was paste as text - it ignored everything I did in the Wizard.

I'm perfectly willing to read the docs on VBA if this can be automated
fairly easily, but I thought I'd ask here first and make sure I'm not
wasting my time. Is there something about Wizards that the macros
can't see?

Thanks for any help.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro that will insert a simple text string in top cell of text file 1
Copy/Paste Excel Macro 4
OpenText Method Question 5
manipulate other program using excel macro 2
Macro to Automate Text Import for Multiple Files 7
Data exchange between macro and spreadsheet 1
How can I automate filling in a Web form with Excel data? 1
Basic macro for copying into Excel 3

Top