+ Reply to Thread
Results 1 to 2 of 2

macro or software can opened an excel file copy a cell and open an external invoice

  1. #1
    Forum Contributor
    Join Date
    02-11-2014
    Location
    mauritius
    MS-Off Ver
    MS365
    Posts
    1,086

    macro or software can opened an excel file copy a cell and open an external invoice

    I have everyday a lot of csv files to upload by jobnumber to an external interface .

    What I am looking is to open always a specific excel file on my desktop, in which cell A will have a job number cell B an order number .

    The code should be able to copy the cell A in memory, then go to a specific directory on my desktop ,look for that jobnumber in that folder which will be a aaa0111tb001 .csv, then open the external interface shortcut , put the login name and password , go to specific menu, open a submenu insert , paste jobnumber to a specific field and click up load .

    Then copy cell b order number in memory ,go to the interface which is already opened , then to specific menu , open and paste that cell B order number , enter , the file will pop up , then select the first record ,go a to a specific click button , a menu will pop up , then click to 2 button retrieve , save until end of record .

    Any one can suggest if this can be done with vba or specific software .I was thinking to amacro recorder or jibit macro recorder .

    Any ideas welcome

  2. #2
    Valued Forum Contributor ranman256's Avatar
    Join Date
    07-29-2012
    Location
    Kentucky
    MS-Off Ver
    Excel 2003
    Posts
    1,177

    Re: macro or software can opened an excel file copy a cell and open an external invoice

    sounds do-able, but, not sure about this 'job interfaace'. What app is it that needs to login/password?
    Is it an FTP app?

    vb macro can to all the copy and open of the csv, but not sure about the upload.

+ 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. [SOLVED] Automatically change all external links based on a cell value when an Excel file is open
    By billj in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-10-2017, 07:33 PM
  2. External Data from Microsoft Query - Excel File - Causes external file to open.
    By lee1000d in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-25-2015, 02:25 PM
  3. macro that browses external file and copy its name to a certain cell of a worksheet
    By mlcfexcel in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-15-2015, 08:04 AM
  4. Saving Invoice where next time I open file the Invoice Number increases by 1
    By domgee in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-22-2013, 03:03 PM
  5. 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
  6. Macro to open/close a file only if it isn't already opened/closed
    By catccc in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-24-2010, 10:27 AM
  7. Bug when macro tries to open allready opened file
    By Snoopy in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-07-2006, 08:20 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