Search results for query: *

I surprised you hung on for as long as you did - Many Thanks!

If I create the Control from an XL file I can see the Spreadsheet, when I assign a new file to the control, it fails.

Yes but Still trouble - For simpilicty I named my control to OLEUnboundName

Yes - Actually I have it set to a variable first xlFile = "S:\Proposal\"& me.document & ".xls" me.OLEUnboundName.SourceDoc = xlFile Ive checked the filename and its correct..

Yes - Actually by Default Enabled was NO and Locked was Yes. Changed them to Yes and No respectively and Still get an error: Cant Link the OLE Object or the bound or Unbound Object Frame

OLEClass : Microsoft Excel 2003 DisplayType : Content UpdateOptions : Automatic OLEType : embedded OLETypeAllowed : Linked Class : Excel.Sheet.8

Thanks for the help - I do get this error though: - Can't perform the operation specified in the Action Property of the visual basic procedure you're trying to run. Any Ideas why?

I'd like the ability to view an Excel Spreadsheet in an Access Form - Using a field on the form to indicate the filename of the xl Document.. Is this possible? If so, How?

Is it possible to view a PDF File in a form? If so can someone give em some guidance.. I tried inserting the acrobat reader activex component on a form but I cant figure out how to load a file into it. thanks in advance Steve

I'd like to have some code that can see an existing and open excel document, go to pre-named cells and retrieve the data to then be put into an access table. I want to do this from Access.. I know how to send the data to the tables. I just need to know how to get access to see the open excel...

Can anyone direct me in how I can store a matrix of 12 Insertion points. Currently Im doing the Following Dim IP (12, 0 to 2) as Double IP(1, 0) = 21.25: IP(1, 1) = 23.5: IP(1, 2) = 0 IP(2, 0) = 23.625: IP(2, 1) = 23.5: IP(2, 2) = 0 IP(3, 0) = 26: IP(3, 1) = 23.5: IP(3, 2) = 0 IP(4, 0) = 21.25...

Can anyone provide some code on how to connect ACCESS TO AUTOCAD? Specifically I need to Insert a block in a drawing from an access form.

Could anyone provide some basic code from access vba on inserting a block? Im having trouble understanding how to gain access to the Autocad enviornment from ACCESS. Im assuming that Autocad will be running in the background, and I just want to call the current drawing, and simply place a...

I have a series of events happing in some code and as each one completes Id like a Progress bar to grow.. Ive made a new form with the bar and I call it up in the fist line of code (userform.show), at each place in the code I want the bar to grow I simply call it (userform.progressbar.width =...

The Code is long - Here's the upper section. Private Sub fetch_Click() Dim FSO As FileSystemObject Dim DocPath As String Set FSO = CreateObject("Scripting.FileSystemObject") DocPath = ThisWorkbook.Worksheets("Sheet1").Range("A101").Value vJobNo =...

Im trying to copy files in Excel and I keep getting Access Denied to the Files.. I dont have them open else where so Im confused why I'd be getting this.. Is there a work around?

WOW! Thanks for all your time to explain that! With Gratitude - Steve

Thanks - Im a newbie with this - could you please post some code on how to pull the value from the cell?

How Do I set a Cell Value in an Excel Worksheet to a VBA Variable that is accessable to all my code in a workbook?

is it possible to have one worksheet cell list the name of a different worksheet tab name?