Search results for query: *

I have the below code that copies .csv files into Access. I would like Access to read the file create date from the .csv files properties and write it to the table that I am importing into. I am not fluent in VBA and the code below was not written by me so I need help. Can this be done easily...

Yes, both Excel and Citrix are running on the same box.

No, the VB is in Excel doing a screen scrape from Reflections. Long story short, the program worked perfectly until our division was sold off and we had to start administering ourselves. So for some reason something has changed. We use the same programs, but are now through Citrix. It worked...

When I click on Tools - references in the VBA module, I see I am missing the Reflection for HP reference. Guessing this is of some importance??? How can I download that reference? Is it part of Office or part of REflections?

A popup that states Compile Error, cannot find Project or Library. It highlights this line.. Set Session = System.ActiveSession I also tried changing that line to Set Session = System.ActiveSession Again, this is through Citrix, not sure if that's relevant??

I am not getting any other compile errors, just the session error. But as I stated, I could be doing something wrong.

I changed this line... Set Sessions = System.Sessions to Set Session = System.ActiveSession Error stopped as it did before, variable not defined, Again, thank you!

I need to add another caveat, Reflections is being run through Citrix, I am assuming that will make a difference? I tried changing per the suggestion above and still get the same error. I can open Excel either on my desktop or thru Citrix and I get the same error. Thank you for helping a non...

I will admit that I do not know VBA so please bear with my ignorance. I work for a very small company and we do not have any experts in this area. Enough about that. I have the following code that does a screen scrape from Reflections - Attachmate and its not working. The error I get is Compile...