Search results

Cool - I added a button - turns off updating / calculates / turns it back on. Thanks!

Hi - I have an XLSM file running and it calculates REALLY slowly when I'm viewing code. When I close the view code window, the calculation happens very quickly. You can the VBA window flashing as if it's updating the screen as it calculates. Any cheats to make re-calculating faster with VBA open?

Thanks. Doesn't seem to help. I didn't see successful application and/or it seems the function gives you the total # of pages in the PDF, not the page you are currently looking at. Also, it seems the API would only work if I maybe use an Adobe control, versus using a web-browser. But right now...

Hello - I have a form that has a web-browser-control that opens up PDFs. Is there any way to "grab" the page # that the person is viewing when they, say, click a button on the form? The PDF within the web-browser shows the page #, but I'm not aware of an easy way to grab that page #. But perhaps...

It doesn't seem to work if you have a worksheet open as an object.

So I have two recordsets open using ADO. One holds the Excel table. One is referring to an Access table. is there a quick way to say Contents of RS1 get added to Contents of RS2?

I think I can use this? Anyone have hints / things to watch out for? https://support.microsoft.com/en-us/topic/excelado-demonstrates-how-to-use-ado-to-read-and-write-data-in-excel-workbooks-bfb26f12-ba6a-91be-7fd4-4aadf1ff1afa

So to transfer from recordset to excel, you can just use this: ExcelRange.CopyFromRecordset RecordsetObjectName Nothing similar to go back to Access? For Transfer Spreadsheet, I wonder if you have to save the Excel file each time (say you're running back calcs)? I'd like to import from Excel...

Hi - I have some good coding that takes a recordset in Access and plugs it into a range in Excel (so that I don't have to move cell by cell). But does anyone have a trick to take a whole range in Excel and suck it back into an Access table, without going cell by cell? Thanks!

Thanks! Let me know please if you find that.

The coding above, for example, is good coding, but doesn't handle Binary. But thanks!!!

Thanks. I'm going with the route of using Cmd prompt via VBA... that might do the trick and have less limitations, and allow me to change Binary values.

Sorry I wasn't clear. I wasn't against WS. I didn't think theDBguy's example was even using that.

I don't think this does the trick, but thanks - most of the examples I found online use Windows scripting. But few address the Binary issue.

Anyone have code that can read/write registry values, including (importantly) Hex/Binary values? THANKS!

NICE GUYS!!!

Thanks. Worth trying. Any other takers on a possibly simpler process (TIF side)?

Hi - we received thousands of .bin files. They are in actuality either TIF or PDF files, but we're not told which. Any VBA coding to determine if a file is a TIF or PDF file? Thanks!

Right - in my case I load a table with possible values and the user can then see a "Legend" of possible values. Normally I use contextual drop-downs to show the "legend" but this scenario was different.

That was perfect. Thanks again. Now, when I know the form and the field, I have a mapped table that tells the user - here are the translations of various codes in those fields.