Search results for query: *

I just finished porting my Accpac VBA script to an Excel VBA script and it appears to work properly. Does anyone have ideas on how to protect the password in VBA. I know I can add a password to not allow a user to open the VBA code attached to the Excel sheet without a password, but I would...

tuba2007, Thanks so much for your reply. I tried capitalizing my password and it now gets by that line. I don't understand why Accpac is case insensitive for password, but I am happy that that is the solution. For completeness, here is my code that puts a message box with the company name...

Hello all, I am trying to automate a process that we do over and over and run it at 2AM when all of the users are out of the system. I have written a Accpac VBscript to do it. It runs fine when I run it, but it asks for my password. I would like to run this script automatically at 2AM. I...

Hi All, Thank you for your help. I just found out that I was not following proper courteous rules for posting and accepting help on this message board. I am sorry that I offended some of you by not doing this. Thanks again for the help. -Paul

Hi All, I just got back from travel and being out sick. Thanks for the ideas. I do have a question.... What do you mean use a template? I create a new sheet in a workbook from a master list of 1000s of entries. I then save off a filtered workbook in a different file. I want to also copy...

Hi All, I am sorry that I have not responded to the answers that people have given me. I have read the comments, but have not had a chance to try them out. I was sent to Germany on company business and just got back from being out sick. I have been checking my email on a smart phone, so I...

Hi All, I am very close to 'launching' a new excel spreadsheet that multiple people will be using. When I have launched spreadsheets before that had macors in them almost all of my support questions are from people that do not enable the macros, therefore the macros don't work. Is there a way...

After searching for a while on the internet I found the following code that meets my needs. It emails via Outlook (so you have to have outlook installed on your machine; but you then do have a history of what was sent which for me is a good thing). It works pretty well. Sub...

Hi All, I have a report that I want created each night and emailed to a list of people. Is there a way to do this within Excel using VBScript. I already have an Excel VBScript to create the files. Thanks in advnace.

Hi All, Sorry if this is posted somewhere else. I have a question on how to create New Excel Worksheets from a Master. I am running a repair department at a company. I have a sheet that lists all of the units we have to repair. I have another sheet (workshop Master report) in the same...

Hi, This is probably a real easy question. Sorry I am a newbie. I have a workbook that has multiple sheets in it. I would like to run a VB macro that reads data from one sheet and then updates data on another sheet. I found that using thew following command...