Recent content by mac7attack

Sorry not to include this. But I am using Excel 2003 on a W2k box. Thanks Matt

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...

Just so that anyone reading this post can know the answer here it is. Sub ExportTest() Dim appAccess As New Access.Application Set appAccess = CreateObject("Access.Application") Dim strDB As String Dim TN As String TN = Date$ & " " & Time$ MsgBox TN ActiveWorkbook.Save strDB = "C:\db1.mdb"...

I have tested the script in the last post and now getting an error. "External table is not in the expected format." I know in Excel the file name (4th parameter) is a spreadsheet but I am running the script from the spreadsheet that needs to be imported. Where should I specify the Spreadsheet...

Thanks for the quick response PH So the following should work? Dim appAccess as New Access.Application Set appAccess = CreateObject("Access.Application") appAccess.DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "TestNameTest", "db1.mdb", True Thanks Matt

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...

I did some research within VBA help and found this code snippet. Private Sub ConnectionApp_SheetPivotTableUpdate(ByVal shOne As Object, Target As PivotTable) MsgBox "The SheetPivotTable connection has been updated." End Sub The question is does what "shOne" and "Target" are make a difference?

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...

That is helpful Thanks Jon Matt

Looks like good. Thanks John Just one question, What does template match="@*|node()" do? It look likes it implenting itself again Thanks Matt

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>...

The solution above looks good for hiding/showing one tag of xml but how do tell the javascript that there are two or more tags to hide/show. <Questions> <question> <ask>How would I install software?</ask> <answer> <text>Explainging installing</text> <pic>pic1.jpg</pic> <text>More...