Search results for query: *

Hoping someone can help with this tough one..... I have a chart bar graph with many series. The series derive their data from DataSet1. I want to hide various series based upon a multiselect parameter. Tye multiselect parameter derives it's information from a different Dataset than the...

I have a report that is formatted for users to look at online. Contains extra rows of descriptive information, logo, etc. The online users are happy with the report and don't want any changes. There is another group of users that need to download the report and import the downloaded report...

Thank you for your response. Option 3 removes the ability to utilize the attachments in the sharepoint list. I tried this yesterday using: http://sharepoint911.com/blogs/laura/Lists/Posts/Post.aspx?List=676af157%2D7d96%2D4e15%2Da987%2D54b8a3e4d948&ID=3 The company I work for will not...

Hi All. I'm very new to Sharepoints and Sharepoint Designer. I've used Sharepoint Designer to create workflow e-mails (barely). That's the extent of my exposure to this software. I have a sharepoint list. I've been asked to create columns that only my team will be able to view and modify...

I got it! The solution was as simple as using the Explorer View path address to the Sharepoint folder: \\parentsharepoint.com\subfolder\subsubfolder It works great!!! Thanks for your help!

I'm having issues with the coding using "oApp.Namespace("http://YOURSHAREPOINTADDRESS/").CopyHere FileNameZip". The problem I'm having is with the FileNameZip. I keep getting an "object required" error message. How can I define FileNameZip as any file with the extension of ".zip*"?

:-( Is there any other method to move the newly zipped file?

I've been trying to get the below coding to work for moving the newly zipped file to a sharepoint, but I keep getting the error message that the path to the sharepoint doesn't exist. The path works fine for the unzipped, open Excel file... Anyone have any ideas on what could be the hangup...

I've been using the below coding to copy unzipped, open Excel workbooks to a Sharepoint: buildSaveDest = "http://YOURSHAREPOINTADDRESS/" & ActiveWorkbook.Name 'Build Save As dest Application.ActiveWorkbook.SaveAs buildSaveDest 'Save current File to SharePoint

I've found and have used some VBA coding to zip an Excel file. It works well. I now want to copy that zipped file to a sharepoint. I have coding to save a current workbook to a sharepoint, folder, etc. I do NOT have coding to call up the file I just zipped and move that newly zipped file to...

TAT refers to Turn Around Time. Thank you! I'll look into your suggestions...

I'm trying to average a TAT calculation and am having issues. The data being returned is always 0.00. The TAT calculation comes in with the use of a stored procedure called GetWorkDays. The stored procedure basically does a DateDiff while factoring weekends and company holidays out of the...

Thank you, Skip!!! It works GREAT!!!!

I'm not checking column B for the final blank cell. That was just from trying many different things to get the coding to work. Do you have an example of the coding needed for defining the range and then assigning their values? The blank cells can be 3 in a row or 150 in a row. Different at...

I have the following code that I'm trying to utilize to copy data down to blank cells in Excel: 'COPYING DATA DOWN INTO EACH ROW Range("A2").Select Do Until ActiveCell.Offset(0, 1) = "" If ActiveCell.Offset(1, 0) = "" Then ActiveWorkbook.Names.Add Name:="TASK"...