Results 1 to 3 of 3

Selected cell value in a specific range to open file based on cell value

Threaded View

  1. 09-04-2022, 06:33 AM #1
    nik_re
    nik_re is offline
    Registered User
    Join Date
    10-17-2019
    Location
    Stockholm
    MS-Off Ver
    365 ProPlus
    Posts
    70

    Selected cell value in a specific range to open file based on cell value

    Hello,

    I am trying to assign the value of the selected cell in the range C6:C1000 to a variable to open the file related to the value in the selected cell.

    I am not sure how to use application.ActiveCell... It doesn?t work, it just does nothing...

    Attached is the file with the code in it.

    Please help me.
    Attached Files Attached Files
    Last edited by nik_re; 09-04-2022 at 07:20 AM.
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. VBA To Search Through System Folder(s) & Open The Corresponding File To the Selected Cell
    By leviclagett in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-09-2020, 09:58 PM
  2. calculate specific percentage based on a value in cell, when cell is selected
    By jirrah in forum Excel General
    Replies: 2
    Last Post: 05-31-2019, 10:42 AM
  3. Make userform open when a blank cell in a range is selected, and not open if value in it
    By jtemp57 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-23-2014, 12:13 PM
  4. [SOLVED] How to set macro to open word file equal to cell contents of a specific cell
    By ligerdub in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-21-2012, 02:39 PM
  5. [SOLVED] Export to open .csv file a selected cell range conditioned on a true/false in same row
    By BigAl_Qld in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-20-2012, 07:31 PM
  6. [SOLVED] Open form if cell in a range is selected
    By Marco-Kun in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-24-2012, 04:08 PM
  7. [SOLVED] Open an Excel File from Selected Cell
    By maperalia in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-14-2006, 04:25 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1