+ Reply to Thread
Results 1 to 6 of 6

Continuare MACRO dopo apertura file

  1. #1
    Registered User
    Join Date
    07-08-2021
    Location
    italia
    MS-Off Ver
    office 2010
    Posts
    3

    Continuare MACRO dopo apertura file

    Ciao a tutti,

    non riesco a creare una macro che mi apre una cartella dove selezionando e apro un file e continui automaticamente.

    dopo l'apertura del file vorrei che continuasse le istruzioni della macro.

    allego file di esempio

    Grazie Roberto
    Attached Files Attached Files
    Last edited by robybarc; 07-27-2021 at 09:04 AM.

  2. #2
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    365
    Posts
    21,150

    Re: Continuare MACRO dopo apertura file

    Ciao, il mio italiano cattivo ma il mio VBA buono :-)

    Penso vuoi questo ma non c'e istruzioni a continuare...?

    Vuoi aprire la file nella VBA, non con Shell.

    Please Login or Register  to view this content.
    Jeff
    | | || || || || | |:| | || ||
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Registered User
    Join Date
    07-08-2021
    Location
    italia
    MS-Off Ver
    office 2010
    Posts
    3

    Re: Continuare MACRO dopo apertura file

    hello 6StringJazzer
    thank you for your suggestion,
    your macro gives me an error in the instruction
    If FName = False Then
    I deleted some instructions and now it works perfectly
    even though I have given up checking for the existence of the folder
    thanks again
    Roberto


    Please Login or Register  to view this content.
    Last edited by robybarc; 07-20-2021 at 10:57 AM.

  4. #4
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    365
    Posts
    21,150

    Re: Continuare MACRO dopo apertura file

    My mistake. In my original code it should be

    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    07-08-2021
    Location
    italia
    MS-Off Ver
    office 2010
    Posts
    3

    Re: Continuare MACRO dopo apertura file

    thanks again, it works perfectly

  6. #6
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    365
    Posts
    21,150

    Re: Continuare MACRO dopo apertura file

    Prego!

    If your question has been answered please mark your thread as "Solved" so that members will know by looking at the thread title that your problem is solved. Go to the menu immediately above your first post to the thread and click on Thread Tools. From the dropdown menu select "Mark this thread as solved..."

    If a member helped you solve your problem, consider adding to their reputation by clicking on the star icon addreputationiconsmall.jpg below their name.

+ 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. Macro - Open File Explorer, Select File, Import certain information from file
    By Drayde in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-25-2015, 08:58 AM
  2. [SOLVED] Macro that prompts user to select a file to open and perform another macro on this file
    By grimmy26 in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 01-16-2014, 08:39 AM
  3. Save as macro that specifies file type, file location and takes file name from three cells
    By ExcelFailure in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 06-13-2013, 10:09 PM
  4. [SOLVED] Macro - Master file to import data from another open file with variable file name
    By jdodz in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-10-2012, 10:56 PM
  5. Replies: 8
    Last Post: 11-12-2012, 02:39 PM
  6. macro prompts immediately to open a file once the Excel file with the macro is opened
    By jhmayor03 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-03-2012, 10:00 AM
  7. [SOLVED] VBA Code to Enter File Name, Activate the File, and Run Macro on File
    By DHartwig35805 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 01-09-2012, 03:49 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1