Tech Support Guy banner

Discussions Showcase Albums Media Media Comments Tags

1-20 of 58 Results
  1. Business Applications
    Dear members, I'm having a lot of trouble with this VBA code for a table that has rows starting from 341-533 and columns A-K. I'm trying to write code that enters a specific string criteria in a text box to search for a string like "rent" or "volunteer" in a multiple detailed string column like...
  2. Business Applications
    Dear members, I'm having a lot of trouble with this VBA code for a table that has rows starting from 341-533 and columns A-K. I'm trying to write code that enters a specific string criteria in a text box to search for a string like "rent" or "volunteer" in a multiple detailed string column like...
  3. Business Applications
    Hi everyone, I'm trying to automate formatting a set of new downloaded data so I can update a master sheet as new years are added for the data. All of it was working fine, but now I've run into a problem with a certain section, where I attempt to make the naming of the countries the same. This...
  4. Web & Email
    I work for a company that reports to many other companies, and they ALL have their own rules about where to send emails, what the RE line should look like, etc. I've got checklists for each company but it would be a lot faster (and less prone to 'forgetting') if I could set up something where...
  5. Business Applications
    Hi there, I need assistance with some VBA. I have lots of Excel files with marks in a folder. All files have the name and final mark in the same locations. Presently, it is time consuming to open each file and type the mark in a final mark sheet. The number of students amount to around 100. I...
    vba
  6. Business Applications
    Hey, I'm trying to copy some values from one worksheet to another. The code works fine for the first row, but does not countine to the next ones. Here is the code: Sub VannprøveResultater() i = 3 j = 3 Worksheets.Add().Name = "Sheet4" Do Until IsEmpty(Worksheets("results").Cells(j...
    vba
  7. Business Applications
    Hello All I have what I'm sure to many of you will be an easy task but I'm clueless. I need to create a spreadsheet that needs to send reminders to a mailing list every three days from various dates (based on what the users input). I have no clue how to do that though.
  8. Business Applications
    Hi All, I am trying to save a timesheet template that I update monthly multiple times in the same folder. e.g. I have a template folder with excel files named Anne, Bob, Jane, Rachel, etc; and want to save the new template over the top of these. Currently I am saving them one at a time but I...
  9. Business Applications
    Hello, This thread touched on what I'd like to do but went into a different direction: https://forums.techguy.org/threads/access-print-tell-certain-pages-to-print-multiple-times.1212146/page-2#post-9529585 I am so close on completing my system except for one nagging problem. I would like to...
  10. Business Applications
    hello I d need to ask you for a help. I have a 300 pages document (no headers no footers) and i need to duplicate each page and then hide duplicates in order to process for translation. i want to avoid manual copy paste work. i was thinking either about macro or maybe duplicate all the file and...
  11. Business Applications
    Hi! I'd like to get a few cells in a list from a Google Sheets. I have the following data: First list horizontally: 1 in C2, 2 in D2, 3 in E2 Second list vertically: 1 in C5, 2 in C6, 3 in C7 Here is the test sheet: https://goo.gl/UDooqL I use the following script: function onEdit(){ var...
  12. Business Applications
    Good afternoon everyone - I need a bit of help with a few lines of code. Here's where the problem is: For i = 1 To Worksheets.count If IsError(Application.Match(Sheets(i).Name, s, 0)) Then Sheets(i).PageSetup .CenterFooter = PageFooterText End If Next i...
  13. Business Applications
    A while ago, OBP helped me create an excel sheet that automatically sends me an email when a cell displays "send". Lately it has been sending an email regardless of whether the cell displays send. It's also not displaying the "action required" in the email. I was hoping someone could point out...
  14. Business Applications
    Hello, With the help of OBP, I was able to automate an excel workbook to send reminders whenever a date is reached. This would occur whenever the workbook was opened, so I was hoping to open these workbooks on a task scheduler. The task scheduler on my computer, however, is not opening up the...
  15. Business Applications
    Hey all New here and new to VBA so I apologize if this is the incorrect place to ask this question or if I'm not including enough information. Basically I have two forms, one form that is a cost est. form and another form is a proposal form (client sees this one). I have the proposal form...
  16. Business Applications
    Hello, I've been online all day trying to find more info on creating an excel spreadsheet with VBA scripts to send an email when there is an upcoming due date. I'm trying to learn about macros and VBA scripts, but I've never learned how to code and this stuff looks very dense. In this...
  17. Business Applications
    Hi, It is the first time I try to work on VBA. I have a project to do at work but rather than learning from scratches which I cannot afford (time wise), I found a formula that seems to do the job. Private Declare Function ShellExecute Lib "shell32.dll" _ Alias "ShellExecuteA" (ByVal hwnd As...
  18. Business Applications
    Hi everyone, This is my first query on this forum. I was looking for a VBA Script to run a macro for Excel 2010 which could be used to send out reminders mails to multiple mail IDs in Outlook 2010, 14 days before the expiry of certain contracts. The details of the input sheet are as shown...
  19. Business Applications
    Hi everyone, This is my first query on this forum. I was looking for a VBA Script to run a macro for Excel 2010 which could be used to send out reminders mails to multiple mail IDs in Outlook 2010, 14 days before the expiry of certain contracts. The details of the input sheet are as shown...
  20. Business Applications
    Good day, First I'd like to say...This site is a great learning resource! Learned so much about VBA and Macros in just two days. Now the issue. I found two great codes that I will 'splice' together to get what I want...
1-20 of 58 Results
Top