macro: how to browse excel file and read data

Question

I am writing a macro script in 3 steps:

read an excel file by browse - transfer to xml format - export xml file to certain path by browse. I know how to export by browse alrady.

Set objShell = CreateObject("Shell.application")
Set objFolder = objShell.BrowseForFolder(0, "choose the path you want to export the xml file", 0, 0)

but this one is browseforfolder.

How to browse for file? if I want to import excel data by browse?

thx

You have not accepeted an answer to any of your prior questions. You are more likely to get assistance if you are viewed as engaging fully with the people helping you. — brettdj
– brettdj, Commented Sep 11, 2012 at 7:56
excuse me, I log SO about 3 weeks. every time i just click "yes" for "is it useful for you?" but how to show I accept the answer? — TJLD22
– TJLD22, Commented Sep 11, 2012 at 8:07
Just click the gray check-mark next to the answer that solved your problem. stackoverflow.com/faq#howtoask — Olle Sjögren
– Olle Sjögren, Commented Sep 11, 2012 at 9:04

Kovags · Accepted Answer · 2012-09-12 08:19:02Z

2

To open the "open file" dialog, I use the following:

FileOpenName = Application.GetOpenFilename(fileFilter:="All files (*.*), *.*")

Then you're going to need following to open the files the

Open FileOpenName For (Binary|Write) as #1
   'Do writing operations here
Close #1

edited Sep 12, 2012 at 8:19

answered Sep 11, 2012 at 9:13

Kovags

5403 silver badges16 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

TJLD22 Over a year ago

thx. could u explain further if the script want to use several worksheets' data from that FileOpenName. I do not understand very much about that Open... Close #1.

Collectives™ on Stack Overflow

macro: how to browse excel file and read data

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related