+ Reply to Thread
Results 1 to 2 of 2

SAP Exports file location

  1. #1
    Forum Contributor
    Join Date
    02-20-2017
    Location
    Indiana
    MS-Off Ver
    2016
    Posts
    101

    SAP Exports file location

    Hello,

    my VBA code is running a VBscript to export a report from SAP so, I need to pause my VBA script to account for the time that it takes the VBscript to run. I have a function, not made by me, that checks to see if a file exist on my desktop and doesn't continue until the file exist. This works great, but this SAP report can not be saved to the desktop, it can only be exported to excel. The exported excel sheet is titled Worksheet in Basis (1). I'm hoping someone can shed some light as to where SAP exports this file to or can help edit the function to accommodate the file not being saved.

    Here is the Wait for file function

    Please Login or Register  to view this content.

  2. #2
    Forum Contributor
    Join Date
    02-20-2017
    Location
    Indiana
    MS-Off Ver
    2016
    Posts
    101

    Re: SAP Exports file location

    I've been thinking about this a bit more and think that I should loop a check to activate the wb.

    If the wb activates = true, then end the Sub and continue the vba script, if unsuccessful = false, keep trying to activate the wb until true.

    Any comments on whether this sounds possible or any oversights you might see would be appreciated. Also, if you feel motivated enough to layout some functionality, that would be great.

+ 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. Mac excel 2016, vba copy file from one location to sandbox location
    By sujithy007 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-11-2016, 12:01 PM
  2. [SOLVED] Macro to Save Excel File to a SharePoint location and then e-mail that location in Outlook
    By NickyHavey in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-11-2016, 09:27 AM
  3. VBA Code to SaveAs file in one location, and backup to another location
    By honger in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 04-09-2014, 10:57 PM
  4. [SOLVED] Specify export pdf file location is location workbook is saved.
    By dantray02 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-30-2014, 01:13 PM
  5. [SOLVED] [Help]macro to open file browser, to select a location, and save the location to a cell
    By zhuleijia in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-06-2013, 09:56 AM
  6. Replies: 1
    Last Post: 10-31-2012, 11:19 AM
  7. " in tab delimited file exports
    By PhilSM in forum Excel General
    Replies: 1
    Last Post: 01-26-2009, 07:00 AM

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