Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Dec 2009
    Location
    Toronto, canada
    Posts
    23
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Need help with macro

    I would like to create a macro that will produce a PDF file of a section of a spreadsheet (can use range name). I need help with stopping the macro to insert a file name and then proceed to save the file. The best solution would be placing the new file name in a cell -linking to the cell in the macro and let it run.
    Any help would be appreciated.

  2. #2
    3 Star Lounger
    Join Date
    Apr 2001
    Location
    Levin, Manawatu-Wanganui, New Zealand
    Posts
    324
    Thanks
    9
    Thanked 28 Times in 26 Posts

    Use inputbox

    Hi
    This might be a pointer

    Sub pauseForName()
    dim sNewName as string
    sNewName = InputBox("Type new name")
    MsgBox sNewName
    End Sub

    There is still a bit of work to do.

    Cheers
    Geof

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •