Try the below...then you can use either "FileName" in your transfer spreadsheet method. Below I am searching for a text file, but you can change the .txt to .xls to get the same results. Good Luck!
Public ProsDataFile As String, fileerror As Boolean, FileName As String, FileGrab As String...
Hello. Ran into this one myself. I think you are looking for the FileDiaglog object. Check the help files. If you are still stuck, repost and I will try to find some old code of mine.
Good luck!
I think it may have something to do with your syntax. It looks like you are missing a quotation mark...below is the line I use and it works fine.
.Filters.Add "Excel", "*.xls"
Hope that helps.
Rocky
Hello.
I am trying desperately to output data from an Access form to an excel spreadsheet. I have it working fine, but the end users would now like the ability to navagate to a workbook with a name of their choosing (it would contain the same sheets within). I think the best way is to capture...
Set up variables such as PeriodFrom and PeriodTo as global variables. Then set these variables equal to your form selection in code behind the form. Set up two functions like below. Next in your query replace [Forms]![frmPlantReports]![Text4] with PerFrom() in your Between statement...
The users have requested automated charts/graphs on a set of data. I am fine with the charts but this request has me stumped. There is a set of data from a table that represents a number of months:
3
1
7
6
4
24
12
I need to sort this into groupings:
0-3
3-6
6-12, etc.
Then represent it in...
We use the shell command to initiate an instance of Access. It works fine in Access97 on our Windows 95 platform. We have converted to Windows 2000 and upgraded to Access 2002 and now the command doesn't seem to work. Shell is still a valid command, so we are lost.
This is probably a simple one, but I have an Access application that uses a valuation date and subracts 3 months and uses the resulting date for calculations. This has worked fine until this month where the valdate is now 2/28/02. The resulting calculation is 11/28/01. What am I doning...
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.