Recent content by cmz21

I was able to get it working using pppoe. I am away from that machine right now, but when I am there I will post some details as to what I did. thanks for all your input.

Check in task manager to see if there is an instance of excel running in the background before you open the sheet. If there is one running, it can cause this to happen. I have found that if I run a macro prior to opening a sheet and all objects are not cleared at the end of the macro, it...

Thank you for the info.....I will try this when I can amd let you know how I make out.

Hello, I am very new to linux - I have just installed Yoper on a laptop that I have. I am not sure how to get it to connect to the internet. I previously had windows xp running on the machine and did not have any trouble to connecting. I have a DSL modem connected to the laptop. Is there a...

I have solved my own problem. In my coding, I stupidly didn't take into consideration that I was creating a new workbook and was trying to reference the second sheet before it was actually created. I moved that line of code to the end of my sub and it worked fine. thanks

hello, I am using the following code to create a formula in a cell which refers to a cell on another worksheet - xlSheet.Range("I21").Formula = "='Worksheet Name'!E29" Every time I try to run the code, a browse for file dialog box opens up. How can I tell the code to use the named worksheet...

It is as small as it can be at the moment. The problem isn't necessarily the size of the taskbar, it's that sometimes it won't autohide. I don't know if a program running might keep it from hiding, but it just won't disappear.

Hello, I have the taskbar set to autohide, but sometimes it does not disappear. This causes problems because sometimes I can't see action buttons at the bottom of the screen because they are hidden by the taskbar. Does anyone have any idea what might be causing the taskbar to not autohide...

I think I may be able to use a list box - however this will make me have to create one report at a time. I would like to be able to select the whole list and have it work by creating a new excel workbook for each location. Can this be done? Thanks

I actually have 2 queries that I would like to use the same table variable for. Each location report will have multiple worksheets driven from different queries, so an access report probably won't work.

Hello, I have a table that lists all locations for a customer. I have to create a seperate report for each location. How do I set a query to use the values in the location table as the filters for each run. I want to use vba to run through the query multiple times using each location value in...

yeah...I now like using firefox as well. I did find, however, that uninstalling and reinstalling IE did the trick. Still no idea what exactly happened, but it's working now. Thanks for any help. cmz

I have tried your second suggestion and it seemed to have worked. I have been able to transfer this into vba and it is working fine. Thanks for your help.

I tried using range("A:A").value = range("A:A").value in my vba, but that didn't seem to do anything. I will try your second solution. Thanks

Yes, but how can I get the text cell 09 to be interpreted as number value without the 0. I want to perform grouping on the column, but it won't group 9 with 09. So even if I change the 9 number format cells to a text, they still will not be grouped together because of the 0.