Link to home
Start Free TrialLog in
Avatar of StewSupport
StewSupport

asked on

macro vb open dialog and read excel file

i'm new to writing macro in excel. can someone let me know how to write little macro that pops up open dialog pop to allow users navigate to whatever folder and then select an excel file. After selected the file and hit ok, what i need to do is read through the file and then put it into the right format and save it as new csv file with comma delimiter.
any help really appreciate. thanks
ASKER CERTIFIED SOLUTION
Avatar of darbid73
darbid73
Flag of Germany image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Can you pls post a sample file
- opening the file is easy
- your format requirements are unknown
- saving as csv is easy

Cheers

Dave