|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
|
Thread Tools | Display Modes |
|
#11
November 29th, 2008, 07:03 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
Help with macro
Theslaz, please post in the forum as you can benefit from the interface better. The attached file worked fine for me, although i do not have a fax printer, i simply print out to my default printer and a csv backup is made in T:\Fax Backup. +-------------------------------------------------------------------+ |Filename: Master Invoice 2008-09.xls | |Download: http://www.thecodecage.com/attachment.php?attachmentid=25| +-------------------------------------------------------------------+ -- Simon Lloyd Regards, Simon Lloyd 'The Code Cage' (http://www.thecodecage.com) ------------------------------------------------------------------------ Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=34925 
|
|
#12
November 29th, 2008, 07:24 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Help with macro
I think that I have fixed the printing problem. I placed the code for the printer at the beginning of the macro and it appears to be working. ActiveSheet.PrintOut Dim fRange As String fRange = Sheets("Job Pending & Completion List").Cells.Find(What:=Sheets("Print Invoice").Range("I2").Value, _ After:=Sheets("Job Pending & Completion List").Range("A1"), LookIn:=xlValues, LookAt:= _ xlPart, SearchOrder:=xlByColumns, SearchDirection:=xlNext, MatchCase:= _ False, SearchFormat:=False).Address With Sheets("Job Pending & Completion List") .Range(fRange).Offset(0, 7).Value = Date End With End Sub -- theslaz ------------------------------------------------------------------------ theslaz's Profile: http://www.thecodecage.com/forumz/member.php?userid=44 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=34925
|
|
#13
November 29th, 2008, 09:08 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Help with macro
Check out the latest attachment i made as it has the save code there! Newsgroups don't cope with the functionality of forum boards very well which is why i asked you to post here! -- Simon Lloyd Regards, Simon Lloyd 'The Code Cage' (http://www.thecodecage.com) ------------------------------------------------------------------------ Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=34925
|
|
#14
November 29th, 2008, 09:19 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Help with macro
Sorry for the double post! Some reason or another the original posts didn't show. Got your file and everything is working perfect. Couldn't ask for anything better. Thanks for your trouble. -- theslaz ------------------------------------------------------------------------ theslaz's Profile: http://www.thecodecage.com/forumz/member.php?userid=44 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=34925
|
|
#15
November 29th, 2008, 09:29 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Help with macro
Glad we could be of help! If your query has been solved please take a moment to let us and eveyone else know by going to Thread ToolsMark Thread Solved,shown by this icon27 +-------------------------------------------------------------------+ |Filename: marksolved.gif | |Download: http://www.thecodecage.com/attachment.php?attachmentid=27| +-------------------------------------------------------------------+ -- Simon Lloyd Regards, Simon Lloyd 'The Code Cage' (http://www.thecodecage.com) ------------------------------------------------------------------------ Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=34925
|
|
#16
November 30th, 2008, 02:40 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Help with macro
Simon Lloyd;127009 Wrote: Glad we could be of help! If your query has been solved please take a moment to let us and eveyone else know by going to Thread ToolsMark Thread Solved,shown by this icon27 Went to "Thread Tools" and it only gave three choices: Show Printable Version; Email This Page and Unsubscribe from this thread! -- theslaz ------------------------------------------------------------------------ theslaz's Profile: http://www.thecodecage.com/forumz/member.php?userid=44 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=34925
|
|
#17
November 30th, 2008, 02:47 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
[SOLVED]: Help with macro
Ah yes, my fault, its because you continued the thread from the one imported from the newsgroups. No worry i've done it! Thanks for that. -- Simon Lloyd Regards, Simon Lloyd 'The Code Cage' (http://www.thecodecage.com) ------------------------------------------------------------------------ Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=34925
|
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
