in
All Tags » VBA » file (RSS)

Browse by Tags

  • Text File and CSV file

    I would like to know how to scroll through a text file as well as through a SCV file, with a loop like DO WHILE-END DO 1-- let's say we are using VB or VBA and we have a text file we want to scroll through the text file(all lines) to see if a certain string exists, using a loop from VB/VBA 2- we...
    Posted to Miscellaneous (Forum) by microsoft on 05-10-2010

  • Open hidden txt files with VBA Open statement

    Hello, in an Excel 2003 vba function I'm trying to open a normal txt file like this: Open filename for input as #1 It works fine until I hide the file (using explorer's file properties). When the file is hidden, the function can't find it anymore... what am I missing? How can I retrieve it...
    Posted to Miscellaneous (Forum) by microsoft on 05-08-2010

  • Excel VBA: setting path for 'open file' dialog

    Hello, I'm using Excel 2002 on Windows 2000. In some VBA code I need to get the user to open a file from a certain location, or at least get the dialog box to default to that location. I also need to know whether a valid file has been opened and what the file name is. This is what I'm currently...
    Posted to Microsoft Office (Forum) by microsoft on 04-23-2010

  • Opening a access mdb with vba

    Hi all, I'm trying to call another access mdb on a commandbutton_click() Synatx as follows: stAppName = "C:\Project\Inventory.mdb" Call Shell(stAppName, 1) This throws me an error "Invalid procedure call or argument". If I were to change to this, stAppName = "Access.exe C...
    Posted to Access (Forum) by microsoft on 04-19-2010

  • Access VBA open file where path & name specified in textbox

    Hi In Access VBA how do I open a file wherethe path & name are specified in textbox The textbox is called txtFile Thanks
    Posted to Access (Forum) by microsoft on 02-01-2010

  • VBA Macro to edit .bat file

    Hello Experts, I am in the process of creating some VBA macros that will initiate a DOS script in a batch file that will run FTP . Below is the DOS Script... @echo off set /p ftp_file_date=Please enter the transaction file date (YYMMDD): set /p ftp_user=Please enter your PMTDEV user name: set /p ftp_pass...
    Posted to MS DOS (Forum) by microsoft on 01-30-2010

  • How do I import a .csv file using VBA?

    Hi Experts, How do I import a .csv file using VBA? Thanks
    Posted to Access (Forum) by microsoft on 12-20-2009

  • VBA Export Table to CSV file

    Hi I want to make a "export"button on a form to transform a table into a .csv file. Can somebody help me with the right VBA code? I've tried things like: DoCmd.TransferSpreadsheet acExport, "RESULTS", "C:\Temp\Results.csv" Hopefully somebody can help me J
    Posted to Access (Forum) by microsoft on 12-20-2009

  • Generic path to open a file from VBA

    Hi EE, I have a code that opens two files. Both the excel file and the files to be opened are placed in the desktop. Now I use the instruction ChDir to set the Desktop folder the place where VBA must go to open both files. But this vba code must be used in several pc's, and in every pc the desktop...
    Posted to Excel (Forum) by microsoft on 12-15-2009

  • Download txt file from website suing VBA

    Hi, I'm trying to find a way to download a txt file from a website using Acess. I have a database that has a specific named file that's already linked. I have multiple tables that are dependent on this linked table, and I want to use VBA to update this table by downloading a new set of data daily...
    Posted to Access (Forum) by microsoft on 11-11-2009
Page 1 of 5 (50 items) 1 2 3 4 5 Next >