It's a 80mb file that is in a central directory and I don't want to premanently rename it. I tried to use the Copy command and it takes forever to copy across our WAN. I can't believe that VB and Access can't handle a file with multiple .'s in it.
Access 2003...I am attempting to import a file into access using the TransferText function but I receive a Runtime Error 3011, MS Jet db engine could not find the file. The file I am looking to import is named "wws070o.la.071016.003100.txt" (the numbers are a date and time stamp that will...
I don't insist on a macro solution. I am stating that, currently, this function is called by a macro. Does it matter how the function is called? The function PickFile works exactly how I want it to. I would just like the varFile variable to be passed a text box within my PickFile function...
I have a variable defined in my vb code and I would like to pass that variable to a text box on a form. I'm not sure how to go about doing that. Here is the code that I am currently using. I would like to pass the varFile.
Function PickFile()
Dim fDialog As Office.FileDialog
Dim varFile As...
I have installed Cisco VPN 3.6.3 on my home PC (running Windows ME) and when I boot up I have to choose Safe Mode to boot into Windows. I uninstall VPN and the PC boots fine. Is this a known issue? My company's Helpdesk has no clue. Thanks....
My users are telling me that the macro to do this was origianlly in Lotus. A number of years ago they converted over to Excel 97 and it worked just fine. Now that we have moved up to Excel XP that macro doesn't work. That's why I'm under the impression that a macro can be be created to do...
I don't use macros or VBA very often, but I need to create a macro in Excel XP. I need to start on a random cell, key in data, tab over two cells, key in data, tab over two cells, key in data, then go back to the cell I started in and go down four rows.
I would like to have the macro wait for...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.