How can I create an Excel workbook?

[dBjason]

I need to prompt the user for a directory\filename then create a workbook and export worksheets to it, all from VBA. Does anyone know where I can find information on how to do this?

Thanks in advance,
Jason.

 

[Zathras]

Did you try to search for an answer?

Try this link: thread707-1001653

If that doesn't help, you might provide a little more information: What languange/application are you trying to do this in/from? What have you tried so far?

 

[SkipVought]

Hi,

  dim wb as workbook

  Do
    fName = Application.GetSaveAsFilename
  Loop Until fName <> False

  set wb = workbooks.add
...
  wb.SaveAs Filename:=fName

Skip,

_{[red]Be advised:[/red] When you ignite a firecracker in a bowl of vanilla, chocolate & strawberry ice cream, you get...
Neopolitan Blownapart!}

 

[dBjason]

Thanks a million Skip! Muchos Kudos! I was actually considering doing an API call for the SaveAs dialog!!

Zathras -- if you read my post I think you'll find that I'm programming in VBA, and there's not many Microsoft applications that deal with workbooks and worksheets. And yes, coming here was part of my search for an answer. But thanks to you just the same.