Search results for query: *

Hello all, Is there any way to rename a sheet without opening the workbook? I have automated reports that usually have an invalid sheet name so the workbook won't open through VBA? Any help would be appericated. Thanks Matt

Hello, I have written an Outlook add-in in Visual Studio .net 2003 and installed it on the machine it was built on. I need to be able to deploy this add-in to about 6 other computers. I tried to install the MSI package on another computer. This installation went through fine but the add-in...

All, I would like to be able to remove the last line of a text file, add more lines to that text file and then re-add that line. I can open the file and either write over the file or append to it but I cant figure out how to remove the last line and then append. Thanks for your help Matt

Hello, I have a batch file that calls a VBscript for every computer in a text file. This VBscript needs to be able to create/modify a registry key on the computer it recieves as a parameter. I have not been able to find anything about RegCreateKey or RegCreateKeyEx that allows it to connect to...

Hello, I am trying to export a Excel spreadsheet into a Access database using the TransferSpreadsheet command. I am running a macro in Excel 2003 to format the open spreadsheet then export it to Access. I have gotten the Transfer command to work in Access VBA but not in Excel. The script line...

Hello all, I work at a Help Desk and we are trying to use Excel 2003 to monitor our Blackberry server. This server using a table on a web page to display pending e-mails and such. I have set up a Web Query in an Excel spreadsheet that refreshes every 3 minutes. My question is it possible to run...

Hello all, Is there any way to test to see if the current child tag is the same as the child tag in the parent before or after the child? <Questions> <question> <category>Outlook</category> <ask>Some Question</ask> </question> <question> <category>Outlook</category>...

Hi, I am trying to create a web page using an xml file and xstl. I would like to display a list of questions then when the user clicks on a question the answer appears below the question and clicks on the question again to hide the answer <Questions> <question> <ask>Why?</ask> <answer>Cause I...

Hello all, In Access I know you can export all of a database to an XML file, but is there a way to export each record as a different XML file? Thanks in advanced, MAC

Hello, I am trying to verfiy the computers on the network using the output of the net view command. This is what I have so far net view > netview.log for /f "tokens=1" %%A in (netview.log) do (call checker.bat %%A) The problem exists becuase net view's output has a header as so. Server Name...

Hi I am getting a Type Mismatch error on a statement that runs 90 some times before erroring out. Here's the statement. Type mismatch on the same variable? Final.Cells(y, AnWeekCol) = 1 + Final.Cells(y, AnWeekCol) Cell contain 30 when error happens. Thanks in advanced MAC

Hello, I have a have big program that I have discussed here before that errors out now. This is about the 10th run-time error I have gotten. Others were easy to fix and now this one perplexes me. The loop below runs once then returns "Error 1004: Application-defined or Object-defined error"...

Hi Is there a way to speed up an Excel macro? I am already using ScreenUpdating = False. My spreadsheet that I am using has 270 rows but the true spreadsheet will have over 1500 rows. Is this possible or am i going to have to deal with it? Thanks in advance, MAC

Hi, I have the following code to chagne the the colors of alternating rows. Even rows are colored Green(Index of 4) and odd rows are colored yellow (index of 6). Is there any way to modify these conditions to color Row 1 a different color, say blue (index of 33)...

Hi, Is there to remove weekends from a list of dates? I run a phone report that tells me when phone calls were recieved. I run the report from say March 18 to July 25th. Assuming that there will be multiple calls per day, I need to remove the calls that were placed on weekends. The cell with...

Hi all, I was wondering if a USB thumb drive could be set to autorun a program on detection like a CD is? Second, is there to create/find a program that would run off a thumb drive to repair windows, detect viruses and adware? Thanks in advance

Is there a way to enter more than one record at a time into a table from a form? I am doing a scoring database and I need to enter the two teams and each team's color into a table at the same time. But each team needs to be a different in the table because of relationships that are setup...

I need to create a new record in TableB based on the information entered into TableA's form. How would I create the new record through VBA when a button is clicked? Thanks Matt

I have two tables TeamList table and GamesTable. I need to validate the TeamNumber value entered in GamesTable using the TeamList table, TeamId value. Thanks Matt

Does anyone know of a website, book (etc) that has a list of the Expression Builder functions listed and what each functions does? Thanks Matt