Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro: Prompt user for xls file to add chart
I have a workbook called 'Source.xls' with a worksheet called 'Char
Data'. In 'Chart Data' I use a macro to generate data for producing chart. I produce a chart in this worksheet, and then I want to promp the user whether to also add this chart to another workbook (in worksheet) - ie in a different xls file. How could I go about doin this? All I have so far is: Sub ProduceChart() 'Produce a chart Dim sPrompt As String sPrompt = MsgBox("Add this chart to another worksheet?" Buttons:=vbOKCancel) If sPrompt = vbOK Then 'Prompt for workbook and worksheet to add chart. This workbook (an worksheet) may or may not be already open. End If End Su -- Message posted from http://www.ExcelForum.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Prompt For User Mouse Input In Macro? | Excel Programming | |||
Prompt user to save their file | Excel Programming | |||
Prompt user to select file with default file selected dialog | Excel Programming | |||
Prompt user to select file with default file selected dialog | Excel Programming | |||
Prompt user to select file with default file selected dialog | Excel Programming |