Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. VbaNewbie08

    Excel mail merge macro print error

    The excel mail merge code below runs fine, but for some reason excel default printer wont work once the macro is finished. The only way to fix it is got to windows change default to another printer and change default back. Any help would be appreciated as i'm some what still new to this. Sub...
  2. VbaNewbie08

    Excel printer issue with word mail merge

    The code below runs fine, but for some reason excel default printer wont work any more. The only way to fix it is got to windows change default to another printer and change default back. Any help would be appreciated as i'm some what still new to this. Sub RunMerge() Dim wd As Object...
  3. VbaNewbie08

    Copy range in excel as image and email with lotus

    I found the code below for sending an email throught lotus notes. The problem i'm having is i need it to copy Range(A1:G20) as an image and insert into the body. Im not quite sure how to do this. Sub SendNotesMail() Dim Maildb As Object, UserName As String, MailDbName As String Dim MailDoc As...
  4. VbaNewbie08

    need a little help with my VBA coding

    Skip/vzachin, I just wanted to say thanks for all your help. I was able to complete and test the macro yesterday. The test was a complete success!!
  5. VbaNewbie08

    need a little help with my VBA coding

    Skip, I missed understood your previous statement. I guess you should not trust either one of me since i am no longer here mentally. Now back to subject, i will try again explain in detail. Once you hit enter the if statement will check to see if extra proceded to screen 2. If it proceded...
  6. VbaNewbie08

    need a little help with my VBA coding

    Skip, im not recieving an error, just not sure how to write the loop situtaion into each if statement.
  7. VbaNewbie08

    need a little help with my VBA coding

    Here is what my code looks like so far. The last thing i need help with is getting it to start the loop over on the next row in excel after it has found an error see #*#*#*# below Sub Main() '*************************** Dim warn As Integer ' No = 7 Yes = 6 warn = MsgBox("Are...
  8. VbaNewbie08

    need a little help with my VBA coding

    sorry i used the wrong url tag for the photo, here is the correct one.http://picasaweb.google.com/wike05/Extra/photo?authkey=wN4OQtivMRA#5218784802777735874
  9. VbaNewbie08

    need a little help with my VBA coding

    vzachin, Thanks for the post. I think were moving in the right direction, but here's the scenario. 1. You enter data on screen 1 and hit enter A. If there is no error it will go to the next screen so you can finsh keying the invoice. B. If there is an error it will stay on the first...
  10. VbaNewbie08

    need a little help with my VBA coding

    I copied that code from a previous post on this site, and edited to fit my scenario. The problem is I don’t know much about writing, I mainly know how record and edit. So i'm not sure how to get the "GetString" working
  11. VbaNewbie08

    need a little help with my VBA coding

    Skip, The loop has been fixed. Thanks. Can you help with the other 2 issues or point me in the right direction?
  12. VbaNewbie08

    need a little help with my VBA coding

    im having problems with the ** areas below. I apologize im a newbie when it comes to this kind of stuff Sub Main() 'Extra Objects Dim System As Object Dim ExScreen As Object Set System = CreateObject("EXTRA.System") Set ExScreen = System.ActiveSession.Screen 'Excel...

Part and Inventory Search

Back
Top