I really need to give myself a little more credit.
Thanks for your help Geoff. I was able to get the UNC to work on my end. I just need the various users to test the change.
I have a couple of macros where I had set the path in the code, not realizing at the time that because of different rights, not everyone has the same path. Also, it is not good to hard code the path if drive letters and such are eventually changed.
For example, one person may have
P:\LoanData\...
John - I used the above code from another macro I have. For that particular macro the "Save As" did not work because I needed a certain number of commas at the end of the file and though I had selected a range, the Save As was not capturing thoses trailing commas.
My macro skills are not strong...
I just compared the spreadsheet that was used in August to the spreadsheet that is causing an issue today and one thing that did not work correctly is the validation of a formula causing an error. There is a #REF! error in for one of the records. The following code did not catch that for some...
I have code that in August when I created was working fine. For some reason today, the csv file that is created is empty. I have not changed anything to the code and when I step through the code things look like they work, but the file is empty.
Here is the code that calls the procedure that...
I am using Powerpoint 2002 SP3. In Print Preview under options I checked off the box to show slide numbers for my handout, however the slide numbers are not appearing.
Any ideas of what I may be doing wrong?
Thanks
I am using Crystal XI.
What I would look to do is display data as follows
Year Value Year Value Year Value
2007 100000 2012 53000 2017 0
2008 150000 2013 0 2018 155000
2009 106000 2014 53000 2019 0
2010 200000 2015...
I am using Crystal XI and was wondering is using running total the only and best way to create a weighted average the does not include zero values?
The weighted average function includes zero values in the weighting and the user does not want that to happen.
Thanks
I am wondering, if somehow, if a person typed N/A in a date field if that could have damaged the integrity of either Excel spreadsheet or the link to Access?
I just noticed a user entered N/A in Excel in a column that is a date in SQL Server.
We have a proces where users inter information in Excel and Access linked to that data. Access is used to extract that data and append it to a table in SQL Server. The rows get added to SQL Server, however, not all of the data is populated.
Looking at the Excel spreadsheet only the data in the...
Not that I did not read them it is more like when you are not familiar with something and the sources provided to you are useless it is a little more difficult to grasp. Remember I have only created one presentation. Now if we were talking about Excel, I would have caught A LOT quicker.
Thanks...
Hmm..if I were to use 10 individual slides wouldn't I have to click the keyboard to move to each slide and wouldn't it look like the slides are changing? That is not the effect I want. I want to look, for example, as it would if I were on a web page and there is a box or location with imagines...
We are using Powerpoint 2002 and I have created only 1 Powerpoint before. The idea I have for a Powerpoint presentation I want to show is probably advanced for my level.
Within my powerpoint presentation I would like one of the slides to act like some web page setups meaning. I have about 10...
We are using BO XI and are sending a file via FTP. The person who is receiving the file would like a naming convention of source_pos_yyyymmdd.txt where yyyymmdd is the current date - 1 or - 3 if the day the report is run is a Monday. Note, the data in the report has the same date criteria.
Is...
I have created a dynamic parameter that has 4 levels. The first level only has to types of data and L or an S and for some reason only the L is displayed. Why is that?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.