Search results

Chris, thanks for the help. Actually the code is built in vb6 and compiled to dll, this is a customized visio application that uses the dll. Here is the old code "like I said it worked for all locations execpt Austria" it's something like that. somwhere inside the code, remember Status is...

I'm working on a software that was developed by someone who left the company. The problem is that the software works for all locations execpt one that is in austria, after debuging I found out that there is a statement in the code that uses boolean true or false, the only way it worked is when I...

Does anyone know how I can check what vba engine I have installed in my machine. Thanks.

Hi, When I open my excel sheet it doesn't updated the link to other workbooks because there is some proteced sheets, does anbody know how I can create the automatic link in vba. Thanks.

Hi, Does anybody know how to create a link to another workbook in vba? Thanks.

Thanks, I tried it but I'm still doing something wrong because I"m getting an error msg, here is my code. FilePath = "C:\Test" FileName = "table.xls" '<==this could change in a loop SheetName = "Sheet1" MsgBox FilePath & "\" & "[" & FileName & "]" & _ SheetName.Cells(3...

I'm trying to build an array that pastes a value after it reads the table from another excel file. For example, I have Excel File "A", I want to read from File "B" this is similar to vlookup that goes to another excel file that is closed. But I want to do this in vba, all I'm looking for is the...

Hi, Can someone help, does anyone know how I can read values from an excel file, basically I have an excel sheet that I'm doing some vba work and I need to go to the excel sheet which resides some where, read the table and apply the values in my current excel file. I hope that I didn't confuse...

I have some visio maps. Is there anyway I can connect Access to visio. I want to create a link from ms access to visio, has anyone done that? Please provide some assistance if you have a clue? Thanks.

I got it thanks for all your help.

Hi Bat17 thanks for your help. But you please give me some more assitance. Where do I call the sub. I mean I copeid everything, then i created a button on the form and after that onlick event I typed call funFindXLS, but the i get a messae argument not optional. Please help me.

I tried the link but it didn't really help me. I'm trying to store all the file names in a table. Like I said I have a folder with almost 250 excel files and I need to store the file names in a table. I will keep trying!!! thanks.

HI I hope that someone can help me, I know it's not that hard, but I have never done it. Actually, I have a folder that has like 340 excel files. Is there a way I can write a vba code in either excel or access to get the file names in like a table or so, it's gonna take for ever to type them in...

I do apologize for everyone in here for posting Pat's name as a topic. Please accept my apology. And forgive me if I offended anyone in here. Pat per your respond!!!!!! I don't know if I explained it wrong. But All I want is to get the visio data to an access table. Access is blank now and I...

How do I link or import access to visio. I can't find visio in the list. Please Help. Thanks Pat I know tha you are so smart.

Linkinig Access to Visio I want to link an access database to a visio map. How can I find the driver for visio. Please Help. thanks.

I want to do this in either excel or access. for instance I'm trying to add 1 hr to the time I started work. for example if the field is 8:00 Am how do I make it 9:00 AM after adding for example 1. Thanks.

Sorry for trying to help, actually tihs is something my friend has asked me to help him with, i don't think that is a database it's an old mainframe system, what they do now is open the mainframe and the run a vba macro to copy the screen data into the excle sheet which is like a letter formate...

Pat this is a mainframe system that has customer fields, I need to create a script in excel to copy the fields and past them into excel.

hi guys I hope to get help on this, I have an excel sheet which is like a letter with fields that I need to copy from mainframe. Does anyone know how to do it. Please help if you can, this is important for me. I need a macro in excel to copy fields from the mainframe system to the excel defined...