+ Reply to Thread
Results 1 to 3 of 3

How to access specific answers addressed when one sees "please login to view results?"

  1. #1
    Registered User
    Join Date
    08-02-2012
    Location
    Dallas, Texas
    MS-Off Ver
    Excel 2007
    Posts
    44

    How to access specific answers addressed when one sees "please login to view results?"

    Sorry folks, as "intuitive" as I think I am, this one I'm totally lost on. Did a Google referencing
    how to generate a filename for a new workbook based on information in 2 cells in the active worksheet.
    When I found a possible solution under Excel Forum's, the answer says, "Login or Register to view the content"
    So, I login and am taken to what I suppose is the home screen with no reference whatsoever to the location
    of the response I wish to view.

    Am sure there is a simplistic answer. If someone wouldn't mind sharing, I would most appreciate how to access
    the answer to that question. If this has been answered before, apologize, just point me in the right direction.

    My issue is trying to name a new workbook to which I am saving a worksheet with the SaveAs command.
    Works beautifully if I stick in a name. However, need to make the code more versatile. I want to use
    the name that is in a cell on the worksheet to save the workbook as. I may want to concatenate names in
    a couple of cells. Something on the order of:

    code, ...[Test_Copy_ChemicalToWorkbook.xlsm]Threshold!Range("C2").Value.xlsx",
    Where [ ] is workbook name
    Threshold is name of worksheet
    C2 is the cell that has a name I want to use?

    Most courteous...
    Sgt Rock in a HOT Dallas

  2. #2
    Forum Expert
    Join Date
    10-09-2012
    Location
    Dallas, Texas
    MS-Off Ver
    MO 2010 & 2013
    Posts
    3,049

    Re: How to access specific answers addressed when one sees "please login to view results?"

    Have you declared a variable then defined the variable as that particular cell THEN use the variable name in the save line?
    Please ensure you mark your thread as Solved once it is. Click here to see how.
    If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.

  3. #3
    Registered User
    Join Date
    08-02-2012
    Location
    Dallas, Texas
    MS-Off Ver
    Excel 2007
    Posts
    44

    Re: How to access specific answers addressed when one sees "please login to view results?"

    Once I realized that I was in the new workbook and not in the old workbook with code....the light bulb came on...

    Thus I set two variables to the name I wanted to make the workbook - FacilityName and RY

    Option Explicit
    'NewWB = NewWorkbook
    'Generate a new workbook to hold all the chemical threshold sheets

    Sub AddNewWB()
    Dim NewWB As Workbook
    Dim FacilityName As String
    Dim RY As String
    FacilityName = Workbooks("Test_Copy_ChemicalToWorkbook.xlsm").Worksheets("Threshold").Range("C2").Value
    RY = Workbooks("Test_Copy_ChemicalToWorkbook.xlsm").Worksheets("Threshold").Range("C5").Value
    Set NewWB = Workbooks.Add

    Then...

    With NewWB
    'Once you have the path to your desktop, place your path in place of "C:\USERS\Morton Wakeland\Desktop\"
    'Insure you inlcude the path in quotes!!
    .SaveAs Filename:="C:\USERS\name\Desktop\" & FacilityName & "_" & "RY" & RY & "_" & "Thresholds"
    End With

    Finally worked....woooohooooo
    thanks for your kind response...
    Sgt Rock (Mort)

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. input type "hidden" onclick "document.text.submit ...for web login and parsing
    By hgtenn in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-21-2014, 08:40 PM
  2. [SOLVED] how code do i need to write before "RANGE("A1").value to access a specific worksheet?
    By kjy1989 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-04-2013, 03:46 AM
  3. Change "Parent" cell based on results of multiple "Children" cells
    By ccowman in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 12-14-2012, 02:33 AM
  4. [SOLVED] A19 has this instruction: =IF(f19>0,"X","") ---- F19: =E32 ---- A19 sees a value…
    By r1gg5 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-07-2012, 11:37 PM
  5. "IF" "AND" Statement to give 3 different answers
    By AllenMead in forum Excel General
    Replies: 4
    Last Post: 11-05-2010, 07:03 PM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1