site

I have some code that is meant to save and close the workbook identified in the select statement (Wes_reference or Riv_reference) but it is not closing it. What have I left out? Sub AddReference() Dim wb1 As Workbook, wb2 As Workbook Dim sh1 As Worksheet, sh2 As Worksheet, site As String Dim...

Hi having great problems with bar codes currently using a web based site https://www.barcodesinc.com/generator/index.php to generate barcodes then cutting and pasting them into excel as a picture. The site uses Code 128b for the fonts. I downloaded said font and thought it must be better to do...

I am trying to prepare holiday data for an import into a resource planning system at work. Human Resources have provided me a spreadsheet of all our sites (100+) and which holidays each site observes from 2019 through to the end of 2025. Sites are listed in column A. The date of the holiday...

All, I have a workbook that contains site names, technology at each site, then multiple columns where my KT teams can enter times for conducting knowledge transfer. Column A - Site Name; typically have 4-6 rows containing the Site name Column B - Technology; in rows for each site, there are...

Hello Everyone, I was hoping there might be someone within this forum that has come across this issue before. I would like to set up some code to review a sharepoint site for the most current file that has been uploaded on to the site. The URL for the site is...

I am trying to extract data in the table in this site. https://www.dw16.com/indicative-price-and-info/?dw=SAWA16C2001A Using various method, eg. web query, ie automation. I can't find a way to extract data. When open with IE, web page will say you need to use chrome or firefox to open the...

Hi everybody, I haven't been able to figure this one out on my own. I'll try to keep this as simple as possible. I need to search the rows of data for duplicate entries of Last Name (Col A), First Name (Col B) and Location (Col AB). I have 3 radio buttons used to select the sorting of the...

<tbody> <colgroup><col width="536" style="width: 402pt; mso-width-source: userset; mso-width-alt: 19602;"> <col width="145" style="width: 109pt; mso-width-source: userset; mso-width-alt: 5302;"> <tbody> Site list Site list...

I need to autogenerate a number in a cell when other data in the row is filled out. Sheet is basically: Date Site Name several other columns of non relevant data Work Order Number I need the WO number to be in the following format: (4 digit site code)-1920-(next...

The copy and insert on macro “InsertAtLevel1” functions to copy the named range “l1insert” and paste at a row named range “insertPointL1” At the moment there are two reports site ABC and site DEF. But user my create further reports from the “l1insert” template The level 1 insert is working ok...

Access 365 I have a QBF with a combobox "CboGrouping" that tells the report the tow grouping the user wants. (code from Allen Brown) Now I need to add the correct fields in the Header area... i.e. if case 1, then District Header would be [District] and District Header would be [District]...

Hi all, New user and couldn't seem to find exactly what I was after, so hopefully below makes some sense. Context: I'm looking at utility spend across our portfolio of around 100 locations, each location is a different size and spend is location specific. What I'm trying to pull out is any...

I am going nuts trying to figure this out! I am needing to navigate to a site and login through VBA to scrap some data. (which I have done several times before) I cannot for the life of me figure out the HTML for this particular site...

Sorry to ask , but is there a site like this for Access?

Hi all, I have some multiple workbooks that I have saved on a sharepoint site that have macros to open other workbooks on that site and pull data out of them This all works fine, except sometimes when I open the other workbooks from the sharepoint site. excel seems to open the workbook in...

Hi All I'm finding a solution to this problem of mine some what tricky! Hopefully someone a lot smarter than me will have an answer. I have a spreadsheet that records accidents for multiple sites, 1 row = a new accident Along the row it has a date of the accident in column B, further along in...

Hi, Brand new here, and I'm having a little trouble with the site. First problem I ran into is trying to paste VBA code onto a post. I click the "paste as plain text" button, a window pops up, I hit ctrl+v, submit it, and nothing happens. Sometimes the window won't even pop up. I've also...

Hi All I'm trying to speed up a process and in need to your help. I requested something similar a while back in an earlier post but can't adapt it. Here's what I do right now for each new tab. Sheet1 (Called Data) holds duplicate site names in Col A and staff names in Col B (sometimes...

Dear SirI want to enter data (roll numbers) from excel in site http://rajresults.nic.in/resbserx19.htm and the and extract the data received in excel. I had tried to write the code which is given below but unable to extract percentage or data from site. Please help. Private Sub...

i currently have a couple of tables on a workbook. i am wanting to use some conditional formatting that will highlight certain cells when a criteria is met and will change the highlighted cells when the criteria is changed. i am able to highlight one cell using conditional formatting, but is...