Specify an Input file?

  • Thread starter Thread starter David Evans
  • Start date Start date
D

David Evans

What I'd like to have, is a system so that users can specify a .CSV t
get some data from.

Currently, my macro only will generate a Pie Chart from a variabl
range of values, but as the data will come from a .csv file, i'd lik
users to be able to specify where the data is coming from.

Any ideas
 
Use the GetOpenFilename method to get the file name. For more see the
XL VBA help.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 

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

embedding a macro when generating a CSV file 1
Frontpage 2000 - Going to a new page from a value in a drop-down box 0
Graph and Input box for Date Range 1
Export Pivot table 1
"circular" concentric charts - like a pilot's plotting/nav computer 1
Reading data from CSV file 2
Want Macro to save to .xlsx 2
Pie of Pie Chart - Correct input of data 1

Back
Top