-
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.
objectdim
-
A
Check if Spreadsheets in a Folder are Signed
I do not know if this is possible but basically I would like to have the spreadsheet check a folder, then return excel file names and whether the document is signed. I've tried a few things that don't seem to work. First I wrote this code to list all files within the folder: Sub Test()...- ashaneharris
- Thread
- file folder objectdim objfile signed
- Replies: 1
- Forum: Excel Questions
-
V
How to have Attachments based on a cell value VBA.
I'm currently trying to have the VBA running that will send the current files based on excel cells. I have a message error on the line : myAttachments.ADD "Sheet3.Cells(9, 2)" The cell B,9 currently have the following value : C:\Users\ojodoin\Desktop\Feuilledetemps.pdf which is where I want...- vba_tester
- Thread
- dim objectdim outlookapp outlookmailitem set
- Replies: 0
- Forum: General Discussion & Other Applications
-
D
Trying to get Excel to send a sheet as a PDF
Hiya Peeps, I wonder if someone can help me with this. I am trying to get the code to select the right data via autofilter, then email the sheet as a PDF. I have the following code: Sub Sort1() ' ActiveSheet.Range("$AB$4:$AB$350").AutoFilter Field:=1, Criteria1:=Array( _ "Care...- DipDip
- Thread
- care objectdim outlookapp outlookmailitem set
- Replies: 7
- Forum: Excel Questions
