-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
varfile
-
C
Access VBA - 'On Error' Send Email Help
Hi, I have the below code that picks up a file based on the contents of a Excel range. However, there will be occasions where a file won't be present. On these occasions I want the code to ping an email to me to let me know. As it stands, the below is sending me 3 emails rather than 1, can...- Cjdash
- Thread
- dim set strsql tlog varfile
- Replies: 1
- Forum: Microsoft Access
-
C
Access VBA - 'On Error' Send Email Help
Hi, I have the below code that picks up a file based on the contents of a Excel range. However, there will be occasions where a file won't be present. On these occasions I want the code to ping an email to me to let me know. As it stands, the below is sending me 3 emails rather than 1, can...- Cjdash
- Thread
- dim set strsql tlog varfile
- Replies: 1
- Forum: Microsoft Access
-
C
Access VBA - Picking up a predefined file
Hi, Having issues writing the below and getting it to work. I want it to be able to use a cell in an excel document to determine which file needs to be picked up, it's currently opening the dialog box where I'd usually select the folder, but not selecting the relevant file automatically. The...- Cjdash
- Thread
- dim end set varfile xlapp
- Replies: 6
- Forum: Microsoft Access
-
S
DoCmd.TransferSpreadsheet from Excel to Access using sheet codename - NOT tabname
Table name is employees File name is varFile (used with a file picker) This works: DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel12, "employees", varFile, False, "January!A4:AD10000" The problem is the tab names change each month. For the life of me, I can't get the sheet...- shanesuzanne
- Thread
- access employees excel varfile vba
- Replies: 10
- Forum: Microsoft Access
